Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Fields in Agent_Skill_Group_Logout Table :
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
NULL
DBINT
Number of seconds the agent was logged in to the
skill group.
skill group.
LoginDuration
PK NOT NULL
DBDATETIME
Date and time when the agent logged out of the
skill group.
skill group.
LogoutDateTime
NULL
DBINT
Reason code returned by the peripheral for the
agent logout.
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.
internally by the ICM/IPCC Enterprise software
to track the record.
RecoveryKey
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
PK NOT NULL
DBINT
The time zone for the dates and times. The value
is the offset in minutes from UTC (formerly called
GMT).
is the offset in minutes from UTC (formerly called
GMT).
TimeZone
Agent_Skill_Group_Real_Time Table
This table is in the
. 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
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
49
Chapter 2: All Tables
Agent_Skill_Group_Real_Time Table