| Title | drd_organizational_units |
|---|---|
| Type | Standardized |
| Description | Organizational Unit/Departmental Hierarchy |
It is possible to represent multiple hierarchies by having multiple top-level organizational_units (ie: where parent_organizational_unit_id is NULL) and by using organizational_unit_t.
| Column | Format | Nullable? | Description | Definition | Comments |
|---|---|---|---|---|---|
| id | integer, primary key | No | |||
| code | varchar(100) | Institution-specific code for this organizational unit | |||
| name | varchar(100) | No | Name of this organizational unit |
| |
| campus_id | integer, foreign key | Campus this organizational unit is located on | prd_campuses:id | ||
| parent_organizational_unit_id | integer, foreign key | Parent organizational unit | drd_organizational_units:id | ||
| organizational_unit_t | integer, foreign key | No | Type of this organizational unit (eg: academic, finance, reporting) | ctx_data_types:id | datatype=ORGANIZATIONAL_UNIT |