McDewey

Keys and NULL Option Data Type Description Name NOT NULL DBINT TThe contact will not be dialed earlier than the StartHours:StartMinutes. Time is based on the Unified ICM Central Controller time. StartMinutes Campaign_Query_Rule_Half_Hour This table is in the Blended Agent category (seeBlended Agent (Outbound Option), on page 616). To see database rules for these tables, see Blended Agent Tables (Outbound Option), on page 695. It gets populated on central and HDS databases. Each row in this table provides half-hour statistics on a particular Campaign-Query Rule combination. The statistics reflect counters that are used in the Outbound Option predictive dialing algorithm. Related Tables Campaign, on page 156 (via CampaignID) Query_Rule, on page 362 (via QueryRuleID) Table 96: Indexes for Campaign_Query_Rule_Half_Hour Table index_keys index_description index_name RecoveryKey Nonclustered, unique, unique key located on PRIMARY XAK1Campaign_Query_Rule_Half_Hour DbDateTime Nonclustered located on PRIMARY XIE1Campaign_Query_Rule_Half_Hour DateTime, CampaignID, QueryRuleID, TimeZone Clustered, unique, primary key located on PRIMARY XPKCampaign_Query_Rule_Half_Hour The Campaign_Query_Rule_Interval Table populates with 30/15 minute reporting data, depending on the Historical Reporting Interval setting for the peripheral gateway. However, the Campaign_Query_Rule_Half_Hour Table does not populate this data. Note Table 97: Fields in Campaign_Query_Rule_Half_Hour Table Keys and NULL Option Data Type Description Name NULL DBINT The number of calls in a half-hour period where the dialer abandoned a customer call. AbandonDetectToHalf Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 169 All Tables Campaign_Query_Rule_Half_Hour