Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-114
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
ICR_View Table
Related tables:
ICR Instance (via ICRInstanceID)
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:
Schedule (via ICRViewID)
View Column (via ICRViewID)
Table 2-92 ICR_View Table
Field Name
Description
Data Type
Keys and Null
Option
Option
ICRViewID
A unique identifier for the view.
int
PK, NOT NULL
ViewName
The name of the view.
varchar(32)
NOT NULL
EnterpriseName
A unique name for the view.
varchar(32)
AK1, NOT
NULL
NULL
ViewType
The type of view.
int
NOT NULL
BaseTableName
The name of the table in the system from which it is
imported.
imported.
varchar(32)
NOT NULL
ReadBaseTable
Indicates whether fields in the Schedule Import table
can be read directly rather than through a view. Valid
options are:
can be read directly rather than through a view. Valid
options are:
Y = Yes
N = No
N = No
char(1)
NOT NULL
Description
Additional information about the view.
varchar(255)
NULL
ChangeStamp
Incremented when the record is changed in the central
database.
database.
int
NOT NULL