Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 620
Keys and Null Option:
Data Type:
Description:
Field Name:
NULL
varchar(64)
Reserved for future use
FutureUseVarchar2
NULL
varchar(64)
Reserved for future use
FutureUseVarchar3
FK NOT NULL
DBINT
Identifies (indirectly) the contact list to which this query rule refers.
Foreign key from the Import Rule table.
ImportRuleID
PK NOT NULL
DBINT
A unique identifier for this Query rule.
QueryRuleID
AK-1 NOT NULL
VNAME32
The customer-entered name for this query rule.
QueryRuleName
Query_Rule_Clause Table
To see database rules for these tables,
click 
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
Table 148: Indexes for Query_Rule_Clause Table
index_keys
index_description
index_name
QueryRuleID, SequenceNumber
clustered, unique, primary key
located on PRIMARY
XPKList_Rule
Fields in Query_Rule_Clause Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
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)
268
Chapter 2:  All Tables
Query_Rule_Clause Table