Technical References

Each row contains real time information about a route. The ICM software generates a
Route_Real_Time record for each route.
Related Table
Route (page 277) (via RouteID)
Table 163: Indexes for Route_Real_Time Table
index_keysindex_descriptionindex_name
RouteIDclustered, unique, primary key located
on PRIMARY
XPKRoute_Real_Time
Fields in Route_Real_Time Table:
Keys and Null
Option:
Data Type:Description:Field Name:
NULLDBINT
Number of agents for the route currently in the talking state
AgentsTalking
NULLDBINT
Sum of answer wait time in seconds for all calls offered to the route
during the current half-hour interval.
AnswerWaitTimeHalf
NULLDBINT
Sum of answer wait time in seconds for all calls offered to the route
during the rolling five-minute interval.
AnswerWaitTimeTo5
NULLDBINT
Sum of answer wait time in seconds for all calls offered to the route
since midnight.
AnswerWaitTimeToday
NULLDBINT
Average delay time of abandoned calls in queue for the route during
the rolling five-minute interval: DelayQAbandTimeTo5 /
CallsAbandQTo5.
AvgDelayQAbandTo5
NULLDBINT
Average delay for calls to the route currently in queue.
AvgDelayQNow
NULLDBINT
Average handle time in seconds for calls to the route ending during
the rolling five-minute interval: HandleTimeTo5 /
CallsHandledTo5.
AvgHandleTimeTo5
NULLDBINT
Average answer wait time for all calls offered to the route during
the rolling five-minute interval: AnswerWaitTimeTo5 /
CallsOfferedTo5.
AvgSpeedAnswerTo5
NULLDBINT
Average talk time in seconds for calls to the route ending during
the rolling five-minute interval: TalkTimeTo5 / CallsHandledTo5.
AvgTalkTimeTo5
NULLDBINT
Number of calls to this route abandoned while in queue or ringing
during the current half-hour interval.
CallsAbandQHalf
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
293
Chapter 2: All Tables
Route_Real_Time Table