tblPrincipal in Lync Server 2013

 

Topic Last Modified: 2012-09-12

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	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.

Keys

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