Technical References

Keys and
Null Option:
Data Type:Description:Field Name:
NULLDBINT
Running total of incoming calls plus internal calls offered to the
route since midnight.
CallsOfferedToday
NULLDBINT
Calls in queue for the route at the peripheral at the end of the
interval.
CallsQNow
NULLDBINT
Running total of calls the ICM software sent to the route since
midnight.
CallsRoutedToday
PK NOT NULLDBSMALLDATE
The Central Controller date and time at the start of the five-minute
interval.
DateTime
NULLDBINT
Length of time that the longest call in the queue for the route had
been there at the end of the five-minute interval.
LongestCallQ
NOT NULLDBINT
Currently not used, set to zero (0).
RecoveryDay
AK-1 NOT
NULL
DBFLT8
A unique ID assigned to each record and used internally by the
ICM/IPCC Enterprise software to track the record.
RecoveryKey
PK, FK NOT
NULL
DBINT
Foreign key from the Route table.
RouteID
NULLDBINT
Total of calls to the route abandoned within the ICM service level
threshold during the five-minute interval.
ServiceLevelAbandTo5
NULLDBINT
Cumulative total of calls to the route abandoned within the ICM
service level threshold since midnight.
ServiceLevelAbandToday
NULLDBINT
Total number of calls to the route that had a service level event
during the five-minute interval.
ServiceLevelCallsOfferedTo5
NULLDBINT
Total number of calls to the route that had a service level event
since midnight.
ServiceLevelCallsOfferedToday
NULLDBINT
Number of calls to the route that had been in queue longer than
the service level threshold as of the end of the five-minute interval.
ServiceLevelCallsQHeld
NULLDBINT
Total of calls to the route answered within the ICM service level
threshold during the five-minute interval.
ServiceLevelCallsTo5
NULLDBINT
Cumulative total of calls to the route answered within the ICM
service level since midnight.
ServiceLevelCallsToday
NULLDBFLT4
The ICM service level for the route for the five-minute interval.
ServiceLevelTo5
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
287
Chapter 2: All Tables
Route_Five_Minute Table