Cisco Cisco IPCC Web Option Technical References
2-354
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Skill_Group Table
Skill_Group Table
Each row describes a skill group associated with a peripheral. A skill group is a collection of agents who
have common skills.
have common skills.
Use the Skill Group Explorer tool to add, update, and delete Skill_Group records.
Table 2-355 Skill_Group Table Constraints
Constraint
Field Name(s)
PK
SkillTargetID
AK-1
EnterpriseName
AK-2
PeripheralID
PeripheralNumber
Priority
PeripheralNumber
Priority
FK
BaseSkillTargetID
MRDomainID
PeripheralID
ScheduleID
SkillTargetID
MRDomainID
PeripheralID
ScheduleID
SkillTargetID
IE-1
ScheduleID
IE-2
BaseSkillTargetID
Table 2-356 Skill_Group Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
AvailableHoldoffDelay
Number of seconds before an agent becomes
available after a call terminates. If this value is
0xFFFF, then the default value from the Peripheral
record is used.
available after a call terminates. If this value is
0xFFFF, then the default value from the Peripheral
record is used.
DBSMALLINT
NOT NULL
BaseSkillTargetID
If Priority is not 0, indicates the base group for the
skill. If this record is for the base group, Priority is
0 and this field is NULL.
skill. If this record is for the base group, Priority is
0 and this field is NULL.
DBINT
FK, IE-2
NULL
ChangeStamp
Incremented when the record is changed in the
central database.
central database.
CHANGESTAMP
NOT NULL
ConfigParam
A string of parameters the ICM software sends to
the peripheral to initialize the skill group.
the peripheral to initialize the skill group.
varchar(255)
NULL