Technical References

•
Agent (page 15) (via SkillTargetID)
•
Media Routing Domain (page 234) (via MRDomainID)
Table 21: Indexes for Agent_State_Trace Table
index_keysindex_descriptionindex_name
RecoveryKeynonclustered, unique, unique key
located on PRIMARY
XAK1Agent_State_Trace
DateTime, SkillTargetID, TimeZone,
MRDomainID
clustered, unique, primary key
located on PRIMARY
XPKAgent_State_Trace
Fields in Agent_State_Trace Table:
Keys and Null
Option:
Data Type:Description:Field Name:
FK NULLDBINT
The new agent state. To see the list of Agent States, click here
(page 465).
AgentState
PK NOT NULLDBDATETIME
The date and time at which the state change occurred.
DateTime
NULLDBINT
The direction for talking states.
Direction
NOT NULLDBINT
A code indicating the event that has occurred.
EventName
• 0 = LOGGED_OFF
• 1 = LOGGED_ON
• 2 = NOT_READY
• 3 = READY
• 4 = TALKING
• 5 = WORK_NOT_READY
• 6 = WORK_READY
• 7 = BUSY_OTHER
• 8 = RESERVED
• 9 = CALL_INITIATED
• 10 = CALL_HELD
• 11 = CALL_RETRIEVED
• 12 = CALL_TRANSFERRED
• 13 = CALL_CONFERENCED
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
50
Chapter 2: All Tables
Agent_State_Trace Table