Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-102
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Campaign_Query_Rule_Real_Time Table
Campaign_Query_Rule_Real_Time Table
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.
reflect counters used in the Outbound Option predictive dialing algorithm.
Table 2-72 Campaign_Query_Rule_Real_Time Table Constraints
Constraint
Field Name(s)
PK
CampaignID
QueryRuleID
QueryRuleID
FK
CampaignID
QueryRuleID
QueryRuleID
Table 2-73 Campaign_Query_Rule_Real_Time Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
AbandonDetectCount
The number of calls abandoned by the dialer.
DBINT
NOT NULL
AbandonToIVRCount
The number of calls that detected an answering
machine.
machine.
DBINT
NOT NULL
AgentClosedCount
The number of preview/callback calls that were
closed by the agent (these customers will not be
dialed).
closed by the agent (these customers will not be
dialed).
DBINT
NOT NULL
AgentRejectedCount
The number of preview/callback calls that were
rejected by the agent.
rejected by the agent.
DBINT
NOT NULL
AnsweringMachineCount
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.
dialer. However, instead of hanging-up on the
customer, the call was transferred to an IVR which
played a message to the customer.
DBINT
NOT NULL
AttemptedCount
The number of attempted calls so far today.
DBINT
NULL
BusyCount
The number of calls that detected a busy signal.
DBINT
NOT NULL
CallBackCount
The total number of records scheduled for a
callback today.
callback today.
DBINT
NULL
CampaignID
The campaign to which this query rule belongs.
This field is applicable to Outbound Option
only.
only.
DBINT
PK, FK
NOT NULL
CancelledDetectCount
The number of calls where the dialer cancelled a
ringing customer call.
ringing customer call.
DBINT
NOT NULL
ClosedCount
Records customer calls closed for any reason other
than reaching a live customer.
than reaching a live customer.
DBINT
NULL
CustomerAbandonDetectCount
The number of calls where the customer hung-up
immediately after picking up the telephone.
immediately after picking up the telephone.
DBINT
NOT NULL
DateTime
The Central Controller date and time when this
data was last updated.
data was last updated.
DBDATETIME
NOT NULL