/mcpRelated Tables Campaign, on page 156 (via CampaignID) Query_Rule, on page 362 (via QueryRuleID) Table 94: Indexes for Campaign_Query_Rule Table index_keys index_description index_name CampaignID, QueryRuleID clustered, unique, primary key located on PRIMARY XPKCampaign_Query_Rule Table 95: Fields in Campaign_Query_Rule Table Keys and NULL Option Data Type Description Name PK, FK NOT NULL DBINT The campaign to which this query rule belongs. This field is a foreign key from the Campaign table. This field is applicable to Outbound Option only. CampaignID NOT NULL DBINT The amount of time (in minutes) to use the current query rule before going on to the next. Duration NOT NULL DBCHAR Indicates whether or not to use duration rate to move between query rules within this campaign: • Y = Use duration (time spent within a query rule) • N = Do not use duration DurationEnabled NOT NULL DBINT The contact will not be dialed past the EndHours:EndMinutes. Hours are in 24-hour format and are based on the Unified ICM Central Controller time. EndHours NOT NULL DBINT The contact will not be dialed past the EndHours:EndMinutes. Time is based on the Unified ICM Central Controller time. EndMinutes NULL DBINT Reserved for future use FutureUseInt1 NULL DBINT Reserved for future use FutureUseInt2 NULL DBINT Reserved for future use FutureUseInt3 NULL DBINT Reserved for future use FutureUseInt4 NULL DBINT Reserved for future use FutureUseInt5 NULL varchar(64) Reserved for future use FutureUseVarchar1 Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 167 All Tables Campaign_Query_Rule