Cisco Cisco IP Contact Center Release 4.6.1 Technical References
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.
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:
query rules within this campaign:
Y = Use hit rate
N = Do not 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:
within this campaign:
Y = Enabled
N = Disabled
N = Disabled
char(1)
NOT NULL
Table 2-33 Campaign_Query_Rule Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option
Table 2-34 Campaign_Query_Rule_Half_Hour Table
Field Name
Description
Data Type
Keys and Null
Option
Option
CampaignID
The campaign to which this query rule belongs.
int
PK, FK, NOT
NULL
NULL
QueryRuleID
The query rule belonging to the campaign identified by
the CampaignID.
the CampaignID.
int
PK, FK, NOT
NULL
NULL
DateTime
The ICM Central Controller date and time at the start of
the half-hour interval.
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.
in minutes from GMT.
int
NOT NULL
AttemptedToHalf
The total numbers of attempted calls during the last half
hour.
hour.
int
NULL
ContactedToHalf
The total number of calls ending in an agent answering the
call during the last half hour.
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.
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.
mode during the last half hour.
int
NULL