Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-57
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Campaign_Query_Rule Table
Campaign_Query_Rule Table
Contains a set of associations between query rules and campaigns.
Use the Blended Agent Configuration option within ICM Configuration Manager to modify
Campaign_Query_Rule records.
Campaign_Query_Rule records.
Table 2-33 Campaign_Query_Rule Table
Field Name
Description
Data Type
Keys and Null
Option
Option
CampaignID
The campaign to which this query rule belongs. This field
is a foreign key from the Campaign table.
is a foreign key from the Campaign table.
int
PK, FK, NOT
NULL
NULL
QueryRuleID
The query rule belonging to the campaign identified by
the CampaignID. This field is a foreign key from the
Query Rule table.
the CampaignID. This field is a foreign key from the
Query Rule table.
int
PK, FK, NOT
NULL
NULL
ListOrder
The order in which the query rules are to be used.
int
NOT NULL
StartHours
The contact will not be dialed earlier than the
StartHours:StartMinutes. Hours are in 24-hour format and
are based on the ICM Central Controller time.
StartHours:StartMinutes. Hours are in 24-hour format and
are based on the ICM Central Controller time.
int
NOT NULL
StartMinutes
The contact will not be dialed earlier than the
StartHours:StartMinutes. Time is based on the ICM
Central Controller time.
StartHours:StartMinutes. Time is based on the ICM
Central Controller time.
int
NOT NULL
EndHours
The contact will not be dialed past the
EndHours:EndMinutes. Hours are in 24-hour format and
are based on the ICM Central Controller time.
EndHours:EndMinutes. Hours are in 24-hour format and
are based on the ICM Central Controller time.
int
NOT NULL
EndMinutes
The contact will not be dialed past the
EndHours:EndMinutes. Time is based on the ICM Central
Controller time.
EndHours:EndMinutes. Time is based on the ICM Central
Controller time.
int
NOT NULL
Penetration
The percentage of this query rule to be attempted before
shifting to the next query rule within the current
campaign. The percentage value is a whole number
between 0 and 100.
shifting to the next query rule within the current
campaign. The percentage value is a whole number
between 0 and 100.
int
NOT NULL
Duration
The amount of time (in minutes) to use the current query
rule before going on to the next.
rule before going on to the next.
int
NOT NULL
HitRate
The percentage of hits (completed/attempted) per
campaign considered as a threshold by the predictive
algorithm. The percentage value is a whole number
between 0 and 100.
campaign considered as a threshold by the predictive
algorithm. The percentage value is a whole number
between 0 and 100.
int
NOT NULL
PenetrationEnabled
Indicates whether or not to use penetration rate to move
between query rules within this campaign:
between query rules within this campaign:
Y = Use penetration rate
N = Do not use penetration rate
N = Do not use penetration rate
char(1)
NOT NULL
DurationEnabled
Indicates whether or not to use duration rate to move
between query rules within this campaign:
between query rules within this campaign:
Y = Use duration (time spent within a query rule)
N = Do not use duration
N = Do not use duration
char(1)
NOT NULL