Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 620
Keys and Null
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.
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.
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
XAK1Campaign_Query_Rule_Half_H
DbDateTime
nonclustered located on PRIMARY
XIE1Campaign_Query_Rule_Half_H
DateTime, CampaignID, QueryRuleID,
TimeZone
clustered, unique, primary key
located on PRIMARY
XPKCampaign_Query_Rule_Half_Ho
Fields in Campaign_Query_Rule_Half_Hour Table :
Keys and Null
Option:
Data Type:
Description:
Field Name:
NULL
INT
The number of calls in a half-hour period where the dialer
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
AbandonToIVRToHalf
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 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.
AgentRejectedDetectToHalf
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
134
Chapter 2:  All Tables
Campaign_Query_Rule_Half_Hour Table