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
PK, FK NOT NULLDBINT
The query rule to which this clause belongs. Foreign key from the
Query Rule table.
QueryRuleID
NOT NULLvarchar(255)
The rule definition to be used to process each query rule.
RuleData
PK NOT NULLDBINT
An index for query rule clauses within a given query rule.
SequenceNumber
Reason_Code Table
This table is part of the Script category (page 451). For database rules, click here. (page 509)
Configuration table containing the reason code text to reason code mapping information.
Table 149: Indexes for Reason_Code Table
index_keysindex_descriptionindex_name
ReasonCodenonclustered, unique, unique key
located on PRIMARY
XAK1Reason_Code
ReasonCodeIDclustered, unique, primary key
located on PRIMARY
XPKReason_Code
Fields in Reason_Code 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
Default value is N.
Deleted
NULLDESCRIPTION
The description of the reason code.
Description
AK-1 NOT NULLDBINT
Reason code used by agents (configurable).
ReasonCode
PK NOT NULLDBINT
A unique identifier created by the schema.
ReasonCodeID
NOT NULLvarchar(40)
Text associated with the reason code numeric value.
ReasonText
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
269
Chapter 2: All Tables
Reason_Code Table