Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-216
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Service_Level_Threshold Table
Service_Level_Threshold Table
The Service Level Threshold table specifies how the ICM calculates service level for a particular
peripheral. Each row in this table contains specific default values for a PeripheralID-Media Routing
Domain pair.
peripheral. Each row in this table contains specific default values for a PeripheralID-Media Routing
Domain pair.
Related tables:
Media Routing Domain (via MRDomainID)
Peripheral (via PeripheralID)
Service_Member Table
The Service Member table maps skill groups to services. Each service contains one or more member skill
groups. Each skill group can be a member of one or more services.
groups. Each skill group can be a member of one or more services.
Use the Service Explorer tool to add, update, and delete Service_Member records.
Table 2-171 Service_Level_Threshold Table
Field Name
Description
Data Type
Keys and Null
Option
Option
PeripheralID
The ICM ID of the peripheral with which this row is
associated.
associated.
smallint
PK, FK, NOT
NULL
NULL
MRDomainID
Foreign key from the Media_Routing_Domain table.
int
FK, NOT NULL
ServiceLevelThreshold
The default value of the ServiceLevelThreshold field for
services associated with this peripheral and media
routing domain.
services associated with this peripheral and media
routing domain.
smallint
NOT NULL
ServiceLevelType
The default value for the ServiceLevelType field for each
service associated with this peripheral and media routing
domain. This value indicates how the ICM software
calculates the service level.
service associated with this peripheral and media routing
domain. This value indicates how the ICM software
calculates the service level.
smallint
NOT NULL
Table 2-172 Service_Member Table
Field Name
Description
Data Type
Keys and Null
Option
Option
ServiceSkillTargetID
SkillTargetID of the service.
int
PK, FK, NOT
NULL
NULL
SkillGroupSkillTargetID
SkillTargetID of the skill group that is associated with
the service.
the service.
int
PK, FK, NOT
NULL
NULL
Priority
The priority level of the specified service for the
specified skill group:
specified skill group:
1 = Primary
2 = Secondary
2 = Secondary
Any number of skill entries can be of any priority—not
all need to be entered.
all need to be entered.
smallint
NOT NULL