Cisco Cisco Administrative Workstation Technical References
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
NULL
DBSMALLINT
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.
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
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.
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.
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
(via CallTypeID)
Table 48: Indexes for Call_Type_Half_Hour Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Call_Type_Half_Hour
DbDateTime
nonclustered located on PRIMARY
XIE1Call_Type_Half_Hour
DateTime, CallTypeID, TimeZone
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKCall_Type_Half_Hour
Fields in Call_Type_Half_Hour Table :
Keys
and
Null
Option:
and
Null
Option:
Data Type:
Description:
Field Name:
NULL
DBINT
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.
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
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