Cisco Cisco Unified Contact Center Enterprise 9.0(1) Referências técnicas
ICR_View
This table is in the
category. To see database rules, see
Each ICR_View describes how the system software interprets the data imported for a schedule. The individual
columns within the view are described in associated View_Column rows.
columns within the view are described in associated View_Column rows.
Related table
(via ICRViewID)
(via ICRViewID)
Table 183: Indexes for ICR_View Table
index_keys
index_description
index_name
EnterpriseName
nonclustered, unique, unique key located
on PRIMARY
on PRIMARY
XAK1ICR_View
ICRViewID
clustered, unique, primary key located
on PRIMARY
on PRIMARY
XPKICR_View
Table 184: Fields in ICR_View table
Keys and
NULL
Option
NULL
Option
Data Type
Description
Name
NOT
NULL
NULL
VNAME32
The name of the table in the system from which it
is imported.
is imported.
BaseTableName
NOT
NULL
NULL
CHANGESTAMP
Incremented when the record is changed in the
central database.
central database.
ChangeStamp
NULL
DESCRIPTION
Additional information about the view.
Description
AK-1 NOT
NULL
NULL
VNAME32
A unique name for the view.
EnterpriseName
PK NOT
NULL
NULL
DBINT
A unique identifier for the view.
ICRViewID
NOT
NULL
NULL
DBCHAR
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
ReadBaseTable
Database Schema Guide for Cisco Unified Contact Center Enterprise Release 9.0
297
All tables
ICR_View