Cisco Cisco IPCC Web Option Technical References

2-68

Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)

Chapter 2 Table Details

Call_Type_Half_Hour Table

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.

Table 2-60 Call_Type_Half_Hour Table Constraints

Constraint

Field Name(s)

CallTypeID
DateTime
TimeZone

AK-1

RecoveryKey

CallTypeID

IE-1

DbDateTime

Table 2-61 Call_Type_Half_Hour Table

Field Name

Description

Data Type

Keys and
Null Option

AbandInterval1

Number of calls abandoned within interval 1.

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.

DBINT

NULL

AbandInterval2

Number of calls abandoned within interval 2.

DBINT

NULL

AbandInterval3

Number of calls abandoned within interval 3.

DBINT

NULL