Technical References

Keys and Null
Option:
Data Type:Description:Field Name:
NULLDBSMALLINT
Default value that indicates how the software calculates the service
level (that is, how it handles abandoned calls in calculating the
service level). You can override this default for individual services.
ServiceLevelType
Call_Type_Half_Hour Table
This table is part of the Script category (page 451). For database rules, click here. (page 509)
Central database only.
Provides half- hour statistics for each call type defined in the ICM software. The ICM software
generates Call_Type_Half_Hour records for each call type.
Note: For fields applicable to IPCC Enterprise and ACDs with translation routing; if the call is
not transferred through the ICM, the subsequent call legs are not tracked by the ICM unless the
call is transferred back to the ICM at some point.
Related table
Call Type (page 74) (via CallTypeID)
Table 48: Indexes for Call_Type_Half_Hour Table
index_keysindex_descriptionindex_name
RecoveryKeynonclustered, unique, unique key
located on PRIMARY
XAK1Call_Type_Half_Hour
DbDateTimenonclustered located on PRIMARYXIE1Call_Type_Half_Hour
DateTime, CallTypeID, TimeZoneclustered, unique, primary key
located on PRIMARY
XPKCall_Type_Half_Hour
Fields in Call_Type_Half_Hour Table :
Keys
and
Null
Option:
Data Type:Description:Field Name:
NULLDBINT
Number of calls abandoned within interval 1.
AbandInterval1
This field is applicable to both ICM and IPCC Enterprise with the
following exception: the field is not incremented if the call abandons
after it is routed to a standard ACD unless the call was translation
routed.
Note: Note: In an IPCC Enterprise Gateway deployment, ICM (parent)
connected with an IPCC Enterprise with an IPCC System PG (child)
or IPCC Express (child) through IPCC Gateway PG, network queuing
data is not available in the child or in the child agent/supervisor
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
76
Chapter 2: All Tables
Call_Type_Half_Hour Table