/mcpKeys and NULL Option Data Type Description Name NULL DBINT Sum of delay time of all calls in queue for the route during the half-hour interval. This field is populated with the LocalQTime from the Termination_Call_Detail record. DelayQTimeToHalf NULL DBINT The number of calls to the route that were determined to be closed following an interruption in data during the half-hour interval. ForcedClosedCalls are calls that terminated because of errors tracking the call's state transition. Calls may become forced closed if there is lack of events from the ACD's CTI interfaces (for example, a lack of a Disconnect event, or failure on the switch's CTI connection). ForcedClosedCallsToHalf NULL DBINT The total time in seconds that calls were handled for the route during the half-hour interval. Handle time is tracked only for inbound ACD calls that are counted as handled for the route. 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 HoldTime, TalkTime, and WorkTime associated with the call. The HandleTime and AvgHandleTime values are updated in the database when the after-call work time associated with the call is completed. HandleTimeToHalf NULL DBINT Total hold time in seconds for calls to the route that ended during the half-hour interval. HoldTimeToHalf NULL DBINT The longest time in seconds a call was in queue for the route before being abandoned during the half-hour interval. This includes the LocalQTime, DelayTime, and RingTime. LongestCallAbandTime NULL DBINT The longest time in seconds a call was in queue for the route before being answered during the half-hour interval. This includes the LocalQTime for the call. LongestCallDelayQTime NULL DBINT Number of calls that the peripheral retargeted, or overflowed, into the route during the half-hour interval. The system software keeps counts of the number of calls moved out of each service or route (overflowed out) and moved into each service or route (overflowed in). OverflowInToHalf Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 399 All Tables Route_Half_Hour