Cisco Cisco IPCC Web Option Technical References

Page of 620
Campaign_Query_Rule_Real_Time Table
This table is in the 
. To see database rules for these tables,
click 
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
 (via CampaignID)
Table 54: Indexes for Campaign_Query_Rule_Real_Time Table
index_keys
index_description
index_name
CampaignID, QueryRuleID
clustered, 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:
NULL
DBINT
The number of calls abandoned by the dialer.
AbandonDetectCount
NULL
DBINT
The number of calls that detected an answering machine.
AbandonToIVRCount
NULL
DBINT
The number of preview/callback calls that were closed by the
agent (these customers will not be dialed).
AgentClosedCount
NULL
DBINT
The number of preview/callback calls that were rejected by the
agent.
AgentRejectedCount
NULL
DBINT
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
NULL
DBINT
The number of attempted calls so far today.
AttemptedCount
NULL
DBINT
The number of calls that detected a busy signal.
BusyCount
NULL
DBINT
The total number of records scheduled for a callback today.
CallBackCount
PK, FK NOT NULL
DBINT
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