Technical References

Campaign_Query_Rule_Real_Time (page 137) (via QueryRuleID)
Campaign_Query_Rule_Half_Hour (page 134) (via QueryRuleID)
Campaign_Query_Rule (page 131) (via QueryRuleID)
Dialer Detail (page 163) (via QueryRuleID)
Import Rule (page 217) (via ImportRuleID)
Table 147: Indexes for Query_Rule Table
index_keysindex_descriptionindex_name
QueryRuleNamenonclustered, unique, unique key
located on PRIMARY
XAK1Query_Rule
QueryRuleIDclustered, unique, primary key
located on PRIMARY
XPKQuery_Rule
Fields in Query_Rule Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NOT NULLDBCHAR
Deleted Flag. Stored as a character:
Deleted
• Y = Yes
• N = No
NULLDESCRIPTION
Description of what the query rule contains or how it is being used.
Description
NOT NULLDBCHAR
Setting of query rule within this campaign:
Enabled
• Y = The query rule is enabled.
• N = the query rule is not enabled.
NULLDBINT
Reserved for future use
FutureUseInt1
NULLDBINT
Reserved for future use
FutureUseInt2
NULLDBINT
Reserved for future use
FutureUseInt3
NULLDBINT
Reserved for future use
FutureUseInt4
NULLDBINT
Reserved for future use
FutureUseInt5
NULLvarchar(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