Technical References

Keys and Null Option:Data Type:Description:Field Name:
NOT NULLDBSMALLINT
The type of node:
Type
• 1 = Primary Distributor
• 2 = Backup Distributor
ICR_View Table
This table is in the Schedule category (page 450). To see database rules, click here (page 508).
Each ICR_View describes how the ICM software interprets the data imported for a schedule.
The individual columns within the view are described in associated View_Column rows.
Related table
Schedule (page 305) (via ICRViewID)
View Column (page 433) (via ICRViewID)
Table 109: Indexes for ICR_View Table
index_keysindex_descriptionindex_name
EnterpriseNamenonclustered, unique, unique key
located on PRIMARY
XAK1ICR_View
ICRViewIDclustered, unique, primary key
located on PRIMARY
XPKICR_View
Fields in ICR_View Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLVNAME32
The name of the table in the system from which it is imported.
BaseTableName
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NULLDESCRIPTION
Additional information about the view.
Description
AK-1 NOT NULLVNAME32
A unique name for the view.
EnterpriseName
PK NOT NULLDBINT
A unique identifier for the view.
ICRViewID
NOT NULLDBCHAR
Indicates whether fields in the Schedule Import table can be read
directly rather than through a view. Valid options are:
ReadBaseTable
• Y = Yes
• N = No
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
215
Chapter 2: All Tables
ICR_View Table