Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-12
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Agent_Skill_Group_Half_Hour Table
Related tables:
Agent (via SkillTargetID)
Device Target (via NetworkTargetID)
Media Routing Domain (via MRDomainID)
Service (ServiceSkillTargetID maps to Service.SkillTargetID)
Skill Group (SkillGroupSkillTargetID maps to SkillGroup.SkillTargetID)
Agent_Skill_Group_Half_Hour Table
Central database only.
Each row provides half-hour statistics for a member of a skill group. If an individual agent is a member
of multiple skill groups, multiple Agent Skill Group Half Hour rows are created for that agent each half
hour.
of multiple skill groups, multiple Agent Skill Group Half Hour rows are created for that agent each half
hour.
The ICM software generates an Agent_Skill_Group_Half_Hour records for each skill group member.
Routable
Indicates whether the agent is routable with respect
to this Media Routing Domain:
to this Media Routing Domain:
Y = Yes, the agent is routable.
N = No, the agent is not routable.
N = No, the agent is not routable.
int
NULL
DateTimeLastModeChange
The date and time of the agent’s last mode change. datetime
NULL
CallsInProgress
The number of tasks associated with this Media
Routing Domain on which this agent is currently
working.
Routing Domain on which this agent is currently
working.
int
NULL
MaxTasks
The maximum number of tasks associated with this
Media Routing Domain on which this agent can
work simultaneously.
Media Routing Domain on which this agent can
work simultaneously.
int
NULL
AvailableInMRD
The agent’s availability status with respect to the
Media Routing Domain:
Media Routing Domain:
0 = Not Available
1 = ICM Available
2 = Application Available
1 = ICM Available
2 = Application Available
int
NULL
DateTimeTaskLevelChange
The date and time of the agent’s last task level
change.
change.
datetime
NULL
Table 2-7
Agent_Real_Time Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option