Technical References

Keys and Null Option:Data Type:Description:Field Name:
IE-1 NOT NULLDBINT
The number of the major version; for example, if the version is 1.2,
this value is 1.
Major
View_Column Table
This table is in the Schedule category (page 450). To see database rules, click here (page 508).
Describes how the ICM software interprets one column of imported schedule data.
Related table
ICR View (page 215) (via ICRViewID)
Table 217: Indexes for View_Column Table
index_keysindex_descriptionindex_name
ICRViewID, ColumnNumbernonclustered, unique, unique key
located on PRIMARY
XAK1View_Column
ICRViewID, ViewNamenonclustered, unique, unique key
located on PRIMARY
XAK2View_Column
ViewColumnIDclustered, unique, primary key
located on PRIMARY
XPKView_Column
Fields in View_Column Table:
Keys and Null Option:Data Type:Description:Field Name:
NULLVNAME32
The name used for the column in the system from which it imported.
BaseName
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
AK-1 NOT NULLDBINT
Indicates the position of the column within the Schedule Import
table.
ColumnNumber
NULLDESCRIPTION
Additional information about the column.
Description
NOT NULLDBCHAR
Indicates whether the View_Column record can be modified. Stored
as a character:
Edit
• Y = yes
• N = no
AK-1, AK-2, FK NOT NULLDBINT
Identifies the view to which the column belongs.
ICRViewID
NULLDBINT
Indicates which bit positions to use in the value. An AND operation
is applied to the mask value and the field value.
Mask
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
433
Chapter 2: All Tables
View_Column Table