Cisco Cisco Unified Contact Center Enterprise 9.0(1) Technical References

Page of 404
 
2-234
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Skill_Group Table
Related tables:
Enterprise Skill Group Member (via SkillTargetID)
Media Routing Domain (via MRDomainID)
Peripheral (via PeripheralID)
Schedule (via ScheduleID)
Service Member (via SkillTargetID)
Skill Group Five Minute (via SkillTargetID)
Skill Group Half Hour (via SkillTargetID)
Skill Group Member (via SkillTargetID)
Skill Group Real Time (via SkillTargetID)
ConfigParam
A string of parameters the ICM software sends to the 
peripheral to initialize the skill group.
varchar(255)
NULL
Description
Additional information about the group.
varchar(255)
NULL
Deleted
Deleted Flag. Stored as a character:
Y = Yes
N = No
char(1)
NOT NULL
MRDomainID
The Media Routing Domain with which this skill group is 
associated. The default value is 1.
int
FK NOT NULL
IPTA
Indicates whether or not this is an 'ICM picks the agent 
(IPTA)' skill group:
Y = Yes, this is an IPTA skill group.
N = No, this is not an IPTA skill group.
char(1)
NOT NULL
DefaultEntry
Normal entries are 0 (zero). Any records with 
DefaultEntry value > (greater than) 0 will be considered a 
default skill group for configuration purposes. Records 
having a DefaultEntry value of 1 are used by OPC as the 
default target skill group.
Where only a base default is created, it has a DefaultEntry 
value of 1.  If sub-skill group records are created, the 
primary sub-group has a DefaultEntry value of 1, while 
the others have a DefaultEntry value of 2.
Note
An automatic DefaultEntry is created with each 
possible combination of Peripheral and 
MRDomain (PeripheralID and MRDOmainID) in 
the system. These entries are visible to 
configuration applications but cannot be directly 
modified. 
int
NOT NULL
ChangeStamp
Incremented when the record is changed in the central 
database.
int
NOT NULL
Table 2-174 Skill_Group Table (continued)
Field Name
Description
Data Type
Keys and Null 
Option