/mcpindex_keys index_description index_name PeripheralID, PersonID Unique key XAK1Agent_Map PeripheralID, PeripheralNumber Unique key XAK2Agent AgentDeskSettingsID Inversion key XIE2Agent ScheduleID Inversion key XIE3Agent EnterpriseName Inversion key XIE4Agent DateTimeStamp Inversion key XIE6Agent Table 5: Fields in Agent Table Keys and NULL Option Data Type Description Name FK, IE-2 NULL DBINT Identifies the agent desk settings associated with the agent. AgentDeskSettingsID NOT NULL DBCHAR Indicates whether the software collects agent state trace data for the agent: • Y = Yes • N = No AgentStateTrace NOT NULL CHANGESTAMP Incremented when the record is changed in the central database. ChangeStamp NULL varchar(255) A string of parameters the software sends to the peripheral to initialize the agent. ConfigParam NULL DBDATETIME Records the date and time when the record was added/updated. DateTimeStamp NULL DBINT Provides different agents on the same peripheral the ability to have calls reported against a unique default skill group. For all calls where the peripheral default skill group would usually be used (agent-initiated outbound calls, or inbound calls queued to an agent when a skill group is not provided), the DefaultSkillGroup would be used instead. DefaultSkillGroup NOT NULL DBCHAR Deleted Flag. Stored as a character: • Y = Yes • N = No Deleted Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 18 All Tables Agent