drd_organizational_units
- Benn Oshrin
Owned by Benn Oshrin
| 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 |