Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 557
Keys and Null
Option:
Data Type:
Description:
Field Name:
retry interval is greater than 5 minutes the system
will not wait.
N = Do not wait to retry a busy number, try the
next number in the list.
Default = N
NOT NULL
DBCHAR
Valid options are:
WorkEnabled
• Y = Allow dialing to work numbers.
• N = Do not allow dialing to work numbers.
NOT NULL
DBINT
Work telephone numbers will not be dialed later
than WorkEndHours:WorkEndMinutes. Hours
are in 24-hour format.
WorkEndHours
NOT NULL
DBINT
Work telephone numbers will not be dialed later
than WorkEndHours:WorkEndMinutes.
WorkEndMinutes
NOT NULL
DBINT
Work telephone numbers will be dialed no earlier
than WorkStartHours:WorkStartMinutes. Hours
are in 24-hour format.
WorkStartHours
NOT NULL
DBINT
Work telephone numbers will be dialed no earlier
than WorkStartHours:WorkStartMinutes.
WorkStartMinutes
Campaign_Query_Rule Table
This table is in the 
. To see database rules for these tables,
click 
It contains a set of associations between query rules and campaigns.
Note: 
If Outbound Option was not selected during setup, this table will contain no data.
Use the Outbound Option Configuration option within ICM Configuration Manager to modify
Campaign_Query_Rule records.
Related tables
 (via CampaignID)
Table 52: Indexes for Campaign_Query_Rule Table
index_keys
index_description
index_name
CampaignID, QueryRuleID
clustered, unique, primary key
located on PRIMARY
XPKCampaign_Query_Rule
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
103
Chapter 2:  All Tables
Campaign_Query_Rule Table