Cisco Cisco IP Contact Center Release 4.6.2 Technische Referenzen

Seite von 620
Keys and Null
Option:
Data Type:
Description:
Field Name:
Note: The value 0 indicates a base skill group.
FK, IE-1 NULL
DBINT
Identifies an imported schedule associated with the skill group.
ScheduleID
NOT NULL
DBINT
The service level threshold, in seconds, for the ICM 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.
NOT NULL
DBSMALLINT
Indicates how the ICM software calculates the service 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.
Possible values:
• 0 = Use Default
• 1 = Ignore Abandoned Calls
• 2 = Abandoned Call Has Negative Impact:
• 3 = Abandoned Call Has Positive Impact:
PK, FK, NOT NULL
DBINT
An identifier that is unique among all skill targets in the enterprise.
SkillTargetID
NOT NULL
DBSMALLINT
Indicates whether to use the SubSkillGroupMask field 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.
SubSkillGroupMask
NOT NULL
DBCHAR
Indicates if the record can by deleted by a user. Default is Y.
UserDeletable
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
367
Chapter 2:  All Tables
Skill_Group Table