McDewey

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

Page 55

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

Keys and NULL Option Data Type Description Name NULL DBINT The number of seconds in the reporting interval that this agent was available for this Media Routing Domain. An agent is available, or eligible to be assigned a task in this MRD, if the agent meets all these conditions: 1. The agent is in any state other than Not Ready state for this MRD. 2. The agent is not working on a non-interruptible task in another MRD. 3. Only email tasks are interruptible, meaning that system software can assign agents another task while they are working on an email. Voice calls, and chat sessions cannot be interrupted. 4. The agent has not reached the maximum task limit for this MRD. For voice calls, the task limit is always one task. For email and chat, the maximum task limit is configurable and can be more than one task. The agent is considered eligible to be assigned emails or chat until the maximum task limit is reached for that MRD. AvailableInMRDTime PK NOTNULL DBSMALLDATE The Central Controller date and time at the start of the interval. DateTime IE-1 NULL DBDATETIME The current date and time stamp when the records are written to the HDS database. The logger database has NULL for this column. DbDateTime NULL varchar(32) The last extension the agent was logged in to during this interval. Extension NULL DBINT Total time, in seconds, the agent was logged in to this Media Routing Domain during the reporting interval. LoggedOnTime PK NOTNULL DBINT Identifies the Media Routing Domain. MRDomainID NULL DBINT Total time, in seconds, the agent was in the Not Ready state with respect to this Media Routing Domain during the reporting interval. (In the Not Ready state, agents are logged on, but are not involved in any call handling activity, or available to handle a call.) NotReadyTime NULL DBINT Indicates how many non-ACD calls the agent answered on one of the non-ACD lines. Only populated when Multiline feature is enabled. NonACDLineCallsInCount Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 37 All Tables Agent_Interval