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 620
Skill_Group_Member Table
This table is one of the Skill Group Member Detail tables in the 
. To see database rules for these tables, click 
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.
Related tables
 (AgentSkillTargetID maps to Agent.SkillTargetID)
 (SkillGroupSkillTargetID maps to Skill_Group.SkillTargetID)
Table 198: Indexes for Skill_Group_Member Table
index_keys
index_description
index_name
AgentSkillTargetID
nonclustered located on PRIMARY
XIE1Skill_Group_Member
SkillGroupSkillTargetID,
AgentSkillTargetID
clustered, unique, primary key
located on PRIMARY
XPKSkill_Group_Members
Fields in Skill_Group_Member Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
PK, FK, IE-1 NOT NULL
DBINT
The agent’s SkillTargetID value.
AgentSkillTargetID
PK, FK NOT NULL
DBINT
The skill group’s SkillTargetID value.
SkillGroupSkillTargetID
Skill_Group_Real_Time Table
. To see database rules for these tables, click
Local database only. Contains real time information about each skill group.
The ICM software generates a Skill_Group_Real_Time record for each skill group.
Related table
 (via SkillTargetID)
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
392
Chapter 2:  All Tables
Skill_Group_Member Table