McDewey

The Campaign (see Campaign, on page 156) contains information for all the campaigns defined in a Outbound Option implementation. (There is a single row for every configured campaign.) The Campaign Half Hour (see Campaign_Half_Hour, on page 165) provides historical reporting for campaign attributes. The Campaign Query Rule (see Campaign_Query_Rule, on page 166) is a cross-reference table between the Campaign table and the Query Rule Table. The Campaign Skill Group (see Campaign_Skill_Group, on page 184) is a cross-reference table between Campaign table and the Skill Groups table. It defines the association between skill groups and campaigns. The Campaign Target Sequence (see Campaign_Target_Sequence, on page 186) contains the target type and sequence with which numbers are dialed within a campaign. The Campaign Query Rule Real Time (see Campaign_Query_Rule_Real_Time, on page 175) and Campaign Query Rule Half Hour (see Campaign_Query_Rule_Half_Hour, on page 169) provide statistics on particular Campaign-Query Rule combinations. The Query Rule Clause (see Query_Rule_Clause, on page 364) contains the SQL rules associated with each query rule. There is a single row for each configured query rule. The Query Rule (see Query_Rule, on page 362) is a cross-reference table between Query Rule Clause table and the Import Rule table. Import Rules An import rule defines how Blended Agent imports data from an import list into a contact table. The information in the contact table can then be used to build a dialing list. An import list is a raw set of customer contacts (in text file format) that can be imported into a contact table and used to build a dialing list. The import list may also be referred to as an import file or a contact file. The import list is associated with a particular campaign and query rule. The Import Rule (see Import_Rule, on page 274) contains a list of all the import rules and their associated import lists. The Import Rule Real Time (see Import_Rule_Real_Time, on page 281) and the Import Rule History (see Import_Rule_History, on page 280) contain statistics on the Outbound Option imports and the success rate of the imports. The Import Rule Clause (see Import_Rule_Clause, on page 278) defines the portions of an import list to be imported by the Blended Agent Import Rule process. Dialers The dialer is is used in Outbound Option to define the relationship between skill groups, the ACDs to which they are connected, and the ports on a dialer board. The settings you assign to the dialer control how it handles dialing from your location and how it responds to answering machines or human voices. Several database tables control dialer configuration and record statistics. The Dialer (see Dialer, on page 220) contains configuration information for each dialer in a Outbound Option implementation. The Dialer Port Map (see Dialer_Port_Map, on page 237) maps port numbers on the dialer to the ports on the ACD, and identifies the ACD stations and their mapping to dialer ports. Two reporting tables, Dialer Real Time (see Dialer_Real_Time, on page 240) and Dialer Half Hour (see Dialer_Half_Hour, on page 231) provide statistics for reporting on dialer implementation. Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 696 Database Rules Blended Agent Tables (Outbound Option)