Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 404
 
2-58
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Campaign_Query_Rule_Half_Hour Table
Related tables:
Campaign (via CampaignID)
Query_Rule (via QueryRuleID)
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 Blended Agent predictive dialing algorithm.
HitRateEnabled
Indicates whether or not to use hit rate to move between 
query rules within this campaign:
Y = Use hit rate 
N = Do not use hit rate
char(1)
NOT NULL
QueryRuleEnabled
Indicates whether the query rule is enabled or disabled 
within this campaign:
Y = Enabled
N = Disabled 
char(1)
NOT NULL
Table 2-33 Campaign_Query_Rule Table (continued)
Field Name
Description
Data Type
Keys and Null 
Option
Table 2-34 Campaign_Query_Rule_Half_Hour Table
Field Name
Description
Data Type
Keys and Null 
Option
CampaignID
The campaign to which this query rule belongs.
int
PK, FK, NOT 
NULL
QueryRuleID
The query rule belonging to the campaign identified by 
the CampaignID.
int
PK, FK, NOT 
NULL
DateTime
The ICM Central Controller date and time at the start of 
the half-hour interval.
datetime
NOT NULL
TimeZone
The time zone for the date and time. The value is the offset 
in minutes from GMT.
int
NOT NULL
AttemptedToHalf
The total numbers of attempted calls during the last half 
hour.
int
NULL
ContactedToHalf
The total number of calls ending in an agent answering the 
call during the last half hour.
int
NULL
TalkTimeToHalf
The total number of seconds agents spent talking on the 
phone during the last half hour.
int
NULL
WrapupTimeToHalf
The total number of seconds agents spent in wrap-up 
mode during the last half hour.
int
NULL