Cisco Cisco IP Contact Center Release 4.6.2 Technical References
2-73
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Call_Type_Half_Hour Table
CallsRONAToHalf
Number of calls that have been Redirected On No
Answer in the half-hour interval. This does not
include calls that are rerouted using the router
requery feature. This is for calls with a call
disposition of 19.
Answer in the half-hour interval. This does not
include calls that are rerouted using the router
requery feature. This is for calls with a call
disposition of 19.
This field is applicable to both ICM and IPCC
Enterprise with the following exception: the field
is not incremented if the call is answered by an
agent on a standard ACD unless the call was
translation routed.
Enterprise with the following exception: the field
is not incremented if the call is answered by an
agent on a standard ACD unless the call was
translation routed.
DBINT
NULL
CallsRoutedNonAgentToHalf
For IPCC Express, the number of calls that
executed a Label node or a Divert Label node in
their routing script in the half-hour interval.
executed a Label node or a Divert Label node in
their routing script in the half-hour interval.
For ICM, the number of calls that executed a
Label node or a Divert Label node in their routing
script; or were routed to a standard ACD without
using a translation route in the half-hour interval.
Label node or a Divert Label node in their routing
script; or were routed to a standard ACD without
using a translation route in the half-hour interval.
DBINT
NULL
CallsRoutedToHalf
Number of calls of this type that have been routed
during the half-hour interval.
during the half-hour interval.
This field is applicable to both ICM and IPCC
Enterprise.
Enterprise.
DBINT
NULL
CallTypeID
Identifies the call type.
DBINT
PK, FK
NOT NULL
DateTime
The Central Controller date and time at the start of
the interval when the row was generated.
the interval when the row was generated.
DBSMALLDATE
PK
NOT NULL
DbDateTime
The current date and time stamp when the records
are written to the HDS database. The logger
database has NULL for this column.
are written to the HDS database. The logger
database has NULL for this column.
DBDATETIME
NULL
DelayQAbandTimeHalf
The total delay time of abandoned calls for this
call type during the current half-hour interval.
call type during the current half-hour interval.
This field is applicable to both ICM and IPCC
Enterprise with the following exception: it does
not include the delay time for a call that was
abandoned after it was routed to a standard ACD
unless the call was translation routed.
Enterprise with the following exception: it does
not include the delay time for a call that was
abandoned after it was routed to a standard ACD
unless the call was translation routed.
DBINT
NULL
Table 2-61 Call_Type_Half_Hour Table (continued)
Field Name
Description
Data Type
Keys and
Null Option
Null Option