Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Keys and
Null Option:
Null Option:
Data Type:
Description:
Field Name:
NULL
DBINT
Number of calls the ICM software sent to this route
since midnight.
since midnight.
CallsRoutedToday
NOT NULL
DBDATETIME
Date and time that this data was last updated.
DateTime
NULL
DBINT
Sum of delay time of all calls to route abandoned
in queue during the rolling five-minute interval.
in queue during the rolling five-minute interval.
DelayQAbandTimeTo5
NULL
DBINT
Total handle time in seconds for calls to the route
ending during the current half-hour interval.
ending during the current half-hour interval.
HandleTimeHalf
NULL
DBINT
Total handle time in seconds for calls to the route
ending during the rolling five-minute interval.
ending during the rolling five-minute interval.
HandleTimeTo5
NULL
DBINT
Total handle time in seconds for calls to the route
ending since midnight.
ending since midnight.
HandleTimeToday
NULL
DBINT
The total hold time in seconds for calls to the route
ending during the current half-hour interval.
ending during the current half-hour interval.
HoldTimeHalf
NULL
DBINT
The total hold time in seconds for calls to the route
ending during the rolling five-minute interval.
ending during the rolling five-minute interval.
HoldTimeTo5
NULL
DBINT
The total hold time in seconds for calls to the route
ending since midnight.
ending since midnight.
HoldTimeToday
NULL
DBDATETIME
TTime that the longest call in the queue for the
route was put there.
route was put there.
LongestCallQ
NULL
DBINT
Number of overflowed in calls now in queue or in
progress for the route.
progress for the route.
OverflowInNow
NULL
DBINT
Number of overflowed out calls for the route now
in queue or in progress elsewhere.
in queue or in progress elsewhere.
OverflowOutNow
NULL
DBINT
Number of calls that rang at an agent’s terminal
and redirected on failure to answer in this service
during the current half-hour interval.
and redirected on failure to answer in this service
during the current half-hour interval.
RedirectNoAnsCallsHalf
NULL
DBINT
Number of calls that rang at an agent’s terminal
and redirected on failure to answer in this service
during the rolling five-minute interval.
and redirected on failure to answer in this service
during the rolling five-minute interval.
RedirectNoAnsCallsTo5
NULL
DBINT
Number of calls that rang at an agent’s terminal
and redirected on failure to answer in this service
since midnight.
and redirected on failure to answer in this service
since midnight.
RedirectNoAnsCallsToday
PK, FK NOT
NULL
NULL
DBINT
Foreign key from the Route table.
RouteID
NULL
DBINT
Number of calls to the route abandoned within the
ICM service level threshold during the current
half-hour interval.
ICM service level threshold during the current
half-hour interval.
ServiceLevelAbandHalf
NULL
DBINT
Number of calls abandoned within the ICM service
level threshold during the rolling five-minute
interval.
level threshold during the rolling five-minute
interval.
ServiceLevelAbandTo5
NULL
DBINT
Number of calls to the route abandoned within the
ICM service level threshold since midnight.
ICM service level threshold since midnight.
ServiceLevelAbandToday
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
252
Chapter 2: - All Tables
Route_Real_Time Table