Cisco Cisco IP Contact Center Release 4.6.2 Technical References
Keys
and
Null
Option:
and
Null
Option:
Data Type:
Description:
Field Name:
Not valid for non-voice tasks. Set to zero by OPC.
Service_Level_Threshold Table
category. For database rules, click
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
(via PeripheralID)
Table 191: Indexes for Service_Level_Threshold Table
index_keys
index_description
index_name
PeripheralID, MRDomainID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKService_Level_Threshold
Fields in Service_Level_Threshold Table:
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
PK NOT NULL
DBINT
Foreign key from the Media_Routing_Domain table.
MRDomainID
PK, FK NOT NULL
DBSMALLINT
The ICM ID of the peripheral with which this row is associated.
PeripheralID
NOT NULL
DBINT
The default value of the ServiceLevelThreshold field for services
associated with this peripheral and media routing domain.
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 domain. This value
indicates how the ICM software calculates the service level.
associated with this peripheral and media routing domain. This value
indicates how the ICM software calculates the service level.
ServiceLevelType
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.
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.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
346
Chapter 2: All Tables
Service_Level_Threshold Table