Cisco Cisco E-Mail Manager Unity Integration Option Technical References
Keys and
Null
Option:
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.
when the after-call work time associated with the call is completed.
NULL
DBINT
Total hold time in seconds for calls to the route that ended during
the half-hour interval.
the half-hour interval.
HoldTimeToHalf
NULL
DBINT
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.
being abandoned during the half-hour interval. This includes the
LocalQTime, DelayTime, and RingTime.
LongestCallAbandTime
NULL
DBINT
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.
being answered during the half-hour interval. This includes the
LocalQTime for the call.
LongestCallDelayQTime
NULL
DBINT
Number of calls that the peripheral retargeted, or overflowed, into
the route during the half-hour interval. The ICM software keeps
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).
(overflowed out) and moved into each service or route (overflowed
in).
NULL
DBINT
Number of calls the peripheral retargeted, or overflowed, out of the
route during the half-hour interval. The ICM software keeps counts
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).
(overflowed out) and moved into each service or route (overflowed
in).
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
NULL
DBINT
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.
failure to answer in this service during the current half-hour interval.
RedirectNoAnsCallsToHalf
NULL
DBINT
Reserved for future use.
Reserved1
NULL
DBINT
Reserved for future use.
Reserved2
NULL
DBINT
Reserved for future use.
Reserved3
NULL
DBINT
Reserved for future use.
Reserved4
NULL
DBFLT4
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