Cisco Cisco E-Mail Manager Unity Integration Option Technical References

CustomerDefinitionID

nonclustered located on PRIMARY

XIE1User_Group

UserGroupID

nonclustered, unique, primary key
located on PRIMARY

XPKUser_Group

NOT NULL

CHANGESTAMP

Incremented when the record is changed in the central database.

ChangeStamp

FK, IE-1 NULL

DBINT

Identifies the customer associated with the user group.

CustomerDefinitionID

NULL

DESCRIPTION

Additional information about the group.

Description

NULL

Varchar(64)

DNS format of the Active Directory domain name.

DomainName

FK NULL

DBINT

Identifies a feature set from the Feature_Control_Set Table.

FeatureSetID

NOT NULL

DBCHAR

Valid options include:

ReadOnly

• Y = Read-only user

• N = Normal user

NOT NULL

DBCHAR

Valid options include:

ServiceProvider

• Y = Service provider or normal customer

• N = Service bureau customer.

Note: This field is no longer used.

PK NOT NULL

DBINT

A unique identifier for the group.

UserGroupID

AK-1 NOT NULL

varchar(64)

The name of a user or a group.

UserGroupName

NOT NULL

char(1)

The type of the group:

UserGroupType

• U = for an individual user

• G = for a group of users.

NULL

Varchar (64)

Unique ID for an Active Directory user.

UserGuid

NULL

Varchar (64)

Active Directory user logon name.

UserName

Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)