Cisco Cisco IP Contact Center Release 4.6.2 Technical References

Page of 620
Keys and Null
Option:
Data Type:
Description:
Field Name:
NOT NULL
DBINT
Total time, in seconds, that trunks in the I-group were not busy
with in or out calls.
TrunkIdleTime
Group_Security_Control Table
To see database rules for these tables, click
Each row describes the access members of a group have for a specific object. This table is used
as an intermediate step in creating User_Security_Control records for each member of the group.
Related table
 (via UserGroupID)
Table 105: Indexes for Group_Security_Control Table
index_keys
index_description
index_name
ObjectID, ObjectType, UserGroupName
nonclustered located on PRIMARY
XIE1Group_Security_Control
UserGroupID
nonclustered located on PRIMARY
XIE2Group_Security_Control
Fields in Group_Security_Control Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
DBINT
Identifies the level of access group members have to the object.To see
values. click 
.
AccessLevel
IE-1NOT NULL
DBINT
Together with ObjectType, identifies the object.
ObjectID
IE-1NOT NULL
DBINT
Together with ObjectID, identifies the object.
ObjectType
NOT NULL
DBINT
If the access to the object was inherited from a class, this field
identifies that class. Otherwise, it is 0.
OriginClassID
NOT NULL
DBINT
If the access to the object was inherited from another object, this field
identifies that object. Otherwise, it is 0.
OriginObjectID
NOT NULL
DBINT
If the access to the object was inherited from another object, this field
identifies the type that object.
OriginObjectType
IE-2 NOT NULL
DBINT
Identifies the user group.
UserGroupID
IE-1 NOT NULL
varchar(64)
Identifies the user group. Only groups of type ‘G’ are referenced.
UserGroupName
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
208
Chapter 2:  All Tables
Group_Security_Control Table