Cisco Cisco Administrative Workstation Technical References
2-97
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Campaign_Query_Rule Table
(via CampaignID)
Campaign_Query_Rule Table
Contains a set of associations between query rules and campaigns.
Use the Outbound Option Configuration option within ICM Configuration Manager to modify
Campaign_Query_Rule records.
Campaign_Query_Rule records.
Table 2-68 CAmpaign_Query_RuleTable Constraints
Constraint
Field Name(s)
PK
CampaignID
QueryRuleID
QueryRuleID
FK
CampaignID
QueryRuleID
QueryRuleID
Table 2-69 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.
This field is applicable to Outbound Option only.
DBINT
PK, FK
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.
DBINT
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
DBCHAR
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.
DBINT
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.
DBINT
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.
DBINT
NOT NULL
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
DBCHAR
NOT NULL
ListOrder
The order in which the query rules are to be used.
DBINT
NOT NULL