/mcpKeys and NULL Option Data Type Description Name NOT NULL DBCHAR Valid options include: • Y = Service provider or general customer • N = Service bureau customer. Note This field is no longer used. ServiceProvider PK NOT NULL DBINT A unique identifier for the group. UserGroupID NOT NULL DBSMALLINT Indicates the User Role for a given user. Values displayed include: • 0 = Supervisors. • 1 = Setup User. • 2 = Config User. UserRole AK-1 NOT NULL varchar(64) The name of a user or a group. UserGroupName NOT NULL char(1) The type of the group: • U = for an individual user • G = for a group of users. UserGroupType NULL Varchar(64) A unique global ID from Active Directory. UserGuid NULL Varchar(64) The user logon name of the user (Username portion of the User's UserPrincipalName). UserName User_Group_Member This table is in the Security category (see Security, on page 633). To see database rules for these tables, see Security Tables, on page 702. 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. Use Configuration Manager to create, update, and delete User Group Member records. Related Table User_Group, on page 599 (via UserGroupID) Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 601 All Tables User_Group_Member