Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-99
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Campaign_Query_Rule_Half_Hour Table
Campaign_Query_Rule_Half_Hour Table
Central database only.
Each row provides half-hour 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-70 Campaign_Query_Rule_Half_Hour Table Constraints
Constraint
Field Name(s)
PK
CampaignID
DateTime
QueryRuleID
TimeZone
DateTime
QueryRuleID
TimeZone
AK-1
RecoveryKey
FK
CampaignID
QueryRuleID
QueryRuleID
IE-1
DbDateTime
Table 2-71 Campaign_Query_Rule_Half_Hour Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
AbandonDetectToHalf
The number of calls in a half-hour period where
the dialer abandoned a customer call.
the dialer abandoned a customer call.
DBINT
NOT NULL
AbandonToIVRToHalf
The number of calls in a half-hour period that had
to be abandoned. However, instead of hanging-up
on a customer, the call was transferred to an IVR
which played a message to the customer.
to be abandoned. However, instead of hanging-up
on a customer, the call was transferred to an IVR
which played a message to the customer.
DBINT
NOT NULL
AgentClosedDetectToHalf
The number of preview/callback calls in a
half-hour period that were closeded by the agent
(these customers will not be dialed).
half-hour period that were closeded by the agent
(these customers will not be dialed).
DBINT
NOT NULL
AgentRejectedDetectToHalf
The number of preview/callback calls in a
half-hour period that were rejected by the agant.
half-hour period that were rejected by the agant.
DBINT
NOT NULL
AnsweringMachineDetectToHalf
The number of calls in a half-hour period that
detected an answering machine.
detected an answering machine.
DBINT
NOT NULL
BusyDetectToHalf
The number of calls in a half-hour period that
detected a busy signal.
detected a busy signal.
DBINT
NOT NULL
CampaignID
The campaign to which this query rule belongs.
This field is applicable to Outbound Option
only.
only.
DBINT
PK, FK
NOT NULL
CancelledDetectToHalf
The number of calls in a half-hour period where
the dialer canceled a ringing customer call.
the dialer canceled a ringing customer call.
DBINT
NOT NULL
ContactsAttemptedToHalf
The number of attemted calls within a half-hour
period.
period.
DBINT
NULL