Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-426
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
User_Group Table
User_Group Table
Lists the groups of users to which specific access rights apply. A record in this table can represent a
group of users (with multiple associated records in the User_Group_Member table) or a single user (with
a single associated record in the User_Group_Member table).
group of users (with multiple associated records in the User_Group_Member table) or a single user (with
a single associated record in the User_Group_Member table).
Use Configuration Manager to create, update, and delete user groups.
Table 2-387 User_Group Table Constraints
Constraint
Field Name(s)
PK
UserGroupID
AK-1
UserGroupName
FK
CustomerDefinitionID
FeatureSetID
FeatureSetID
IE-1
CustomerDefinitionID
Table 2-388 User_Group Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
ChangeStamp
Incremented when the record is changed in the
central database.
central database.
CHANGESTAMP
NOT NULL
CustomerDefinitionID
Identifies the customer associated with the user
group.
group.
DBINT
FK, IE-1
NULL
Description
Additional information about the group.
DESCRIPTION
NULL
FeatureSetID
Identifies a feature set from the
Feature_Control_Set Table.
Feature_Control_Set Table.
DBINT
FK
NULL
ReadOnly
Valid options include:
Y = Read-only user.
N = Normal user.
N = Normal user.
DBCHAR
NOT NULL
ServiceProvider
Valid options include:
Y = Service provider or normal customer.
N = Service bureau customer.
N = Service bureau customer.
DBCHAR
NOT NULL
UserGroupID
A unique identifier for the group.
DBINT
PK
NOT NULL
UserGroupName
The name of the group.
varchar(30)
AK-1
NOT NULL
UserGroupType
The type of the group:
U = for an individual user.
G = for a group of users.
G = for a group of users.
char(1)
NOT NULL