/mcpKeys and NULL Option Data Type Description Name NULL varchar(64) Reserved for future use FutureUseVarchar2 NULL varchar(64) Reserved for future use FutureUseVarchar3 NOT NULL DBINT The percentage of hits (completed/attempted) per campaign considered as a threshold by the predictive algorithm. The percentage value is a whole number between 0 and 100. HitRate NOT NULL DBCHAR Indicates whether or not to use hit rate to move between query rules within this campaign: • Y = Use hit rate • N = Do not use hit rate HitRateEnabled NOT NULL DBINT The order in which the query rules are to be used. ListOrder NOT NULL DBINT The percentage of this query rule to be attempted before shifting to the next query rule within the current campaign. The percentage value is a whole number between 0 and 100. Penetration NOT NULL DBCHAR Indicates whether or not to use penetration rate to move between query rules within this campaign: • Y = Use penetration rate • N = Do not use penetration rate PenetrationEnabled NOT NULL DBCHAR Indicates whether the query rule is enabled or disabled within this campaign: • Y = Enabled • N = Disabled QueryRuleEnabled PK, FK NOT NULL DBINT The query rule belonging to the campaign identified by the CampaignID. This field is a foreign key from the Query Rule table. This field is applicable to Outbound Option only. QueryRuleID NOT NULL DBINT TThe contact will not be dialed earlier than the StartHours:StartMinutes. Hours are in 24-hour format and are based on the Unified ICM Central Controller time. StartHours Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 168 All Tables Campaign_Query_Rule