Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 620
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
VNAME32
The name of the view.
ViewName
NOT NULL
DBINT
The type of view.
ViewType
Ids Table
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 110: 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
PK, FK NOT NULL
DBINT
Identifies the object type.
ObjectType
NOT NULL
DBINT
Identifies the object’s parent. A value of 0 indicates that the object
has no parent.
ParentObjectID
NOT NULL
DBINT
Identifies the object type of the object’s parent. For example, a
peripheral is a parent to its trunk groups. A value of 0 indicates that
the object has no parent.
ParentObjectType
Import_Log Table
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
216
Chapter 2:  All Tables
Ids Table