Title | drd_organizatonal_units |
---|---|
Type | Dictionary |
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 | Row identifier | autoincrement | ||
code | varchar(100) | Institution-specific code for this organizational unit | |||
name | varchar(100) | Name of this organizational unit | |||
campus_id | integer, foreign key | Campus this organizational unit is located on | drd_campuses:id | ||
parent_organizational_unit_id | integer, foreign key | Parent organizational unit | drd_organizational_units:id | ||
organizational_unit_t | integer, foreign key | Type of this organizational unit |
eg: academic, finance, reporting |
Migration Notes From OR 1
is now a foreign key (see ORII-8)organizational_unit_t