Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-287
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
User_Group_Member Table
Related tables:
Class Security (via UserGroupName)
Customer Definition (via CustomerDefinitionID)
Object Security (via UserGroupName)
User Group Member (via UserGroupName)
User_Group_Member Table
Lists the specific users that are members of each user group. If the group is of type “U then it has a single
User_Group_Member record. If the group is of type 'G' is can have multiple User_Group_Member
records. A single user can be a member of multiple user groups.
User_Group_Member record. If the group is of type 'G' is can have multiple User_Group_Member
records. A single user can be a member of multiple user groups.
Use Configuration Manager to create, update, and delete User Group Member records.
Related tables:
User Group (via UserGroupName)
FeatureSetID
Identifies a feature set from the Feature_Control_Set
Table.
Table.
int
FK, NULL
ChangeStamp
Incremented when the record is changed in the central
database.
database.
int
NOT NULL
Table 2-190 User_Group Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option
Table 2-191 User_Group_Member Table
Field Name
Description
Data Type
Keys and Null
Option
Option
UserGroupMemberID
A unique identifier for the record.
int
PK, NOT NULL
UserGroupName
The group to which the member belongs.
varchar(30)
AK1, NOT
NULL
NULL
UserName
The username as registered with SQL Server.
varchar(30)
AK1, IE1, NOT
NULL
NULL
ChangeStamp
Incremented when the record is changed in the central
database.
database.
int
NOT NULL