Cisco Cisco Unified Contact Center Enterprise 9.0(2) Referencia técnica
2-165
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Route_Five_Minute Table
Related tables:
Route (via RouteID)
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 (all from
Termination_Call_Detail). The HandleTime and
AvgHandleTime values are updated in the
database when the after-call work time
associated with the call (if any) is completed.
route ending during the five-minute interval.
This includes any HoldTime, TalkTime, and
WorkTime associated with the call (all from
Termination_Call_Detail). The HandleTime and
AvgHandleTime values are updated in the
database when the after-call work time
associated with the call (if any) is completed.
int
NULL
AvgDelayQNow
Average delay in queue for the route at the end
of the five-minute interval.
of the five-minute interval.
int
NULL
CallsQNow
Calls in queue for the route at the peripheral at
the end of the interval.
the end of the interval.
int
NULL
AgentsTalking
Number of agents in the Talking state for the
route at the end of the five-minute interval.
route at the end of the five-minute interval.
int
NULL
CallsLeftQTo5
Number of calls to the route that were removed
from the queue during the current five-minute
interval (includes abandoned calls).
from the queue during the current five-minute
interval (includes abandoned calls).
int
NULL
CallsAnsweredToday
Number of calls to the route answered since
midnight.
midnight.
int
NULL
CallsAnsweredTo5
Number of calls to the route answered during the
five-minute interval.
five-minute interval.
int
NULL
RecoveryDay
A value used internally by the ICM software to
track virtual time.
track virtual time.
int
NOT NULL
RecoveryKey
A value used internally by the ICM software to
track virtual time.
track virtual time.
float
AK1, NOT
NULL
NULL
Table 2-141 Route_Five_Minute Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option