Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-66
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Class_Security Table
Related tables:
Class Security (via ClassID)
ClassID To ObjectType (via ClassID)
Class_Security Table
Lists the level of security each user or group has for a class.
Related tables:
Class List (via ClassID)
User Group (via UserGroupName)
ClassID_To_ObjectType Table
Maps each class to its component object types.
Table 2-46 Class_Security Table
Field Name
Description
Data Type
Keys and Null
Option
Option
ClassSecurityID
A unique identifier for the record.
int
PK, NOT NULL
ClassID
Identifies the class from the Class_List table.
int
NOT NULL
UserGroupName
Identifies the user group.
varchar(30)
NOT NULL
AccessLevel
The access level the user group has for the class.
int
NOT NULL
ChangeStamp
Incremented when the record is changed in the central
database.
database.
int
NOT NULL
Table 2-47 ClassID_To_Object Table
Field Name
Description
Data Type
Keys and Null
Option
Option
ClassID
Identifies the class from the Class_List table.
int
PK, FK, NOT
NULL
NULL
ObjectType
Identifies the type of the object.
int
PK, FK, NOT
NULL
NULL
ObjectID
For Logical Interface Controller objects:
2 = PG
3 = NIC
3 = NIC
Note
For all other object types, this field is 0.
int
NOT NULL