drd_organizational_units

Owned by Benn Oshrin
Last updated: Mar 30, 2014
1 min read
Titledrd_organizational_units
TypeDictionary
DescriptionOrganizational Unit/Departmental Hierarchy

It is possible to represent multiple hierarchies by having multiple top-level organizational_units (ie: where parent_organizational_unit_idis NULL) and by using organizational_unit_t.

ColumnFormatNullableDescriptionDefinitionComments
idinteger, primary key(error)Row identifierautoincrement 
codevarchar(100)(tick)Institution-specific code for this organizational unit  
name

varchar(100)

(error)Name of this organizational unit  
campus_idinteger, foreign key(tick)Campus this organizational unit is located ondrd_campuses:id 
parent_organizational_unit_idinteger, foreign key(tick)Parent organizational unitdrd_organizational_units:id 
organizational_unit_tinteger, foreign key(error)Type of this organizational unit

ctx_data_types:id

data_type=ORGANIZATIONAL_UNIT

eg: academic, finance, reporting

languagevarchar(16)(tick)Language encoding of this nameRFC 5646 

 

Migration Notes From OR 1

  • organizational_unit_t is now a foreign key (
    Error rendering macro 'jira' : Unable to locate Jira server for this macro. It may be due to Application Link configuration.
    )
  • language added ( Unable to locate Jira server for this macro. It may be due to Application Link configuration. )