Cisco Cisco Administrative Workstation Technical References
2-40
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Agent_State_Trace Table
Agent_State_Trace Table
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.
all the state changes that have occurred for an agent.
The ICM software generates an Agent_State_Trace records for each agent for which tracing is enabled.
Table 2-23 Agent_State_Trace Table Constraints
Constraint
Field Name(s)
PK
DateTime
MRDomain
SkillTargetID
TimeZone
MRDomain
SkillTargetID
TimeZone
AK-1
RecoveryKey
FK
AgentState
MRDomain
SkillGroupSkillTargetID
SkillTargetID
MRDomain
SkillGroupSkillTargetID
SkillTargetID
Table 2-24 Agent_State_Trace Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
AgentState
The new agent state:
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
14 = Unknown.
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
14 = Unknown.
DBINT
FK
NULL
DateTime
The date and time at which the state change
occurred.
occurred.
DBSMALLDATE
PK
NOT NULL
Direction
The direction for talking states.
DBINT
NULL