| Active |
Defines if the row contains active data. Inactive means logically deleted. |
| CaseTypeId |
The ID of the type of Case this is. FK to HH.CaseTypes |
| 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 |
| HasSubjectPermissions |
True if this subject requires default permissions to be applied to the case when created. Actual permissions are in HH.PermissionMasks |
| IsHidden |
This data is a system object, hidden for the user. |
| ParentSubjectId |
Parent in a heirachial stucture |
| SubjectDescription |
Optional description of a Subject |
| SubjectId |
The ID of the Subject. FK to HH.Subjects. |
| SubjectName |
The name of the subject |
| SubjectNumber |
An optional logical number, for organizations that use a numbered approach to subjects. |
| SubjectTreeId |
The ID of the SubjectTree. FK to HH.SubjectTree. |
| Version |
The number of times the data was been changed. See the corresponding AUDIT table for full audit trail. |