Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-38
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Agent_Skill_Group_Real_Time Table
Agent_Skill_Group_Real_Time Table
Local database only.
Each row provides real-time statistics for a member of a skill group. If an individual agent is a member
of multiple skill groups, multiple Agent Skill Group Real Time rows are created for that agent.
of multiple skill groups, multiple Agent Skill Group Real Time rows are created for that agent.
The ICM software generates an Agent_Skill_Group_Real_Time record for each skill group member.
Table 2-21 Agent_Skill_Group_Real_Time Table Constraints
Constraint
Field Name(s)
PK
SkillGroupSkillTargetID
SkillTargetID
SkillTargetID
FK
SkillGroupSkillTargetID
SkillTargetID
SkillTargetID
Table 2-22 Agent_Skill_Group_Real_Time Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
AgentState
The current real time state of the agent:
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 = Unknown
10 = Call On Hold
11 = Active
12 = Paused
14 = Not Active
1 = Logged On
2 = Not Ready
3 = Ready
4 = Talking
5 = Work Not Ready
6 = Work Ready
7 = Busy Other
8 = Reserved
9 = Unknown
10 = Call On Hold
11 = Active
12 = Paused
14 = Not Active
DBINT
NULL
CallsInProgress
The number of tasks currently associated with this
skill group.
skill group.
DBINT
NULL
DateTime
The Central Controller date and time at the start of
the interval.
the interval.
DBDATETIME
NOT NULL
DateTimeLastStateChange
Date and time of the agent’s last state change.
DBDATETIME
NULL
DateTimeLogin
Date and time the agent logged into the skill
group.
group.
DBDATETIME
NULL
Priority
Agent’s priority in the skill group.
DBINT
NULL
ReasonCode
Code received from the peripheral indicating the
reason for the agent’s last state change.
reason for the agent’s last state change.
DBINT
NULL