/mcpKeys and NULL Option Data Type Description Name NULL DBINT The total number of calls answered by agents, IVRs, or voice-mail ports for the route during the half-hour interval. CallsAnsweredToHalf NULL DBINT Total number of calls handled on this route during the half-hour interval. CallsHandled includes all calls handled by any answering resource for the route (for example, an IVR, agent, or voice mail port). A handled call is: • An incoming ACD call that was answered by an agent, and then completed. • A non-voice task that the agent started working on then completed. A handled call/task is completed when the agent associated with the call/task finishes the wrap-up work associated with the call/task. CallsHandledToHalf NULL DBINT Total of incoming calls on this route during the half-hour interval. Incoming calls include only Inbound ACD calls arriving on trunks (that is, calls that are not internally generated). CallsIncomingToHalf NULL DBINT Total of incoming calls plus internal calls offered on this route during the half-hour interval. CallsOfferedToHalf NULL DBINT Number of calls to the route in queue during the half-hour interval. A call that queues multiple times is counted as queued once for the route. CallsQToHalf NULL DBINT Total calls the system software sent to this route during the half-hour interval. CallsRoutedToHalf PK NOT NULL DBSMALLDATE The date and time at the start of the half-hour 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 DBINT The total number of seconds that calls to the route that were abandoned in queue waited during the interval. These are calls that existed in the queue but were abandoned before being handled by an agent or trunk device. DelayQAbandTimeToHalf Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 398 All Tables Route_Half_Hour