Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Table 147: Indexes for Query_Rule_Clause Table
index_keys
index_description
index_name
QueryRuleID, SequenceNumber
clustered, unique, primary key
located on PRIMARY
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
NULL
varchar(64)
Reserved for future use
FutureUseVarchar2
NULL
varchar(64)
Reserved for future use
FutureUseVarchar3
PK, FK NOT NULL
DBINT
The query rule to which this clause belongs. Foreign
key from the Query Rule table.
key from the Query Rule table.
QueryRuleID
NOT NULL
varchar(255)
The rule definition to be used to process each query
rule.
rule.
RuleData
PK NOT NULL
DBINT
An index for query rule clauses within a given query
rule.
rule.
SequenceNumber
Reason_Code Table
This table is part of the
Configuration table containing the reason code text to reason code mapping information.
Table 148: Indexes for Reason_Code Table
index_keys
index_description
index_name
ReasonCode
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Reason_Code
ReasonCodeID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKReason_Code
Fields in Reason_Code Table :
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the central
database.
database.
ChangeStamp
NOT NULL
DBCHAR
Default value is N.
Deleted
NULL
DESCRIPTION
The description of the reason code.
Description
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
227
Chapter 2: All Tables
Reason_Code Table