Performitor

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== 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. 
 
**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.  

^ Name         ^ Type           ^ Comments                                                                 |
| id          | int            | Unique identifier for each organizational structure entry.              |
| masterosid  | int            | Foreign key linking to `fw_orgstructuremaster`.                         |
| osname      | varchar(250)   | Name of the organizational structure (e.g., Cluster Midden, Cluster West). |
| oscode      | varchar(150)   | Organization code, often mirroring the `osname`.                        |
| parentosid  | int            | ID of the parent organizational unit (0 if it is a top-level unit).     |
| branchid    | varchar(250)   | Identifies the branch this structure belongs to.                        |
| moduleids   | varchar(250)   | Stores module identifiers associated with the structure.                 |
| osorder     | int            | Defines the order of organizational units within a hierarchy.           |
| status      | int            | Indicates whether the structure is active (1) or inactive (0).          |
| createdby   | int            | ID of the user who created this record.                                 |
| createdon   | datetime       | Timestamp when the record was created.                                  |
| modifiedby  | int            | ID of the user who last modified this record.                          |
| modifiedon  | datetime       | Timestamp when the record was last modified.                           |