Technical References

Route_Five_Minute Table
This table is in the Route category (page 447). To see database rules for these tables, click here
(page 507).
Central database only. Each row contains statistics about a route during the most recent
five-minute interval. The ICM software generates Route_Five_Minute records for each route.
Related Table
Route (page 277) (via RouteID)
Table 161: Indexes for Route_Five_Minute Table
index_keysindex_descriptionindex_name
RecoveryKeynonclustered, unique, unique key
located on PRIMARY
XAK1Route_Five_Minute
DateTime, RouteID, TimeZoneclustered, unique, primary key located
on PRIMARY
XPKRoute_Five_Minute
Fields in Route_Five_Minute Table:
Keys and
Null Option:
Data Type:Description:Field Name:
NULLDBINT
Number of agents in the Talking state for the route at the end of
the five-minute interval.
AgentsTalking
NULLDBINT
Average delay time of abandoned calls in queue for the route during
the five-minute interval.
AvgDelayQAbandTo5
NULLDBINT
Average delay in queue for the route at the end of the five-minute
interval.
AvgDelayQNow
NULLDBINT
Average handle time in seconds for calls to the route ending during
the five-minute interval. This includes any HoldTime, TalkTime,
AvgHandleTimeTo5
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.
NULLDBINT
Average answer wait time for all incoming calls to the route during
the five-minute interval.
AvgSpeedAnswerTo5
NULLDBINT
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
NULLDBINT
Running total of calls to the route abandoned in queue since
midnight.
CallsAbandQToday
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
285
Chapter 2: All Tables
Route_Five_Minute Table