prinID

int, not null

Principal ID.

prinGuid

GUID, not null

Principal GUID. This is broadly used as an alternate primary key because its meaning crosses over into the Active Directory Domain Services space. (The GUID for a cached principal is equal to the corresponding Active Directory object GUID.)

prinUri

nvarchar (256), not null

Principal URI. The SIP scheme is used for users, and ma-grp is used for almost everything else.

prinName

nvarchar (256)

Common name. Used only by user types.

prinDisplayName

Nvarchar (256)

Display name. Used only by user types.

prinCompanyName

nvarchar (256)

Company name. Used only by user types.

prinEmail

nvarchar (256)

Email. Used only by user types.

prinADPath

nvarchar (384)

Domain name of the Active Directory object that the principal is a cached version of. Can be Null for types that are not Active Directory objects (such as system users).

prinADUserPrincipalName

nvarchar (256)

User’s user principal name (UPN). Used only by regular user types.

prinDisabled

smallint, not null

• 0: Principal is active.

• 1: Principal is disabled because user’s SIP capabilities are disabled.

• 2: Principal is deleted because associated AD object has been deleted.

prinTypeID

smallint, not null

Principal type (from tblPrincipalType table).

prinPoolID

Int

Lync pool assignment for the principal.

prinPolicyID

Int

Persistent Chat Server policy value for user, if tag type policy is present.

prinAddedBy

int

Principal ID of the creator.

prinAddedOn

bigint, not null

Time stamp for the creation time.

prinUpdatedBy

int

ID of the principal that last updated this.

prinUpdatedOn

bigint, not null

Time stamp for the last update.

prinVerifiedOn

datetime, not null

Date and time of the last Active Directory Sync refresh for the principal.

prinID

Primary key.

prinTypeID

Foreign key with lookup in tblPrincipalType.ptypeID table.