Technical References

Keys and Null Option:Data Type:Description:Field Name:
NULLvarchar(64)
Reserved for future use
FutureUseVarchar2
NULLvarchar(64)
Reserved for future use
FutureUseVarchar3
FK NOT NULLDBINT
Identifies (indirectly) the contact list to which this query rule refers.
Foreign key from the Import Rule table.
ImportRuleID
PK NOT NULLDBINT
A unique identifier for this Query rule.
QueryRuleID
AK-1 NOT NULLVNAME32
The customer-entered name for this query rule.
QueryRuleName
Query_Rule_Clause Table
This table is in the Blended Agent category (page 439). To see database rules for these tables,
click here (page 503).
Note: If Outbound Option was not selected during setup, this table will contain no data.
Contains the SQL rules associated with each query rule. There is a single row for each configured
query rule.
Related table
Query_Rule (page 266) (via QueryRuleID)
Table 148: Indexes for Query_Rule_Clause Table
index_keysindex_descriptionindex_name
QueryRuleID, SequenceNumberclustered, unique, primary key
located on PRIMARY
XPKList_Rule
Fields in Query_Rule_Clause Table:
Keys and Null Option:Data Type:Description:Field Name:
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)
268
Chapter 2: All Tables
Query_Rule_Clause Table