Cisco Cisco IP Contact Center Release 4.6.1 テクニカルリファレンス

ページ / 557
Keys and Null
Option:
Data Type:
Description:
Field Name:
NOT NULL
DBINT
The default value of the ServiceLevelThreshold field for
services associated with this peripheral and media routing
domain.
ServiceLevelThreshold
NOT NULL
DBSMALLINT
The default value for the ServiceLevelType field for each
service associated with this peripheral and media routing
ServiceLevelType
domain. This value indicates how the ICM software
calculates the service level.
For IPCC Enterprise
 the value of this field is always
1 (ignore abandoned calls) for CallManager peripherals.
This is because calls to a CallManager peripheral have
no service associated with them while they are queued,
and therefore calls abandoned while queued cannot affect
the computation of service level for a CallManager
service.
Service_Member Table
To see database rules for these tables, click
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.
Use the Service Explorer tool to add, update, and delete Service_Member records.
Related tables
 (ServiceSkillTargetID maps to Service.SkillTargetID)
 (SkillGroupSkillTargetID maps to Skill_Group.SkillTargetID)
Table 191: Indexes for Service_Member Table
index_keys
index_description
index_name
SkillGroupSkillTargetID
nonclustered located on PRIMARY
XIE1Service_Member
ServiceSkillTargetID,
SkillGroupSkillTargetID
clustered, unique, primary key
located on PRIMARY
XPKService_Member
Fields in Service_Member Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
DBSMALLINT
The priority level of the specified service for the
speci
fied skill group:
Priority
• 1 = Primary
• 2= Secondary
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
298
Chapter 2: -  All Tables
Service_Member Table