Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco Unified Contact Center Enterprise 9.0(2)
  5. Technical References

Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technical References

Download
Page of 620
Keys and Null Option:
Data Type:
Description:
Field Name:
IE-1 NOT NULL
DBINT
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 
Describes how the ICM software interprets one column of imported schedule data.
Related table
 (via ICRViewID)
Table 217: Indexes for View_Column Table
index_keys
index_description
index_name
ICRViewID, ColumnNumber
nonclustered, unique, unique key
located on PRIMARY
XAK1View_Column
ICRViewID, ViewName
nonclustered, unique, unique key
located on PRIMARY
XAK2View_Column
ViewColumnID
clustered, unique, primary key
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.
BaseName
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
AK-1 NOT NULL
DBINT
Indicates the position of the column within the Schedule Import
table.
ColumnNumber
NULL
DESCRIPTION
Additional information about the column.
Description
NOT NULL
DBCHAR
Indicates whether the View_Column record can be modified. Stored
as a character:
Edit
• Y = yes
• N = no
AK-1, AK-2, FK NOT NULL
DBINT
Identifies the view to which the column belongs.
ICRViewID
NULL
DBINT
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