Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technical References
2-137
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Object_Security Table
Related tables:
ClassID To ObjectType (via ObjectType)
Ids (via ObjectType)
Object Access Xref (via ObjectType)
Object_Security Table
Specifies the access level each user or group has to individual objects.
Related tables:
Ids (via ObjectType)
User Group (via UserGroupName)
Peripheral Table
Each row corresponds to an ACD or PBX at a call center.
Use the PG Explorer to add, update, and delete Peripheral records.
Table 2-117 Object_Security Table
Field Name
Description
Data Type
Keys and Null
Option
Option
ObjectSecurityID
A unique identifier for the row.
int
PK, NOT NULL
ObjectType
Identifies the type of object.
int
AK1, NOT
NULL
NULL
ObjectID
Identifies the specific object.
int
AK1, NOT
NULL
NULL
UserGroupName
Identifies the user group.
varchar(30)
AK1, IE1, NOT
NULL
NULL
AccessLevel
Specifies the access level the group has to the object.
int
NOT NULL
ChangeStamp
Incremented when the record is changed in the central
database.
database.
int
NOT NULL
Table 2-118 Peripheral Table
Field Name
Description
Data Type
Keys and Null
Option
Option
PeripheralID
A unique identifier for this peripheral.
smallint
PK, NOT NULL
LogicalControllerID
Foreign key of the Logical Interface Controller
(Peripheral Gateway) that is attached to the
switch.
(Peripheral Gateway) that is attached to the
switch.
smallint
IE2, FK, NOT
NULL
NULL