drd_organizational_units
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 |