Technical References

Keys
and
Null
Option:
Data Type:Description:Field Name:
Not valid for non-voice tasks. Set to zero by OPC.
Service_Level_Threshold Table
This is in the Device (page 441) category. For database rules, click here (page 504).
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.
Related tables
Media Routing Domain (page 234) (via MRDomainID)
Peripheral (page 250) (via PeripheralID)
Table 191: Indexes for Service_Level_Threshold Table
index_keysindex_descriptionindex_name
PeripheralID, MRDomainIDclustered, unique, primary key
located on PRIMARY
XPKService_Level_Threshold
Fields in Service_Level_Threshold Table:
Keys and Null
Option:
Data Type:Description:Field Name:
PK NOT NULLDBINT
Foreign key from the Media_Routing_Domain table.
MRDomainID
PK, FK NOT NULLDBSMALLINT
The ICM ID of the peripheral with which this row is associated.
PeripheralID
NOT NULLDBINT
The default value of the ServiceLevelThreshold field for services
associated with this peripheral and media routing domain.
ServiceLevelThreshold
NOT NULLDBSMALLINT
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.
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.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
346
Chapter 2: All Tables
Service_Level_Threshold Table