cmn_department
Stores departmental information such as department names, hierarchies, and assigned managers.
Columns
| Name | Type | ReadOnly | References | Description |
| cost_center | String | False |
Specifies the cost center associated with the department, linking departmental activities to financial accounts for budgeting and reporting. | |
| sys_updated_on | Datetime | False |
Displays the date and time when the department record was last updated in the system. | |
| dept_head | String | False |
Lists the department head responsible for managing the department's operations and staff. | |
| primary_contact | String | False |
Specifies the primary contact person for the department, typically used for communication and coordination. | |
| head_count | String | False |
Indicates the total number of employees currently assigned to the department. | |
| sys_created_by | String | False |
Lists the user or process that originally created the department record in the Common Department (cmn_department) table. | |
| name | String | False |
Specifies the official name of the department used across the organization. | |
| id | String | False |
Contains the unique identifier assigned to the department for internal reference and integration purposes. | |
| description | String | False |
Provides a brief summary of the department's purpose, scope, or functions within the organization. | |
| sys_id [KEY] | String | False |
Provides the system identifier (sys_id) that uniquely identifies the department record in ServiceNow. | |
| sys_created_on | Datetime | False |
Displays the date and time when the department record was first created. | |
| sys_mod_count | String | False |
Tracks the number of times the department record has been modified. | |
| company | String | False |
Specifies the company or organizational entity to which the department belongs. | |
| parent | String | False |
References the parent department, if the current department is part of a larger departmental hierarchy. | |
| sys_updated_by | String | False |
Lists the user or process that last updated the department record. | |
| ItemURL | String | True |
Displays the web address (URL) where the department record can be accessed from the ServiceNow user interface (UI). |