Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco IPCC Web Option
  5. Technical References

Cisco Cisco IPCC Web Option Technical References

Download
Page of 548
   
2-266
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2      Table Details
Route_Five_Minute Table
 (RCDRecoveryKey maps to Route_Call_Detail.RecoveryKey)
Route_Five_Minute Table
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.
Table 2-287 Route_Five_Minute Table Constraints
Constraint
Field Name(s)
PK
DateTime
RouteID
TimeZone
AK-1
RecoveryKey
FK
RouteID
Table 2-288 Route_Five_Minute Table
Field Name
Description
Data Type
Keys and 
Null Option
AgentsTalking
Number of agents in the Talking state for the route 
at the end of the five-minute interval.
DBINT
NULL
AvgDelayQAbandTo5
Average delay time of abandoned calls in queue 
for the route during the five-minute interval.
DBINT
NULL
AvgDelayQNow
Average delay in queue for the route at the end of 
the five-minute interval.
DBINT
NULL
AvgHandleTimeTo5
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.
DBINT
NULL
AvgSpeedAnswerTo5
Average answer wait time for all incoming calls to 
the route during the five-minute interval.
DBINT
NULL
AvgTalkTimeTo5
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. 
DBINT
NULL
CallsAbandQToday
Running total of calls to the route abandoned in 
queue since midnight.
DBINT
NULL
CallsAnsweredTo5
Number of calls to the route answered during the 
five-minute DBINTerval.
DBINT
NULL