Cisco Cisco IP Contact Center Release 4.6.1 Technische Referenzen

Seite von 557
Fields in ICR_View Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
VNAME32
The name of the table in the system from which it is
imported.
BaseTableName
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the
central database.
ChangeStamp
NULL
DESCRIPTION
Additional information about the view.
Description
AK-1 NOT NULL
VNAME32
A unique name for the view.
EnterpriseName
PK NOT NULL
DBINT
A unique identifier for the view.
ICRViewID
NOT NULL
DBCHAR
Indicates whether fields in the Schedule Import table
can be read directly rather than through a view. Valid
options are:
ReadBaseTable
• Y = Yes
• N = No
NOT NULL
VNAME32
The name of the view.
ViewName
NOT NULL
DBINT
The type of view.
ViewType
Ids Table
This table is in the 
To see database rules for these tables, click
Indicates whether a specific object type supports row-level security. For those object types that
do support row-level security, the Ids table contains one row for each object of that type.
Related tables
 (via ObjectType + ObjectID)
 (via ObjectType + ObjectID)
Table 109: Indexes for IDs Table
index_keys
index_description
index_name
ObjectType, ObjectID
clustered, unique, primary key
located on PRIMARY
XPKIds
Fields in Ids Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
PK NOT NULL
DBINT
Identifies a specific object for which row-level security
is supported. If the object type does not support row-level
security, this value is 0.
ObjectID
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
177
Chapter 2:  All Tables
Ids Table