Technical References

Keys and Null Option:Data Type:Description:Field Name:
PK NOT NULLDBDATETIME
Date and time when the agent logged out of the skill group.
LogoutDateTime
NULLDBINT
Reason code returned by the peripheral for the agent logout.
ReasonCode
AK-1 NOT NULLDBFLT8
A unique ID assigned to each record and used internally by the
ICM/IPCC Enterprise software to track the record.
RecoveryKey
PK, FK NOT NULLDBINT
Together with SkillTargetID identifies the skill group member.
SkillGroupSkillTargetID
PK, FK NOT NULLDBINT
The SkillTargetID of the agent. Together with
SkillGroupSkillTargetID identifies the skill group member.
SkillTargetID
PK NOT NULLDBINT
The time zone for the dates and times. The value is the offset
in minutes from UTC (formerly called GMT).
TimeZone
Agent_Skill_Group_Real_Time Table
This table is in the Skill Target category (page 456). To see database rules for these tables, click
here (page 510).
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.
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
Skill Group Member (page 392) (SkillTargetID + SkillGroupSkillTargetID maps to
Skill_Group_Member.AgentSkillTargetID + Skill_Group_Member.SkillGroupSkillTargetID)
Table 20: Index for Agent_Skill_Group_Real_Time Table
index_keysindex_descriptionindex_name
SkillTargetID, SkillGroupSkillTargetIDlocated on PRIMARYXPKAgent_Skill_Group_Real_Time
Fields in Agent_Skill_Group_Real_Time Table:
Keys and Null Option:Data Type:Description:Field Name:
NULLDBINT
The current real time state of the agent. To see the list of Agent
States, click here (page 465).
AgentState
NULLDBINT
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