Technical References

Keys and Null
Option:
Data Type:Description:Field Name:
NULLDBDATETIME
TTime that the longest call in the queue for the route was put there.
LongestCallQ
NULLDBINT
Number of overflowed in calls now in queue or in progress for the
route.
OverflowInNow
NULLDBINT
Number of overflowed out calls for the route now in queue or in
progress elsewhere.
OverflowOutNow
NULLDBINT
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.
RedirectNoAnsCallsHalf
NULLDBINT
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.
RedirectNoAnsCallsTo5
NULLDBINT
Number of calls that rang at an agent’s terminal and redirected on
failure to answer in this service since midnight.
RedirectNoAnsCallsToday
PK, FK NOT
NULL
DBINT
Foreign key from the Route table.
RouteID
NULLDBINT
Number of calls to the route abandoned within the ICM service
level threshold during the current half-hour interval.
ServiceLevelAbandHalf
NULLDBINT
Number of calls abandoned within the ICM service level threshold
during the rolling five-minute interval.
ServiceLevelAbandTo5
NULLDBINT
Number of calls to the route abandoned within the ICM service
level threshold since midnight.
ServiceLevelAbandToday
NULLDBINT
Number of calls to the route answered within the ICM service level
threshold during the current half-hour interval.
ServiceLevelCallsHalf
NULLDBINT
Number of calls to the route that have had a service level event
during the current half-hour interval.
ServiceLevelCallsOfferedHalf
NULLDBINT
Number of calls to the route that have been either answered or
abandoned during the rolling five-minute interval.
ServiceLevelCallsOfferedTo5
NULLDBINT
Number of calls to the route that have had a service level event
since midnight.
ServiceLevelCallsOfferedToday
NULLDBINT
Number of calls to the route currently in queue for longer than the
service level threshold.
ServiceLevelCallsQHeld
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
296
Chapter 2: All Tables
Route_Real_Time Table