Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco IPCC Web Option
  5. Technical References

Cisco Cisco IPCC Web Option Technical References

Download
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
PK, FK NOT NULL
DBINT
The query rule to which this clause belongs. Foreign key from the
Query Rule table.
QueryRuleID
NOT NULL
varchar(255)
The rule definition to be used to process each query rule.
RuleData
PK NOT NULL
DBINT
An index for query rule clauses within a given query rule.
SequenceNumber
Reason_Code Table
This table is part of the 
Configuration table containing the reason code text to reason code mapping information.
Table 149: Indexes for Reason_Code Table
index_keys
index_description
index_name
ReasonCode
nonclustered, unique, unique key
located on PRIMARY
XAK1Reason_Code
ReasonCodeID
clustered, unique, primary key
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.
ChangeStamp
NOT NULL
DBCHAR
Default value is N.
Deleted
NULL
DESCRIPTION
The description of the reason code.
Description
AK-1 NOT NULL
DBINT
Reason code used by agents (configurable).
ReasonCode
PK NOT NULL
DBINT
A unique identifier created by the schema.
ReasonCodeID
NOT NULL
varchar(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