Cisco Cisco IP Contact Center Release 4.6.2 Technical References

Page of 404
 
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.
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:
Y = Yes, the agent is 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.
int
NULL
MaxTasks
The maximum number of tasks associated with this 
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:
0 = Not Available
1 = ICM Available
2 = Application Available
int
NULL
DateTimeTaskLevelChange
The date and time of the agent’s last task level 
change.
datetime
NULL
Table 2-7
Agent_Real_Time Table (continued)
Field Name
Description
Data Type
Keys and Null 
Option