Cisco Cisco IP Contact Center Release 4.6.2 Technical References

Page of 548
   
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.
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.
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.
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.
DBINT
NULL
CallsRoutedToHalf
Number of calls of this type that have been routed 
during the half-hour interval.
This field is applicable to both ICM and IPCC 
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.
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.
DBDATETIME
NULL
DelayQAbandTimeHalf
The total delay time of abandoned calls for this 
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.
DBINT
NULL
Table 2-61 Call_Type_Half_Hour Table (continued)
Field Name
Description
Data Type
Keys and 
Null Option