Cisco Cisco IPCC Web Option Technical References

NOT NULL

DBDATETIME

The Central Controller date and time at the start of the interval.

DateTime

NULL

DBDATETIME

Date and time of the agent’s last state change.

DateTimeLastStateChange

NULL

DBDATETIME

Date and time the agent logged into the skill group.

DateTimeLogin

NULL

DBINT

Reserved for future use

FutureUseInt1

NULL

DBINT

Reserved for future use

FutureUseInt2

NULL

DBINT

Reserved for future use

FutureUseInt3

NULL

DBINT

Reserved for future use

FutureUseInt4

NULL

DBINT

Reserved for future use

FutureUseInt5

NULL

DBINT

Agent’s priority in the skill group.

Priority

NULL

DBINT

Code received from the peripheral indicating the reason for the
agent’s last state change.

ReasonCode

PK, FK NOT NULL

DBINT

Together with SkillTargetID identifies the skill group member.

SkillGroupSkillTargetID

PK, FK NOT NULL

DBINT

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 

. To see

database rules for these tables, click 

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)