Performitor

User Tools

Site Tools

Trace:
fw_orgstructure

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision		Previous revision
fw_orgstructure [2025/03/04 07:09] – created gloriafw_orgstructure [2025/03/11 12:23] (current) – gloria
Line 1: Line 1:
 ====== Introduction: ======   ====== Introduction: ======  
  
-The **`orgstructure`** table defines the hierarchical organizational units for a given client. It is closely related to the **`orgstructuremaster`** table, with each entry in this table representing a specific organizational entity within the master structure. The table stores details such as organization names, codes, parent-child relationships, associated branches, and ordering within the hierarchy.  +The **`orgstructure`** table defines the hierarchical organizational units for a given client. It is closely related to the **`orgstructuremaster`** table, with each entry in this table representing a specific organizational entity within the master structure. The table stores details such as organization names, codes, parent-child relationships, associated branches, and ordering within the hierarchy.  
 +  
 +**Note: osname and oscode should be the same as the graph option name.**
  
 Below is the detailed structure of the table, listing each column, its data type, and its purpose.   Below is the detailed structure of the table, listing each column, its data type, and its purpose.  
  
-```dokuwiki 
 ^ Name         ^ Type           ^ Comments                                                                 | ^ Name         ^ Type           ^ Comments                                                                 |
 | id          | int            | Unique identifier for each organizational structure entry.              | | id          | int            | Unique identifier for each organizational structure entry.              |
Line 20: Line 21:
 | modifiedby  | int            | ID of the user who last modified this record.                          | | modifiedby  | int            | ID of the user who last modified this record.                          |
 | modifiedon  | datetime       | Timestamp when the record was last modified.                           | | modifiedon  | datetime       | Timestamp when the record was last modified.                           |
-``` 
  
-====== Example Data: ======   
  
-```dokuwiki +
-^ id  ^ masterosid ^ osname                        ^ oscode                        ^ parentosid ^ branchid ^ moduleids ^ osorder ^ status ^ createdby ^ createdon           ^ modifiedby ^ modifiedon          | +
-| 2   | 1         | Cluster Midden                | Cluster Midden                | 0          | 1        | 1         | 1       | 1      | 996       | 2022-05-26 07:28:02 | 0          | 0000-00-00 00:00:00 | +
-| 3   | 1         | Cluster West                  | Cluster West                  | 0          | 1        | 1         | 3       | 1      | 996       | 2022-05-26 07:28:14 | 0          | 0000-00-00 00:00:00 | +
-| 4   | 1         | Cluster Zuid                  | Cluster Zuid                  | 0          | 1        | 1         | 4       | 1      | 996       | 2022-05-26 07:28:24 | 0          | 0000-00-00 00:00:00 | +
-| 5   | 1         | Cluster Zuid-West             | Cluster Zuid-West             | 0          | 1        | 1         | 5       | 0      | 996       | 2022-05-26 07:28:36 | 0          | 0000-00-00 00:00:00 | +
-| 1   | 1         | Cluster Noord                 | Cluster Noord                 | 0          | 1        | 1         | 2       | 1      | 996       | 2022-05-26 07:27:50 | 0          | 0000-00-00 00:00:00 | +
-| 909 | 2         | Stilleweer (in Appingedam)    | Stilleweer (in Appingedam)    | 1          | 1        | 1         | 8       | 1      | 996       | 2022-05-26 07:31:15 | 0          | 0000-00-00 00:00:00 | +
-| 23  | 2         | IJsselhof (in Gouda)          | IJsselhof (in Gouda)          | 3          | 1        | 1         | 18      | 1      | 996       | 2022-05-26 07:32:23 | 0          | 0000-00-00 00:00:00 | +
-| 24  | 2         | Ockenburgh (in Den Haag)      | Ockenburgh (in Den Haag)      | 3          | 1        | 1         | 24      | 1      | 996       | 2022-05-26 07:32:37 | 0          |                      | +
-```+
fw_orgstructure.1741072180.txt.gz · Last modified: 2025/03/04 07:09 by gloria