Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 620
Table 65: Indexes for Class_Security Table
index_keys
index_description
index_name
ClassSecurityID
clustered, unique, primary key
located on PRIMARY
XPKClass_Security
Fields in Class_Security Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
DBINT
The access level the user group has for the class. To see values.
click 
.
AccessLevel
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NOT NULL
DBINT
Identifies the class from the Class_List table.
ClassID
PK NOT NULL
DBINT
A unique identifier for the record.
ClassSecurityID
NOT NULL
varchar(64)
Identifies the user group.
UserGroupName
ClassID_To_ObjectType Table
To see database rules for these tables, click
Maps each class to its component object types
Related Tables
 (via ObjectType + ObjectID)
Table 66: Indexes for ClassID_To_ObjectType Table
index_keys
index_description
index_name
ObjectType
nonclustered located on PRIMARY
XIE1ClassID_To_ObjectType
ClassID, ObjectType
nclustered, unique, primary key
located on PRIMARY
XPKClassID_To_ObjectType
Fields in ClassID_To_ObjectType Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
PK, FK NOT NULL
DBINT
Identifies the class from the Class_List table.
ClassID
NOT NULL
DBINT
For Logical Interface Controller objects:
ObjectID
• 2 = PG
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
150
Chapter 2:  All Tables
ClassID_To_ObjectType Table