Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Titledrd_organizatonal_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

 

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.
    )
  • No labels