/mcpKeys and NULL Option Data Type Description Name NULL DBINT The priority of the agent in the skill group. Priority NULL DBINT Code received from the peripheral indicating the reason for the agent's last state change. See Reason Codes, on page 675. Note ReasonCode is supported for the Not Ready and Logged Off agent states only. ReasonCode PK, FK NOT NULL DBINT Together with SkillTargetID identifies the skill group member. For precision queue only agents, the value is the SkillTargetID for internal PQ skill group. SkillGroupSkillTargetID PK, FK NOT NULL DBINT The SkillTargetID of the agent. Together with SkillGroupSkillTargetID identifies the skill group member. SkillTargetID Agent_State_Trace This table is one of the Agent Detail tables in the Skill Target category (see Skill Target, on page 635). To see database rules for these tables, see Skill Target Tables, on page 702. Each row describes a change of state for an agent. By examining Agent State Trace rows you can trace all the state changes that have occurred for an agent. The system software generates an Agent_State_Trace records for each agent for which tracing is enabled. This table can become very large. Running custom reporting queries against it while it is on the HDS can degrade performance. To optimize performance, extract the data from the HDS into your own custom database on a separate server (one that is not used for other Unified ICM or Unified CCE components). Use only DBDateTime (date and time of the record that was written to the HDS database) to perform the extraction. The table on the custom database can be indexed according to the custom reporting needs. Related tables • Agent, on page 17 (through SkillTargetID) • Media_Routing_Domain, on page 305 (through MRDomainID) Table 26: Indexes for Agent_State_Trace Table index_keys index_description index_name DateTime, SkillTargetID, TimeZone, MRDomainID Primary key XPKAgent_State_Trace Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 68 All Tables Agent_State_Trace