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

Both sides previous revisionPrevious revision
Next revision		Previous revision
fw_orgstructure [2025/03/04 07:09] – 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.  
Line 21: Line 23:
  
  
-====== Example Data: ======   
- 
- 
-^ 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.1741072192.txt.gz · Last modified: 2025/03/04 07:09 by gloria