Technical References

Keys and Null
Option:
Data Type:Description:Field Name:
NOT NULLDBINT
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
This table is in the Blended Agent category (page 439). To see database rules for these tables,
click here (page 503).
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
Campaign (page 125) (via CampaignID)
Query_Rule (page 266) (via QueryRuleID)
Table 53: Indexes for Campaign_Query_Rule_Half_Hour Table
index_keysindex_descriptionindex_name
RecoveryKeynonclustered, unique, unique key
located on PRIMARY
XAK1Campaign_Query_Rule_Half_H
DbDateTimenonclustered located on PRIMARYXIE1Campaign_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:
NULLINT
The number of calls in a half-hour period where the dialer
abandoned a customer call.
AbandonDetectToHalf
NULLDBINT
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.
NULLDBINT
The number of preview/callback calls in a half-hour period that
were closeded by the agent (these customers will not be dialed).
AgentClosedDetectToHalf
NULLDBINT
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