cmn_department

The table below describes the cmn_department table.

This table contains the following foldable columns:

• sys_id_value
• company_value
• cost_center_value
• dept_head_value
• parent_value
• primary_contact_value
• company_display_value
• cost_center_display_value
• dept_head_display_value
• description_display_value
• description_value
• head_count_display_value
• head_count_value
• id_display_value
• id_value
• name_display_value
• name_value
• parent_display_value
• primary_contact_display_value
• sys_created_by_display_value
• sys_created_by_value
• sys_created_on_display_value
• sys_created_on_value
• sys_id_display_value
• sys_mod_count_display_value
• sys_mod_count_value
• sys_tags_display_value
• sys_tags_value
• sys_updated_by_display_value
• sys_updated_by_value
• sys_updated_on_display_value
• sys_updated_on_value

The primary key columns in this table are returnable.

Column Name	SQL Type	Updatable	Nullable
sys_id_value Primary Key	SQL_VARCHAR(64)	False	False
company_value Foreign Key linked to column sys_id_value in core_company table	SQL_VARCHAR(64)	True	True
cost_center_value Foreign Key linked to column sys_id_value in cmn_cost_center table	SQL_VARCHAR(64)	True	True
dept_head_value Foreign Key linked to column sys_id_value in sys_user table	SQL_VARCHAR(64)	True	True
parent_value Foreign Key linked to column sys_id_value in cmn_department table	SQL_VARCHAR(64)	True	True
primary_contact_value Foreign Key linked to column sys_id_value in sys_user table	SQL_VARCHAR(64)	True	True
company_display_value	SQL_VARCHAR(500)	True	True
cost_center_display_value	SQL_VARCHAR(500)	True	True
dept_head_display_value	SQL_VARCHAR(500)	True	True
description_display_value	SQL_VARCHAR(2000)	True	True
description_value	SQL_VARCHAR(2000)	True	True
head_count_display_value	SQL_VARCHAR(500)	True	True
head_count_value	SQL_INTEGER(signed)	True	True
id_display_value	SQL_VARCHAR(500)	True	True
id_value	SQL_VARCHAR(80)	True	True
name_display_value	SQL_VARCHAR(500)	True	True
name_value	SQL_VARCHAR(200)	True	True
parent_display_value	SQL_VARCHAR(500)	True	True
primary_contact_display_value	SQL_VARCHAR(500)	True	True
sys_created_by_display_value	SQL_VARCHAR(500)	False	True
sys_created_by_value	SQL_VARCHAR(80)	False	True
sys_created_on_display_value	SQL_VARCHAR(500)	False	True
sys_created_on_value	SQL_TIMESTAMP	False	True
sys_id_display_value	SQL_VARCHAR(500)	False	False
sys_mod_count_display_value	SQL_VARCHAR(500)	False	True
sys_mod_count_value	SQL_INTEGER(signed)	False	True
sys_tags_display_value	SQL_VARCHAR(500)	False	True
sys_tags_value	SQL_VARCHAR(256)	False	True
sys_updated_by_display_value	SQL_VARCHAR(500)	False	True
sys_updated_by_value	SQL_VARCHAR(80)	False	True
sys_updated_on_display_value	SQL_VARCHAR(500)	False	True
sys_updated_on_value	SQL_TIMESTAMP	False	True