| Active |
Defines if the row contains active data. Inactive means logically deleted. |
| AddressBookEntryID |
The ID of the Contact this is related to. FK to HH.AddressBookEntry |
| ArchiveID |
The Id of the Archive this subject tree belongs to |
| CertificateHashString |
Not used |
| ChangedBy |
The ID of the user who last edited this data. FK to HH.Users |
| ChangedOn |
The datetime this data was last edited |
| Createdby |
The ID of the user who first created this data. FK to HH.Users |
| CreatedOn |
The datetime this data was first created |
| IsAdministrator |
True if the user is a system user with all priviliges |
| LoginName |
The users login name from Active Directory |
| PrivateFolderID |
Not used |
| SID |
The Security ID from Active Directory (Guid) |
| Upn |
The User Principal Name from Active Directory |
| UserId |
The user who performed the action or own this object |
| UserName |
The logical name of the user from Active Directory |
| UserTypeId |
The ID of the type of user |
| Version |
The number of times the data was been changed. See the corresponding AUDIT table for full audit trail. |