Cisco Cisco Unified Intelligent Contact Management Software Technical References
(via QueryRuleID)
(via QueryRuleID)
(via QueryRuleID)
(via ImportRuleID)
Table 147: Indexes for Query_Rule Table
index_keys
index_description
index_name
QueryRuleName
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Query_Rule
QueryRuleID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKQuery_Rule
Fields in Query_Rule Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NOT NULL
DBCHAR
Deleted Flag. Stored as a character:
Deleted
• Y = Yes
• N = No
NULL
DESCRIPTION
Description of what the query rule contains or how it is being used.
Description
NOT NULL
DBCHAR
Setting of query rule within this campaign:
Enabled
• Y = The query rule is enabled.
• N = the query rule is not enabled.
NULL
DBINT
Reserved for future use
FutureUseInt1
NULL
DBINT
Reserved for future use
FutureUseInt2
NULL
DBINT
Reserved for future use
FutureUseInt3
NULL
DBINT
Reserved for future use
FutureUseInt4
NULL
DBINT
Reserved for future use
FutureUseInt5
NULL
varchar(64)
Reserved for future use
FutureUseVarchar1
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
267
Chapter 2: All Tables
Query_Rule Table