Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Keys and Null Option:
Data Type:
Description:
Field Name:
PK NOT NULL
DBDATETIME
Date and time when the agent logged out of the skill group.
LogoutDateTime
NULL
DBINT
Reason code returned by the peripheral for the agent logout.
ReasonCode
AK-1 NOT NULL
DBFLT8
A unique ID assigned to each record and used internally by the
ICM/IPCC Enterprise software to track the record.
ICM/IPCC Enterprise software to track the record.
RecoveryKey
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.
SkillGroupSkillTargetID identifies the skill group member.
SkillTargetID
PK NOT NULL
DBINT
The time zone for the dates and times. The value is the offset
in minutes from UTC (formerly called GMT).
in minutes from UTC (formerly called GMT).
TimeZone
Agent_Skill_Group_Real_Time Table
. To see database rules for these tables, click
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.
member of multiple skill groups, multiple Agent Skill Group Real Time rows are created for
that agent.
The software generates an Agent_Skill_Group_Real_Time record for each skill group member.
Table 19: Related Table for Agent_Skill_Group_Real_Time
(SkillTargetID + SkillGroupSkillTargetID maps to
Skill_Group_Member.AgentSkillTargetID + Skill_Group_Member.SkillGroupSkillTargetID)
Table 20: Index for Agent_Skill_Group_Real_Time Table
index_keys
index_description
index_name
SkillTargetID, SkillGroupSkillTargetID
located on PRIMARY
XPKAgent_Skill_Group_Real_Time
Fields in Agent_Skill_Group_Real_Time Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NULL
DBINT
The current real time state of the agent. To see the list of Agent
States, click
States, click
.
AgentState
NULL
DBINT
The number of tasks currently associated with this skill group.
CallsInProgress
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
48
Chapter 2: All Tables
Agent_Skill_Group_Real_Time Table