Cisco Cisco IPCC Web Option Technical References

Page of 620
Contains statistics produced by Blended Agent when a dialing list is executed. Each row provides
half-hour statistics for a particular dialer.
Related table
Table 79: Indexes for Dialer_Half_Hour Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
XAK1Dialer_Half_Hour
DbDateTime
nonclustered located on PRIMARY
XIE1Dialer_Half_Hour
DateTime, DialerID, TimeZone
clustered, unique, primary key
located on PRIMARY
XPKDialer_Half_Hour
Fields in Dialer_Half_Hour Table:
Keys and Null
Option:
Data Type:
Description:
Field Name:
NULL
DBINT
The number of calls made during the half hour interval that
were abandoned.
AbandonDetectToHalf
NULL
DBINT
The number of calls in a half-hour period that had to be
abandoned. However, instead of hanging-up on a customer,
AbandonToIVRToHalf
the call was transferred to an IVR which played a message to
the customer.
NULL
DBINT
The number of preview/callback calls in a half-hour period
that were rejected by the agent (these customers will not be
dialed).
AgentClosedDetectToHalf
NULL
DBINT
The number of preview/callback calls in a half-hour period
that were rejected by the agent.
AgentRejectedDetectToHalf
NULL
DBINT
The number of calls made during the half hour interval in which
an answering machines was detected.
AnsweringMachineDetectToHalf
NULL
DBINT
The number of calls in the half-hour period that detected a
busy signal.
BusyDetectToHalf
NULL
DBINT
The total number of records scheduled for a callback.
CallbackCountToHalf
NULL
DBINT
The number of calls in a half-hour period that were dropped
while ringing the customer’s telephone.
CancelledDetectToHalf
NULL
DBINT
The number of contacts dialed during the half hour interval.
ContactsDialedToHalf
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
167
Chapter 2:  All Tables
Dialer_Half_Hour Table