McDewey

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

Page 476

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

Service_Five_Minute This table is in the Skill Target category (see Skill Target, on page 635). To see database rules for these tables, see Skill Target Tables, on page 702. It gets populated on central and HDS databases. This table contains statistics about each service during the most recent five-minute interval. The system software generates Service_Five_Minute records for each service. Use the Service Explorer tool to add, update, and delete Service_Array records. Related Table Service, on page 452 (via SkillTargetID) Table 395: Indexes for Service_Five_Minute Table index_keys index_description index_name RecoveryKey Nonclustered, unique, unique key located on PRIMARY XAK1Service_Five_Minute DateTime, SkillTargetID, TimeZone Clustered, unique, primary key located on PRIMARY XPKService_Five_Minute Table 396: Fields in Service_Five_Minute Table Keys and NULL Option Data Type Description Name NULL DBINT Number of service agents in the talking state at the end of the five-minute interval. AgentsTalking NULL DBINT Average delay time of abandoned calls in queue for the service during the five-minute interval. AvgDelayQAbandTo5 NULL DBINT Average delay for calls currently queued for the service at the end of the five-minute interval. AvgDelayQNow NULL DBINT The average handled calls time in seconds for calls to the service that ended during the five-minute interval. HandleTime is tracked only for inbound ACD calls that are counted as handled for the service. HandleTime is the time spent from the call being answered by the agent to the time the agent completed after-call work time for the call. This includes any TalkTime, HoldTime, and WorkTime associated with the call. The AvgHandleTime value is updated in the database when the after-call work time associated with the call is completed. AvgHandleTimeTo5 NULL DBINT Average answer wait time for all incoming calls to the service during the five-minute interval. AvgSpeedAnswerTo5 Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 458 All Tables Service_Five_Minute