Cisco Cisco IP Contact Center Release 4.6.2 Technical References
2-251
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Skill_Group_Member Table
Related tables:
Skill Group (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.
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.
Related tables:
Agent (AgentSkillTargetID maps to Agent.SkillTargetID)
Skill Group (SkillGroupSkillTargetID maps to Skill_Group.SkillTargetID)
InterceptCallsToHalf
The number of calls intercepted either by
the supervisor or by the agent.
the supervisor or by the agent.
int
NULL
MonitorCallsToHalf
The number of calls monitored either by the
supervisor or by the agent.
supervisor or by the agent.
int
NULL
WhisperCallsToHalf
The number of calls coached either by the
supervisor or by the agent.
supervisor or by the agent.
int
NULL
EmergencyAssistsToHalf
The number of emergency assist requests
either by the agent or by the supervisor.
either by the agent or by the supervisor.
int
NULL
CallsOfferedToHalf
The number of calls received by this skill
group for the half-hour interval.
group for the half-hour interval.
int
NULL
CallsQueuedToHalf
The number of calls queued to this skill
group by the ACD in the half-hour interval.
group by the ACD in the half-hour interval.
Note
Not applicable to IPCC.
int
NULL
InterruptedTimeToHalf
The number of seconds that agents were in
the Interrupted state with respect to this
skill group in the half-hour interval.
the Interrupted state with respect to this
skill group in the half-hour interval.
int
NULL
Table 2-176 Skill_Group_Half_Hour Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option
Table 2-177 Skill_Group_Member Table
Field Name
Description
Data Type
Keys and Null
Option
Option
SkillGroupSkillTargetID
The skill group’s SkillTargetID value.
int
PK, FK, NOT
NULL
NULL
AgentSkillTargetID
The agent’s SkillTargetID value.
int
PK, FK, NOT
NULL
NULL