McDewey

Multi-vendor documentation library · semantic search · MCP endpoint at /mcp

Page 490

↗ View in doc context
page
490
source
ucce/v15.0.1/db-schema-handbook/db-schema-handbook.md
chunk_id
ucce::v15.0.1::db-schema-handbook::db-schema-handbook::476

Keys and NULL Option Data Type Description Name YES DBINT The number of seconds that agents spent in the ACTIVE state or the PAUSED state for tasks associated with this service that ended in this reporting interval. TalkTime Service_Level_Threshold This is in the Device category (see Device, on page 618). For database rules, see Device Tables, on page 698. The Service Level Threshold table specifies how the Unified 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, on page 305 (via MRDomainID) Peripheral, on page 326 (via PeripheralID) Table 398: Indexes for Service_Level_Threshold Table index_keys index_description index_name PeripheralID, MRDomainID clustered, unique, primary key located on PRIMARY XPKService_Level_Threshold Table 399: Fields in Service_Level_Threshold Table Keys and NULL Option Data Type Description 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. ServiceLevelThreshold Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 472 All Tables Service_Level_Threshold