Technical References

Use the Outbound Option Configuration option within ICM Configuration Manager to modify
Campaign_Query_Rule records.
Related tables
Campaign (page 125) (via CampaignID)
Query_Rule (page 266) (via QueryRuleID)
Table 52: Indexes for Campaign_Query_Rule Table
index_keysindex_descriptionindex_name
CampaignID, QueryRuleIDclustered, unique, primary key
located on PRIMARY
XPKCampaign_Query_Rule
Fields in Campaign_Query_Rule Table :
Keys and Null
Option:
Data Type:Description:Field Name:
PK, FK NOT NULLDBINT
The campaign to which this query rule belongs. This field is a foreign
key from the Campaign table.
CampaignID
This field is applicable to Outbound Option only.
NOT NULLDBINT
The amount of time (in minutes) to use the current query rule before
going on to the next.
Duration
NOT NULLDBCHAR
Indicates whether or not to use duration rate to move between query
rules within this campaign:
DurationEnabled
• Y = Use duration (time spent within a query rule)
• N = Do not use duration
NOT NULLDBINT
The contact will not be dialed past the EndHours:EndMinutes. Hours
are in 24-hour format and are based on the ICM Central Controller time.
EndHours
NOT NULLDBINT
The contact will not be dialed past the EndHours:EndMinutes. Time is
based on the ICM Central Controller time.
EndMinutes
NULLDBINT
Reserved for future use
FutureUseInt1
NULLDBINT
Reserved for future use
FutureUseInt2
NULLDBINT
Reserved for future use
FutureUseInt3
NULLDBINT
Reserved for future use
FutureUseInt4
NULLDBINT
Reserved for future use
FutureUseInt5
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
132
Chapter 2: All Tables
Campaign_Query_Rule Table