Technical References

index_keysindex_descriptionindex_name
CustomerDefinitionIDnonclustered located on PRIMARYXIE1User_Group
UserGroupIDnonclustered, unique, primary key
located on PRIMARY
XPKUser_Group
Fields in User_Group Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
FK, IE-1 NULLDBINT
Identifies the customer associated with the user group.
CustomerDefinitionID
NULLDESCRIPTION
Additional information about the group.
Description
NULLVarchar(64)
DNS format of the Active Directory domain name.
DomainName
FK NULLDBINT
Identifies a feature set from the Feature_Control_Set Table.
FeatureSetID
NOT NULLDBCHAR
Valid options include:
ReadOnly
• Y = Read-only user
• N = Normal user
NOT NULLDBCHAR
Valid options include:
ServiceProvider
• Y = Service provider or normal customer
• N = Service bureau customer.
Note: This field is no longer used.
PK NOT NULLDBINT
A unique identifier for the group.
UserGroupID
AK-1 NOT NULLvarchar(64)
The name of a user or a group.
UserGroupName
NOT NULLchar(1)
The type of the group:
UserGroupType
• U = for an individual user
• G = for a group of users.
NULLVarchar (64)
Unique ID for an Active Directory user.
UserGuid
NULLVarchar (64)
Active Directory user logon name.
UserName
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
428
Chapter 2: All Tables
User_Group Table