Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-150
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Query_Rule Table
Query_Rule Table
Specifies the association between a query rule clause and an import rule. A query rule works on a
particular import rule to select a group of contacts from an overall import list. For example, from a
particular import list you might want to select and call all customers that have account numbers greater
than 10,000.
particular import rule to select a group of contacts from an overall import list. For example, from a
particular import list you might want to select and call all customers that have account numbers greater
than 10,000.
Use the Blended Agent Configuration option within ICM Configuration Manager to modify Query_Rule
records.
records.
Related tables:
Campaign_Query_Rule_Real_Time (via QueryRuleID)
Campaign_Query_Rule_Half_Hour (via QueryRuleID)
Campaign_Query_Rule (via QueryRuleID)
Table 2-128 Query_Rule Table
Field Name
Description
Data Type
Keys and Null
Option
Option
QueryRuleID
A unique identifier for this Query rule.
int
PK, NOT NULL
QueryRuleName
The customer-entered name for this query rule.
varchar(32)
LK, NOT NULL
ImportRuleID
Identifies (indirectly) the contact list to which this query
rule refers. Foreign key from the Import Rule table.
rule refers. Foreign key from the Import Rule table.
int
FK, NOT NULL
Deleted
Deleted Flag. Stored as a character:
Y = Yes
N = No
N = No
char(1)
NULL
Description
Description of what the query rule contains or how it is
being used.
being used.
varchar(255)
NULL
ChangeStamp
Incremented when the record is changed in the central
database.
database.
int
NOT NULL
Enabled
Setting of query rule within this campaign:
Y = The query rule is enabled.
N = the query rule is not enabled.
N = the query rule is not enabled.
char(1)
NOT NULL