Cisco Cisco IPCC Web Option Technical References
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
DBSMALLINT
The type of node:
Type
• 1 = Primary Distributor
• 2 = Backup Distributor
ICR_View Table
This table is in the
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.
The individual columns within the view are described in associated View_Column rows.
Related table
(via ICRViewID)
(via ICRViewID)
Table 109: Indexes for ICR_View Table
index_keys
index_description
index_name
EnterpriseName
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1ICR_View
ICRViewID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKICR_View
Fields in ICR_View Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
VNAME32
The name of the table in the system from which it is imported.
BaseTableName
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NULL
DESCRIPTION
Additional information about the view.
Description
AK-1 NOT NULL
VNAME32
A unique name for the view.
EnterpriseName
PK NOT NULL
DBINT
A unique identifier for the view.
ICRViewID
NOT NULL
DBCHAR
Indicates whether fields in the Schedule Import table can be read
directly rather than through a view. Valid options are:
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