/mcpTable 308: Indexes for Reason_Code Table index_keys index_description index_name ReasonCode nonclustered, unique, unique key located on PRIMARY XAK1Reason_Code ReasonCodeID clustered, unique, primary key located on PRIMARY XPKReason_Code Table 309: Fields in Reason_Code Table Keys and NULL Option Data Type Description Name NOT NULL CHANGESTAMP Incremented when the record is changed in the central database. ChangeStamp NULL DBDATETIME Records the date and time when a record is added/updated. DateTimeStamp NOT NULL DBCHAR Default value is N. Deleted NULL DESCRIPTION The description of the reason code. Description AK-1 NOT NULL DBINT Reason code used by agents (configurable). [In addition to reason codes that you have defined, Unified CCE uses some predefined reason codes. See Reason Codes, on page 675.] Note In Packaged CCE, 21 pre-defined global reason codes of Not Ready and Logout types are added to the Reason_Code table. ReasonCode PK NOT NULL DBINT A unique identifier created by the schema. ReasonCodeID NOT NULL varchar(40) Text associated with the reason code numeric value. ReasonText NOT NULL DBSMALLINT Indicates the type of reason code like: Not Ready, Wrap up, and Sign Out. Allowed values are 1,2,3. Reason Type NOT NULL DBCHAR Denotes that the reason code is global(applicable for all the teams by default/team specific). Allowed values are Y/N(Yes/No) IsGlobal Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 366 All Tables Reason_Code