Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-72
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Dialer_Half_Hour Table
Dialer_Half_Hour Table
Central database only.
Contains statistics produced by Blended Agent when a dialing list is executed. Each row provides
half-hour statistics for a particular dialer.
half-hour statistics for a particular dialer.
Related tables:
Dialer (via DialerID)
Table 2-55 Dialer_Half_Hour Table
Field Name
Description
Data Type
Keys and Null
Option
Option
DialerID
The dialer to which these statistics refer.
int
PK, FK, NOT
NULL
NULL
DateTime
The ICM Central Controller date and time at the start of
the half-hour interval.
the half-hour interval.
smalldatetime
NOT NULL
TimeZone
The time zone for the date and time. The value is the offset
in minutes from GMT.
in minutes from GMT.
int
NOT NULL
ContactsDialedTo
Half
Half
The number of contacts dialed during the half-hour
interval.
interval.
int
NULL
BusyDetectToHalf
The number of calls made during the half-hour interval in
which a busy signal was detected.
which a busy signal was detected.
int
NULL
VoiceDetectToHalf
The number of calls made during the half-hour interval in
which a voice was detected.
which a voice was detected.
int
NULL
AnsweringMachine
DetectToHalf
DetectToHalf
The number of calls made during the half-hour interval in
which an answering machine was detected.
which an answering machine was detected.
int
NULL
SITToneDetectToHalf
The number of calls made during the half-hour interval in
which SIT tones were detected.
which SIT tones were detected.
int
NULL
NoAnswerDetectTo
Half
Half
The number of calls made during the half hour interval
that were not answered.
that were not answered.
int
NULL
AbandonDetectToHalf
The number of calls made during the half hour interval
that were abandoned.
that were abandoned.
int
NULL
RecoveryKey
A value used internally by the ICM software to track
virtual time.
virtual time.
float
AK1, NOT
NULL
NULL