Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Titledrd_organizatonalorganizational_units
TypeDictionary
DescriptionOrganizational Unit/Departmental Hierarchy

...

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 (
    Jira Legacy
    serverJASIG Issue Tracker
    columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
    serverId76221f40-4501-3df1-8578-6c87908cbdf7
    keyORII-52
    )
  • language added (
    Jira Legacy
    serverJASIG Issue Tracker
    columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
    serverId76221f40-4501-3df1-8578-6c87908cbdf7
    keyORII-89
    )