Cisco Cisco E-Mail Manager Unity Integration Option Technical References
2-233
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Skill_Group Table
Related tables:
Service (via SkillTargetID)
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-174 Skill_Group Table
Field Name
Description
Data Type
Keys and Null
Option
Option
SkillTargetID
An identifier that is unique among all skill targets in the
enterprise.
enterprise.
int
PK, FK, NOT
NULL
NULL
ScheduleID
Identifies an imported schedule associated with the skill
group.
group.
int
FK, IE1, NULL
PeripheralID
Foreign key from Peripheral table.
smallint
AK1, FK, NOT
NULL
NULL
EnterpriseName
An enterprise name for the skill group. This name must be
unique among all skill groups in the enterprise.
unique among all skill groups in the enterprise.
varchar(32)
AK2, NOT
NULL
NULL
PeripheralNumber
Skill group number as known by the peripheral.
int
AK1, NOT
NULL
NULL
PeripheralName
Skill group name as known by the peripheral.
varchar(32)
NOT NULL
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.
after a call terminates. If this value is 0xFFFF, then the
default value from the Peripheral record is used.
smallint
NOT NULL
Priority
The routing priority of this group for the skill:
1 = primary
2 = secondary
3 = tertiary; etc.
2 = secondary
3 = tertiary; etc.
Note
The value 0 indicates a base skill group.
smallint
AK1, NOT
NULL
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.
If this record is for the base group, Priority is 0 and this
field is NULL.
int
FK, IE2, NULL
Extension
The extension number for the service (used by Lucent
DEFINITY ECS).
DEFINITY ECS).
varchar(10)
NULL
SubGroupMaskType
Indicates whether to use the SubSkillGroupMask field for
the skill group or to use the peripheral default:
the skill group or to use the peripheral default:
0 = Use peripheral default.
1 = Override the peripheral default.
1 = Override the peripheral default.
smallint
NOT NULL
SubSkillGroupMask
A series of characters (Y and N) indicating which
sub-skill groups to create for the skill group. Ignored if
SubGroupMaskType is 0.
sub-skill groups to create for the skill group. Ignored if
SubGroupMaskType is 0.
varchar(64)
NULL