Active |
Defines if the row contains active data. Inactive means logically deleted. |
CaseId |
The ID of the case this data belongs to |
CaseReferenceComment |
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 |
ReferencedCaseId |
The case this references. FK to Cases |
Version |
The number of times the data was been changed. See the corresponding AUDIT table for full audit trail. |