/mcpTable 334: Indexes for Route_Five_Minute Table index_keys index_description index_name RecoveryKey Nonclustered, unique, unique key located on PRIMARY XAK1Route_Five_Minute DateTime, RouteID, TimeZone Clustered, unique, primary key located on PRIMARY XPKRoute_Five_Minute Table 335: Fields in Route_Five_Minute Table Keys and NULL Option Data Type Description Name NULL DBINT Number of agents in the Talking state for the route at the end of the five-minute interval. AgentsTalking NULL DBINT Average delay time of abandoned calls in queue for the route during the five-minute interval. AvgDelayQAbandTo5 NULL DBINT Average delay in queue for the route at the end of the five-minute interval. AvgDelayQNow NULL DBINT Average handle time in seconds for calls to the route ending during the five-minute interval. 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 (if any) is completed. AvgHandleTimeTo5 NULL DBINT Average answer wait time for all incoming calls to the route during the five-minute interval. AvgSpeedAnswerTo5 NULL DBINT Average talk time in seconds for calls to the route ending during the five-minute interval. Talk time is populated with the TalkTime and HoldTime associated with call to the route. AvgTalkTimeTo5 NULL DBINT Running total of calls to the route abandoned in queue since midnight. CallsAbandQToday NULL DBINT Number of calls to the route answered during the five-minute DBINTerval. CallsAnsweredTo5 NULL DBINT Number of calls to the route answered since midnight. CallsAnsweredToday Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 393 All Tables Route_Five_Minute