Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 548
   
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.
Table 2-70 Campaign_Query_Rule_Half_Hour Table Constraints
Constraint
Field Name(s)
PK
CampaignID
DateTime
QueryRuleID
TimeZone
AK-1
RecoveryKey
FK
CampaignID
QueryRuleID
IE-1
DbDateTime
Table 2-71 Campaign_Query_Rule_Half_Hour Table
Field Name
Description
Data Type
Keys and 
Null Option
AbandonDetectToHalf
The number of calls in a half-hour period where 
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.
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).
DBINT
NOT NULL
AgentRejectedDetectToHalf
The number of preview/callback calls in a 
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.
DBINT
NOT NULL
BusyDetectToHalf
The number of calls in a half-hour period that 
detected a busy signal.
DBINT
NOT NULL
CampaignID
The campaign to which this query rule belongs.
This field is applicable to Outbound Option  
only
.
DBINT
PK, FK
NOT NULL
CancelledDetectToHalf
The number of calls in a half-hour period where 
the dialer canceled a ringing customer call.
DBINT
NOT NULL
ContactsAttemptedToHalf
The number of attemted calls within a half-hour 
period.
DBINT
NULL