Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco IP Contact Center Release 4.6.1
  5. Technical References

Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Download
Page of 548
   
2-377
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
  
Chapter 2      Table Details
Skill_Group_Member Table
Related tables:
 (via SkillTargetID)
Skill_Group_Member Table
The Skill Group Member table maps agents to skill groups. Each skill group contains one or more 
member agents. Each agent can be a member of one or more skill groups.
Use the Skill Group Route Explorer tool to add, update, and delete Skill_Group_Member records.
WhisperCallsToHalf
The number of calls coached either by the 
supervisor or by the agent. 
This field is applicable for IPCC Enterprise only.
DBINT
NULL
WorkNotReadyTimeToHalf
Total time in seconds agents associated with this 
skill group were in the WORK_NOT_READY 
state during the half-hour interval. 
WorkNotReadyTime is included as in the 
calculation of LoggedOnTime.
This field is applicable for both ICM and IPCC 
Enterprise.
DBINT
NULL
WorkReadyTimeToHalf
Total seconds agents in the skill group were in the 
WORK_READY state for tasks associated with 
this skill group that ended during this half-hour 
interval. WorkReadyTime is included in the 
calculation of LoggedOnTime. 
This field is applicable for both ICM and IPCC 
Enterprise.
DBINT
NULL
Table 2-360 Skill_Group_Half_Hour Table (continued)
Field Name
Description
Data Type
Keys and 
Null Option
Table 2-361 Skill_Group_Member Table Constraints
Constraint
Field Name(s)
PK
AgentSkillTargetID
SkillGroupSkillTargetID
FK
AgentSkillTargetID
SkillGroupSkillTargetID
IE-1
AgentSkillTargetID