/mcpTable 148: Indexes in Department Table index_keys index_description index_name DepartmentID Clustered, unique, primary key located on PRIMARY XPKDepartment Table 149: Fields in Department Table Keys and NULL Option Data Type Description Name NOT NULL CHANGESTAMP Changestamp for the table. ChangeStamp NULL DBINT Maps Customer to Department in a CCMP/CCDM deployment. CustomerDefinitionID NULL DBDATETIME Records the date and time when a record is added/updated. DateTimeStamp NOT NULL DBCHAR Deleted Flag. Stored as a character: • Y = Yes • N = No Deleted NOT NULL DBINT A unique identifier that identifies a department in CCDM/CCMP deployment. DepartmentID NULL DESCRIPTION Description for the Department. Description NOT NULL VARCHAR(32) Enterprise name of the Department. EnterpriseName Department _Member This table associates the User Group ID with a Department. Related Tables • User_Group • Department Table 150: Indexes for Department_Member Table index_keys index_description index_name UserGroupID, DepartmentID PRIMARY Key XPKUser_Group_Department Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 212 All Tables Department _Member