Cisco Cisco IP Contact Center Release 4.6.2 Technical References
2-133
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Dialer_Half_Hour Table
Dialer_Half_Hour Table
Central database only.
Contains statistics produced by Outbound Option when a dialing list is executed. Each row provides
half-hour statistics for a particular dialer.
half-hour statistics for a particular dialer.
Table 2-119 Dialer_Half_Hour Table Constraints
Constraint
Field Name(s)
PK
DateTime
DialerID
TimeZone
DialerID
TimeZone
AK-1
RecoveryKey
FK
DialerID
IE-1
DbDateTime
Table 2-120 Dialer_Half_Hour Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
AbandonDetectToHalf
The number of calls made during the half-hour
interval that were abandoned.
interval that were abandoned.
DBINT
NULL
AbandonToIVRToHalf
The number of calls in a half-hour period that had
to be abandoned. However, instead of hanging-up
on a customer, the call was transferred to an IVR
which played a message to the customer.
to be abandoned. However, instead of hanging-up
on a customer, the call was transferred to an IVR
which played a message to the customer.
DBINT
NOT NULL
AgentClosedDetectToHalf
The number of preview/callback calls in a
half-hour period that were rejected by the agent
(these customers will not be dialed).
half-hour period that were rejected by the agent
(these customers will not be dialed).
DBINT
NULL
AgentRejectedDetectToHalf
The number of preview/callback calls in a
half-hour period that were rejected by the agent.
half-hour period that were rejected by the agent.
DBINT
NOT NULL
AnsweringMachineDetectToHalf
The number of calls made during the half-hour
interval in which an answering machine was
detected.
interval in which an answering machine was
detected.
DBINT
NULL
BusyDetectToHalf
The number of calls made during the half-hour
interval in which a busy signal was detected.
interval in which a busy signal was detected.
DBINT
NULL
CancelledDetectToHalf
The number of calls in a half-hour period that were
dropped while ringing the customer’s telephone.
dropped while ringing the customer’s telephone.
DBINT
NULL
ContactsDialedToHalf
The number of contacts dialed during the
half-hour interval.
half-hour interval.
DBINT
NULL
CustomerAbandonDetectToHalf
The number of calls in a half-hour period that were
abandoned by the customer after they picked up
the telephone.
abandoned by the customer after they picked up
the telephone.
DBINT
NOT NULL
DateTime
The ICM Central Controller date and time at the
start of the half-hour interval.
start of the half-hour interval.
DBSMALLDATE
PK
NOT NULL