Cisco Cisco ICM Web Tools Technical References
Keys and
Null Option:
Null Option:
Data Type:
Description:
Field Name:
NULL
DBINT
Running total of incoming calls plus internal calls offered to the
route since midnight.
route since midnight.
CallsOfferedToday
NULL
DBINT
Calls in queue for the route at the peripheral at the end of the
interval.
interval.
CallsQNow
NULL
DBINT
Running total of calls the ICM software sent to the route since
midnight.
midnight.
CallsRoutedToday
PK NOT NULL
DBSMALLDATE
The Central Controller date and time at the start of the five-minute
interval.
interval.
DateTime
NULL
DBINT
Length of time that the longest call in the queue for the route had
been there at the end of the five-minute interval.
been there at the end of the five-minute interval.
LongestCallQ
NOT NULL
DBINT
Currently not used, set to zero (0).
RecoveryDay
AK-1 NOT
NULL
NULL
DBFLT8
A unique ID assigned to each record and used internally by the
ICM/IPCC Enterprise software to track the record.
ICM/IPCC Enterprise software to track the record.
RecoveryKey
PK, FK NOT
NULL
NULL
DBINT
Foreign key from the Route table.
RouteID
NULL
DBINT
Total of calls to the route abandoned within the ICM service level
threshold during the five-minute interval.
threshold during the five-minute interval.
ServiceLevelAbandTo5
NULL
DBINT
Cumulative total of calls to the route abandoned within the ICM
service level threshold since midnight.
service level threshold since midnight.
ServiceLevelAbandToday
NULL
DBINT
Total number of calls to the route that had a service level event
during the five-minute interval.
during the five-minute interval.
ServiceLevelCallsOfferedTo5
NULL
DBINT
Total number of calls to the route that had a service level event
since midnight.
since midnight.
ServiceLevelCallsOfferedToday
NULL
DBINT
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.
the service level threshold as of the end of the five-minute interval.
ServiceLevelCallsQHeld
NULL
DBINT
Total of calls to the route answered within the ICM service level
threshold during the five-minute interval.
threshold during the five-minute interval.
ServiceLevelCallsTo5
NULL
DBINT
Cumulative total of calls to the route answered within the ICM
service level since midnight.
service level since midnight.
ServiceLevelCallsToday
NULL
DBFLT4
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