Topic Last Modified: 2011-01-27

The PrincipalAffiliations table contains the principal affiliations that describe memberships in locations including Active Directory Domain Services (AD DS) security groups, in Active Directory containers, in federated groups.

Columns

Column Type Description

principalID

int, not null

ID of the affiliated principal.

affiliationID

int, not null

ID of the principal representing the affiliation. Each principal (except system-user-types) has a self-affiliation as well.

index

int, not null

Index. The value for self-affiliations is -1, and for the other affiliations it increases sequentially from 1 within each <principalID, affiliationId> bucket.

updatedBy

int, not null

Principal that did the latest update. This is usually 1, which means Active Directory Sync.

Keys

Columns Description

<principalID, index, affiliationID>

Primary key.

principalID

Foreign key with lookup in Principal.prinID table.

affiliationID

Foreign key with lookup in Principal.prinID table.