Technical References

Keys and Null Option:Data Type:Description:Field Name:
NOT NULLDBDATETIME
The Central Controller date and time at the start of the interval.
DateTime
NULLDBDATETIME
Date and time of the agent’s last state change.
DateTimeLastStateChange
NULLDBDATETIME
Date and time the agent logged into the skill group.
DateTimeLogin
NULLDBINT
Reserved for future use
FutureUseInt1
NULLDBINT
Reserved for future use
FutureUseInt2
NULLDBINT
Reserved for future use
FutureUseInt3
NULLDBINT
Reserved for future use
FutureUseInt4
NULLDBINT
Reserved for future use
FutureUseInt5
NULLDBINT
Agent’s priority in the skill group.
Priority
NULLDBINT
Code received from the peripheral indicating the reason for the
agent’s last state change.
ReasonCode
PK, FK NOT NULLDBINT
Together with SkillTargetID identifies the skill group member.
SkillGroupSkillTargetID
PK, FK NOT NULLDBINT
The SkillTargetID of the agent. Together with
SkillGroupSkillTargetID identifies the skill group member.
SkillTargetID
Agent_State_Trace Table
This table is one of the Agent Detail tables in the Skill Target category (page 456). To see
database rules for these tables, click here (page 510).
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 ICM 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 ICM/IPCC
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 for Agent_State_Trace
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
49
Chapter 2: All Tables
Agent_State_Trace Table