McDewey

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

Page 518

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

Keys and NULL Option Data Type Description Name AK-1 NOT NULL DBFLT8 A unique ID assigned to each record and used internally by the Unified CCE software to track the record. RecoveryKey NULL DBINT Time agents in the skill group spent in the Reserved state during the five-minute window. ReservedStateTime is included in the calculation of LoggedOnTime. ReservedStateTimeTo5 PK, FK NOT NULL DBINT The SkillTargetID of the agent. Together with the SkillGroupSkillTargetID, identifies the skill group member. Foreign key from skill group table. SkillTargetID NULL DBINT Number of agents in the skill group talking on inbound calls at the end of the five-minute interval. Inbound calls are ACD calls arriving on trunks (that is, calls that are not internally generated). TalkingIn NULL DBINT Number of agents in the skill group talking on internal calls (neither inbound nor outbound) at the end of the five-minute interval. Examples of "other calls include agent-to-agent transfers and supervisor calls. TalkingOther NULL DBINT Number of agents in the skill group talking on outbound calls at the end of the five-minute interval. TalkingOut NULL DBINT Number of seconds agents in the skill group were in the Talking state during the five-minute window. This field is applicable for Unified ICM, Unified CCE and Outbound Option. TalkTimeTo5 PK, NOT NULL DBINT The Central Controller’s time zone for the date and time. The value is the offset in minutes from UTC (formerly GMT).The value is negative for time zones to the east of UTC and positive for time zones to the west of UTC. TimeZone NULL DBINT This field is not used. Unused1 NULL DBINT Number of agents in the skill group in the Work Not Ready state at the end of the five-minute interval. WorkNotReady NULL DBINT Number of seconds agents in the skill group were in the Work Not Ready state during the five-minute window. WorkNotReadyTime is included in the calculation of LoggedOnTime. WorkNotReadyTimeTo5 Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 500 All Tables Skill_Group_Five_Minute