Cisco Cisco IP Contact Center Release 4.6.1 Riferimenti tecnici
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
AK-2 NOT
NULL
NULL
DBINT
Skill group number as known by the peripheral.
PeripheralNumber
AK-2 NOT
NULL
NULL
DBSMALLINT
The routing priority of this group for the skill:
Priority
• 1 = primary
• 2 = secondary
• 3= tertiary; etc.
Note:
The value 0 indicates a base skill group.
FK, IE-1 NULL
DBINT
Identifies an imported schedule associated with the
skill group.
skill group.
ScheduleID
NOT NULL
DBINT
The service level threshold, in seconds, for the ICM
service level.
service level.
ServiceLevelThreshold
If this field is negative, the value of the
ServiceLevelThreshold field in the
Service_Level_Threshold table (for this
Peripheral/MRD pair) is used.
The default value is -1 which means SL computation
is disabled for this SG.
ServiceLevelThreshold field in the
Service_Level_Threshold table (for this
Peripheral/MRD pair) is used.
The default value is -1 which means SL computation
is disabled for this SG.
NOT NULL
DBSMALLINT
Indicates how the ICM software calculates the service
level for the skillgroup.
level for the skillgroup.
ServiceLevelType
If this field is 0, the ICM uses the default specified
for the associated Peripheral/MRD pair in the
Service_Level_Threshold table.
for the associated Peripheral/MRD pair in the
Service_Level_Threshold table.
PK, FK, NOT
NULL
NULL
DBINT
An identifier that is unique among all skill targets in
the enterprise.
the enterprise.
SkillTargetID
NOT NULL
DBSMALLINT
Indicates whether to use the SubSkillGroupMask field
for the skill group or to use the peripheral default:
for the skill group or to use the peripheral default:
SubGroupMaskType
• 0 = Use peripheral default.
• 1 = Override the peripheral default.
NULL
varchar(64)
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.
SubSkillGroupMask
NOT NULL
DBCHAR
Indicates if the record can by deleted by a user.
Default is Y.
Default is Y.
UserDeletable
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
316
Chapter 2: - All Tables
Skill_Group Table