tblPrincipal

  • Article

tblPrincipal contains all principals, including users, folders, and groups.

Columns

Column Type Description
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
Skype for Business client 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.

Keys

Column Description
prinID
Primary key.
prinTypeID
Foreign key with lookup in tblPrincipalType.ptypeID table.