Technical References

Keys and
Null
Option:
Data Type:Description:Field Name:
HandleTime and AvgHandleTime values are updated in the database
when the after-call work time associated with the call is completed.
NULLDBINT
Total hold time in seconds for calls to the route that ended during
the half-hour interval.
HoldTimeToHalf
NULLDBINT
The longest time in seconds a call was in queue for the route before
being abandoned during the half-hour interval. This includes the
LocalQTime, DelayTime, and RingTime.
LongestCallAbandTime
NULLDBINT
The longest time in seconds a call was in queue for the route before
being answered during the half-hour interval. This includes the
LocalQTime for the call.
LongestCallDelayQTime
NULLDBINT
Number of calls that the peripheral retargeted, or overflowed, into
the route during the half-hour interval. The ICM software keeps
OverflowInToHalf
counts of the number of calls moved out of each service or route
(overflowed out) and moved into each service or route (overflowed
in).
NULLDBINT
Number of calls the peripheral retargeted, or overflowed, out of the
route during the half-hour interval. The ICM software keeps counts
OverflowOutToHalf
of the number of calls moved our of each service or route
(overflowed out) and moved into each service or route (overflowed
in).
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
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.
RedirectNoAnsCallsToHalf
NULLDBINT
Reserved for future use.
Reserved1
NULLDBINT
Reserved for future use.
Reserved2
NULLDBINT
Reserved for future use.
Reserved3
NULLDBINT
Reserved for future use.
Reserved4
NULLDBFLT4
Reserved for future use.
Reserved5
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
291
Chapter 2: All Tables
Route_Half_Hour Table