Cisco Cisco IP Contact Center Release 4.6.2 Technical References
2-108
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Group_Security_Control Table
Related tables:
Peripheral (via PeripheralID)
Trunk Group (via TrunkGroupID)
Group_Security_Control Table
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.
intermediate step in creating User_Security_Control records for each member of the group.
Related tables:
User Group (via UserGroupName and UserGroupID)
TrunkIdleTime
Total time, in seconds, that trunks in the I-group were
not busy with in or out calls.
not busy with in or out calls.
int
NOT NULL
OutCallTalkTime
Total time, in seconds, that trunks in this I-group were
used for outbound calls.
used for outbound calls.
int
NOT NULL
LoadODOutHoldTime
Total time, in seconds, that tie-lines and load transfer
trunks in this I-group were used for overflow/diversion
and load transfer of out calls.
trunks in this I-group were used for overflow/diversion
and load transfer of out calls.
int
NOT NULL
RecoveryKey
A value used internally by the ICM software to track
virtual time.
virtual time.
float
AK1, NOT
NULL
NULL
Table 2-86 Galaxy_Trunk_IGroup Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option
Table 2-87 Group_Security_Control Table
Field Name
Description
Data Type
Keys and Null
Option
Option
UserGroupName
Identifies the user group. Only groups of type ‘G’ are
referenced.
referenced.
varchar(30)
IE1, NOT NULL
ObjectType
Together with ObjectID, identifies the object.
int
IE1, NOT NULL
ObjectID
Together with ObjectType, identifies the object.
int
IE1, NOT NULL
OriginClassID
If the access to the object was inherited from a class, this
field identifies that class. Otherwise, it is 0.
field identifies that class. Otherwise, it is 0.
int
NOT NULL
OriginObjectID
If the access to the object was inherited from another
object, this field identifies that object. Otherwise, it is 0.
object, this field identifies that object. Otherwise, it is 0.
int
NOT NULL
AccessLevel
Identifies the level of access group members have to the
object.
object.
int
NOT NULL
UserGroupID
Identifies the user group.
int
IE2, NOT NULL