Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technical References
2-187
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
ICR_View Table
ICR_View Table
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.
individual columns within the view are described in associated View_Column rows.
Related tables:
(via ICRViewID)
(via ICRViewID)
Table 2-185 ICR_View Table Constraints
Constraint
Field Name(s)
PK
ICRViewID
AK-1
EnterpriseName
Table 2-186 ICR_View Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
BaseTableName
The name of the table in the system from which it
is imported.
is imported.
VNAME32
NOT NULL
ChangeStamp
Incremented when the record is changed in the
central database.
central database.
CHANGESTAMP
NOT NULL
Description
Additional information about the view.
DESCRIPTION
NULL
EnterpriseName
A unique name for the view.
VNAME32
AK-1
NOT NULL
ICRViewID
A unique identifier for the view.
DBINT
PK
NOT NULL
ReadBaseTable
Indicates whether fields in the Schedule Import
table can be read directly rather than through a
view. Valid options are:
table can be read directly rather than through a
view. Valid options are:
Y = Yes
N = No
N = No
DBCHAR
NOT NULL
ViewName
The name of the view.
VNAME32
NOT NULL
ViewType
The type of view.
DBINT
NOT NULL