/mcpKeys and NULL Option Data Type Description Name NULL DBINT Average delay time of calls to the route that were abandoned in queue during the half-hour interval. This value is calculated as follows: DelayQAbandTimeToHalf / CallsAbandQToHalf AvgDelayQAbandToHalf NULL DBINT Average delay in seconds for calls queued for the route during the half-hour interval. The value is calculated as follows: DelayQTimeToHalf / CallsQToHalf AvgDelayQToHalf NULL DBINT The average handled calls time in seconds for calls counted as handled for the route during the half-hour 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. This value is calculated as follows: HandleTimeToHalf / CallsHandledToHalf. The AvgHandleTime value is counted when the after-call work time associated with the call is completed, and the database is updated every half hour. AvgHandleTimeToHalf NULL DBINT Average answer wait time for all incoming calls to the route in the half-hour interval. This value is calculated as follows: AnswerWaitTimeToHalf / CallsAnsweredToHalf AvgSpeedAnswerToHalf NULL DBINT The average talk time in seconds for calls to the route. Talk time includes the time that calls were in a talking or hold state. It is populated with the TalkTime and HoldTime associated with call to the route (from Termination_Call_Detail). This value is calculated as follows: TalkTimeToHalf / CallsHandledToHalf .The field is counted when all after-call work associated with the call is completed, and the database is updated every half hour. AvgTalkTimeToHalf NULL DBINT The number of calls that were blind transferred out for this route during the half-hour interval. BlindTransfersOutToHalf NULL DBINT Number of calls abandoned in queue on this route during the half-hour interval. CallsAbandQToHalf Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 397 All Tables Route_Half_Hour