Cisco Cisco IP Contact Center Release 4.6.2 Technical References
2-244
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
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 Outbound Option Configuration option within ICM Configuration Manager to modify
Query_Rule records.
Query_Rule records.
Related tables:
(via QueryRuleID)
(via QueryRuleID)
(via QueryRuleID)
Table 2-258 Query_Rule Table Constraints
Constraint
Field Name(s)
PK
QueryRuleID
AK-1
QueryRuleName
FK
ImportRuleID
Table 2-259 Query_Rule Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
ChangeStamp
Incremented when the record is changed in the
central database.
central database.
CHANGESTAMP
NOT NULL
Deleted
Deleted Flag. Stored as a character:
Y = Yes
N = No
N = No
DBCHAR
NOT NULL
Description
Description of what the query rule contains or how
it is being used.
it is being used.
DESCRIPTION
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.
DBCHAR
NOT NULL
ImportRuleID
Identifies (indirectly) the contact list to which this
query rule refers. Foreign key from the Import
Rule table.
query rule refers. Foreign key from the Import
Rule table.
DBINT
FK
NOT NULL
QueryRuleID
A unique identifier for this Query rule.
DBINT
PK
NOT NULL
QueryRuleName
The customer-entered name for this query rule.
VNAME32
AK-1
NOT NULL