Active |
Defines if the row contains active data. Inactive means logically deleted. |
AddressBookEntryId |
The ID of the Contact. FK to HH.AddressBookEntry. |
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 |
Description |
Optional description of the record |
Email |
Email address |
GroupId |
The ID of the UserGroup. FK to HH.UserGroups |
GroupName |
Name of user group, fetched from Active Directory |
LoginName |
The users login name from Active Directory |
Sid |
The Security ID from Active Directory (Guid) |
Version |
The number of times the data was been changed. See the corresponding AUDIT table for full audit trail. |