See Also
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 |
