Technical References

The Campaign Query Rule Real Time (page 137) and Campaign Query Rule Half Hour (page
134) tables provide statistics on particular Campaign-Query Rule combinations.
The Query Rule Clause (page 268) table contains the SQL rules associated with each query rule.
There is a single row for each configured query rule.
The Query Rule (page 266) table 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 (page 217) table contains a list of all the import rules and their associated import
lists.
The Import Rule Real Time (page 224) and the Import Rule History (page 223) tables contain
statistics on the Outbound Option imports and the success rate of the imports.
The Import Rule Clause (page 221) table 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 ICM 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 (page 161) table contains configuration information for each dialer in a Outbound
Option implementation.
The Dialer Port Map (page 169) table 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 (page 171) and Dialer Half Hour (page 166) provide
statistics for reporting on dialer execution.
The Dialer_Detail (page 163) table is an historical table that saves detailed dialer records thatallow
for better troubleshooting and tracking of dialer attempts, agent-skipped calls, andtermination
codes.
Device Tables - Database Rules
To see a list and an illustration of the Device tables, click here (page 441).
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
504
Chapter 5: Database Rules
Device Tables - Database Rules