Topic Last Modified: 2011-01-27

The PrincipalType table contains principal types to categorize what is in the Principal table.

Columns

Column Type Description

ptypeID

smallint, not null

Principal type ID.

ptypeDesc

nvarchar (256), not null

Description of the type.

ptypeIsSystemUser

bit, not null

True if the type corresponds to the principals that are used for internal purposes.

ptypeIsUser

bit, not null

True if the type is a user type.

ptypeIsFederated

bit, not null

True if the type is a federated concept (group or user).

Key

Column Description

ptypeID

Primary key.

Principal Values

ID Role Description SystemUser User Federated

1

Any

Generic principal with no known type. Not used in tblPrincipal table.

2

AnyUser

Generic principal of user type. Not used in Principal table.

Yes

3

AnyGroup

Generic principal with group semantic. Not used in Principal table.

4

SystemUser

Principal used internally by Microsoft Lync Server 2010, Group Chat.

Yes

5

User

Regular user (not federated).

Yes

6

ExternalUser

Carried over for MindAlign 6.x compatibility. Not used currently.

Yes

7

FederatedUser

Federated user.

Yes

Yes

8

DC

Active Directory Domain Services (AD DS) domain controller.

9

Group

Active Directory security group.

10

Folder

Active Directory container or organizational unit.

11

Federated Group

Federated group.

Yes

See Also

Concepts

Principal Table