Table

cm_co_departments

Description

Per-CO Departments

Column

Format

Description

Definition

Comments

id

integer, primary key

Row identifier

autoincrement


co_id

integer, foreign key

CO Record ID

cm_cos:id


cou_idinteger, foreign keyCOU Record IDcm_cous:id
namevarchar(128)Name

description

varchar(128)

Description



typevarchar(32)CO Department type

Added in Registry v3.3.0.

May be configured on a per-CO basis. See Extending the Registry Data Model.

introductiontext(4000)Brief introduction describing department
Intended for rendering in Service Portal or Department Directory

leadership_co_group_id

integer, foreign key

CO Group ID describing the leadership (eg: chairs, VPs, etc) of the Department

cm_co_groups:id


administrative_co_group_idinteger, foreign keyCO Group ID describing the administrators (eg: department admin) of the Departmentcm_co_groups:id
support_co_group_idinteger, foreign keyCO Group ID describing the support staff (eg: technical or administrative assistants) of the Departmentcm_co_groups:id