Technical References

Campaign_Query_Rule_Real_Time Table
This table is in the Blended Agent category (page 439). To see database rules for these tables,
click here (page 503).
Local database only.
Each row provides real-time statistics on a particular Campaign-Query Rule combination. The
statistics reflect counters used in the Outbound Option predictive dialing algorithm.
Related tables
Campaign (page 125) (via CampaignID)
Query_Rule (page 266) (via QueryRuleID)
Table 54: Indexes for Campaign_Query_Rule_Real_Time Table
index_keysindex_descriptionindex_name
CampaignID, QueryRuleIDclustered, unique, primary key
located on PRIMARY
XPKCampaign_Query_Rule_Real_Ti
Fields in Campaign_Query_Rule_Real_Time Table:
Keys and Null
Option:
Data Type:Description:Field Name:
NULLDBINT
The number of calls abandoned by the dialer.
AbandonDetectCount
NULLDBINT
The number of calls that detected an answering machine.
AbandonToIVRCount
NULLDBINT
The number of preview/callback calls that were closed by the
agent (these customers will not be dialed).
AgentClosedCount
NULLDBINT
The number of preview/callback calls that were rejected by the
agent.
AgentRejectedCount
NULLDBINT
The number of calls that were abandoned by the dialer. However,
instead of hanging-up on the customer, the call was transferred
to an IVR which played a message to the customer.
AnsweringMachineCount
NULLDBINT
The number of attempted calls so far today.
AttemptedCount
NULLDBINT
The number of calls that detected a busy signal.
BusyCount
NULLDBINT
The total number of records scheduled for a callback today.
CallBackCount
PK, FK NOT NULLDBINT
The campaign to which this query rule belongs.
CampaignID
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
137
Chapter 2: All Tables
Campaign_Query_Rule_Real_Time Table