Technical References

Keys and Null
Option:
Data Type:Description:Field Name:
Note: The value 0 indicates a base skill group.
FK, IE-1 NULLDBINT
Identifies an imported schedule associated with the skill group.
ScheduleID
NOT NULLDBINT
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 NULLDBSMALLINT
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 NULLDBINT
An identifier that is unique among all skill targets in the enterprise.
SkillTargetID
NOT NULLDBSMALLINT
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.
NULLvarchar(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 NULLDBCHAR
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