Cisco Cisco E-Mail Manager Unity Integration Option Technical References
2-276
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Route_Real_Time Table
CallsOfferedToday
Number of incoming calls plus internal calls
offered on this route since midnight.
offered on this route since midnight.
DBINT
NULL
CallsQNow
Number of calls to the route in queue now at the
peripheral.
peripheral.
DBINT
NULL
CallsQNowTime
Total queue time in seconds for all calls to the
route currently in queue.
route currently in queue.
DBINT
NULL
CallsRoutedHalf
Number of calls sent on this route during the
current half-hour interval.
current half-hour interval.
DBINT
NULL
CallsRoutedToday
Number of calls the ICM software sent to this
route since midnight.
route since midnight.
DBINT
NULL
DateTime
Date and time that this data was last updated.
DBDATETIME
NOT NULL
DelayQAbandTimeTo5
Sum of delay time of all calls to route abandoned
in queue during the current five-minute interval.
in queue during the current five-minute interval.
DBINT
NULL
HandleTimeHalf
Total handle time in seconds for calls to the route
ending during the current half-hour interval.
ending during the current half-hour interval.
DBINT
NULL
HandleTimeTo5
Total handle time in seconds for calls to the route
ending during the current five-minute interval.
ending during the current five-minute interval.
DBINT
NULL
HandleTimeToday
Total handle time in seconds for calls to the route
ending since midnight.
ending since midnight.
DBINT
NULL
HoldTimeHalf
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.
DBINT
NULL
HoldTimeTo5
The total hold time in seconds for calls to the route
ending during the current five-minute interval.
ending during the current five-minute interval.
DBINT
NULL
HoldTimeToday
The total hold time in seconds for calls to the route
ending since midnight.
ending since midnight.
DBINT
NULL
LongestCallQ
Time that the longest call in the queue for the route
was put there.
was put there.
DBDATETIME
NULL
OverflowInNow
Number of overflowed in calls now in queue or in
progress for the route.
progress for the route.
DBINT
NULL
OverflowOutNow
Number of overflowed out calls for the route now
in queue or in progress elsewhere.
in queue or in progress elsewhere.
DBINT
NULL
RouteID
Foreign key from the Route table.
DBINT
PK, FK
NOT NULL
ServiceLevelAbandHalf
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.
DBINT
NULL
ServiceLevelAbandTo5
Number of calls abandoned within the ICM
service level threshold during the current
five-minute interval.
service level threshold during the current
five-minute interval.
DBINT
NULL
ServiceLevelAbandToday
Number of calls to the route abandoned within the
ICM service level threshold since midnight.
ICM service level threshold since midnight.
DBINT
NULL
Table 2-292 Route_Real_Time Table (continued)
Field Name
Description
Data Type
Keys and
Null Option
Null Option