Cisco Cisco IP Contact Center Release 4.6.1 Technical References
A system table containing a single row which indicates the current version of the ICM database
schema installed in the central and local databases. This table is maintained by the ICM software
installation process.
schema installed in the central and local databases. This table is maintained by the ICM software
installation process.
Table 215: Indexes for Version Table
index_keys
index_description
index_name
Major
nonclustered located on PRIMARY
XIE1Version
Fields in Version Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
DBINT
The incremental version number of the local database schema
on the AW. For example, if the version is 1.3, this value is 3.
on the AW. For example, if the version is 1.3, this value is 3.
AWMinor
NOT NULL
DBINT
The incremental version number of the central database
schema. For example, if the version is 1.2, this value is 2.
schema. For example, if the version is 1.2, this value is 2.
CCMinor
NOT NULL
DBINT
Control version of preconfigured items for Simplified IPCC
Deployments.
Deployments.
IPCCMinor
IE-1 NOT NULL
DBINT
The number of the major version; for example, if the version
is 1.2, this value is 1.
is 1.2, this value is 1.
Major
View_Column Table
This table is in the
Describes how the ICM software interprets one column of imported schedule data.
Related table
(via ICRViewID)
Table 216: Indexes for View_Column Table
index_keys
index_description
index_name
ICRViewID, ColumnNumber
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1View_Column
ICRViewID, ViewName
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK2View_Column
ViewColumnID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKView_Column
Fields in View_Column Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NULL
VNAME32
The name used for the column in the system from
which it imported.
which it imported.
BaseName
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the
central database.
central database.
ChangeStamp
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
367
Chapter 2: All Tables
View_Column Table