Cisco Cisco E-Mail Manager Unity Integration Option Technical References
2-273
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Route_Half_Hour Table
Related tables:
(via RouteID)
RecoveryKey
A unique ID assigned to each record and used
internally by the ICM/IPCC Enterprise software to
track the record.
internally by the ICM/IPCC Enterprise software to
track the record.
DBFLT8
AK-1
NOT NULL
RouteID
Foreign key from the Route table.
DBINT
PK, FK
NOT NULL
ServiceLevelAbandToHalf
Cumulative total of calls to the route abandoned
within the ICM service level during the half-hour
interval.
within the ICM service level during the half-hour
interval.
DBINT
NULL
ServiceLevelCallsOfferedToHalf
Number of calls to the route that have had a
during the current half-hour
interval.
DBINT
NULL
ServiceLevelCallsToHalf
Cumulative total of calls to the route answered
within the ICM service level during the half-hour
interval.
within the ICM service level during the half-hour
interval.
DBINT
NULL
ServiceLevelToHalf
Cumulative ICM service level for the route during
the half-hour interval. The ICM software uses the
same type of service level calculation as specified
for the service associated with the route.
the half-hour interval. The ICM software uses the
same type of service level calculation as specified
for the service associated with the route.
DBFLT4
NULL
ServiceLevelType
Service Level Type used to calculate Service level
for this interval
for this interval
DBINT
NULL
ShortCallsTimeToHalf
The time, in seconds, accumulated by calls that
were too short to be counted as abandoned during
the half-hour interval. These calls were abandoned
before the abandoned call wait time expired.
were too short to be counted as abandoned during
the half-hour interval. These calls were abandoned
before the abandoned call wait time expired.
DBINT
NULL
ShortCallsToHalf
The total number of calls to the route that were too
short to be considered abandoned during the
half-hour interval. A call is determined to be a
short call if it is abandoned before the Abandoned
Call Wait Time expired. Short calls are not
considered abandoned, nor are they accounted for
in any of the ICM abandoned calls calculations.
short to be considered abandoned during the
half-hour interval. A call is determined to be a
short call if it is abandoned before the Abandoned
Call Wait Time expired. Short calls are not
considered abandoned, nor are they accounted for
in any of the ICM abandoned calls calculations.
DBINT
NULL
TalkTimeToHalf
The number of seconds the call was talking plus
the number of seconds the call was on hold.
TalkTime for routes and services is taken from the
TalkTime and HoldTime. It is updated in the
database when any after-call work associated with
the call is completed.
the number of seconds the call was on hold.
TalkTime for routes and services is taken from the
TalkTime and HoldTime. It is updated in the
database when any after-call work associated with
the call is completed.
DBINT
NULL
TimeZone
The time zone for the date and time. The value is
the offset in minutes from GMT.
the offset in minutes from GMT.
DBINT
PK
NULL
Table 2-290 Route_Half_Hour Table (continued)
Field Name
Description
Data Type
Keys and
Null Option
Null Option