Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
NOT NULL
DBINT
TThe contact will not be dialed earlier than the StartHours:StartMinutes.
Time is based on the ICM Central Controller time.
Time is based on the ICM Central Controller time.
StartMinutes
Campaign_Query_Rule_Half_Hour Table
. To see database rules for these tables,
click
Central database only. Each row provides half-hour statistics on a particular Campaign-Query
Rule combination. The statistics reflect counters used in the Outbound Option predictive dialing
algorithm.
Rule combination. The statistics reflect counters used in the Outbound Option predictive dialing
algorithm.
Related tables
(via CampaignID)
Table 53: Indexes for Campaign_Query_Rule_Half_Hour Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Campaign_Query_Rule_Half_H
DbDateTime
nonclustered located on PRIMARY
XIE1Campaign_Query_Rule_Half_H
DateTime, CampaignID, QueryRuleID,
TimeZone
TimeZone
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKCampaign_Query_Rule_Half_Ho
Fields in Campaign_Query_Rule_Half_Hour Table :
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
NULL
INT
The number of calls in a half-hour period where the dialer
abandoned a customer call.
abandoned a customer call.
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, the
abandoned. However, instead of hanging-up on a customer, the
AbandonToIVRToHalf
call was transferred to an IVR which played a message to the
customer.
customer.
NULL
DBINT
The number of preview/callback calls in a half-hour period that
were closeded by the agent (these customers will not be dialed).
were closeded 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 agant.
were rejected by the agant.
AgentRejectedDetectToHalf
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
134
Chapter 2: All Tables
Campaign_Query_Rule_Half_Hour Table