Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Fields in Agent_Skill_Group_Real_Time Table:
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
NULL
DBINT
The current real time state of the agent. To see
the list of Agent States, click
the list of Agent States, click
AgentState
NULL
DBINT
The number of tasks currently associated with
this skill group.
this skill group.
CallsInProgress
NOT NULL
DBDATETIME
The Central Controller date and time at the start
of the interval.
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.
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.
reason for the agent’s last state change.
ReasonCode
PK, FK NOT NULL
DBINT
Together with SkillTargetID identifies the skill
group member.
group member.
SkillGroupSkillTargetID
PK, FK NOT NULL
DBINT
The SkillTargetID of the agent. Together with
SkillGroupSkillTargetID identifies the skill group
member.
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.
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.
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.
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.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
50
Chapter 2: - All Tables
Agent_State_Trace Table