Cisco Cisco IPCC Web Option Technical References

Route_Five_Minute Table

This table is in the 

. To see database rules for these tables, click 

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.

RecoveryKey

nonclustered, unique, unique key
located on PRIMARY

XAK1Route_Five_Minute

DateTime, RouteID, TimeZone

clustered, unique, primary key located
on PRIMARY

XPKRoute_Five_Minute

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,

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.

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

Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)