Cisco Cisco E-Mail Manager Unity Integration Option Technical References
2-433
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
View_Column Table
Related tables:
(via ICRViewID)
Table 2-400 View_Column Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
BaseName
The name used for the column in the system from
which it imported.
which it imported.
VNAME32
NULL
ChangeStamp
Incremented when the record is changed in the
central database.
central database.
CHANGESTAMP
NOT NULL
ColumnNumber
Indicates the position of the column within the
Schedule Import table.
Schedule Import table.
DBINT
AK-1
NOT NULL
Description
Additional information about the column.
DESCRIPTION
NULL
Edit
Indicates whether the View_Column record can be
modified. Stored as a character:
modified. Stored as a character:
Y = yes
N = no
N = no
DBCHAR
NOT NULL
ICRViewID
Identifies the view to which the column belongs.
DBINT
AK-1,
AK-2, FK
AK-2, FK
NOT NULL
Mask
Indicates which bit positions to use in the value.
An AND operation is applied to the mask value
and the field value.
An AND operation is applied to the mask value
and the field value.
DBINT
NULL
Shift
The number of bit positions to shift the value to
the left.
the left.
DBINT
NULL
ViewColumnID
A unique identifier for the column.
DBINT
PK
NOT NULL
ViewName
The name used for the column within the ICM
software.
software.
VNAME32
AK-2
NOT NULL