| Active |
Defines if the row contains active data. Inactive means logically deleted. |
| CaseId |
The ID of the case this data belongs to |
| 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 |
| EntityID |
The ID of the object this data belongs to. |
| FolderDescription |
Optional description for a folder |
| FolderId |
The ID of the Folder this data belongs to. |
| FolderName |
The name/title of a folder |
| IsInSync |
True if the document is correctly stored in SharePoint |
| IsLocked |
This data is marked as closed (locked) by the user. |
| ObjTypeID |
The type of object this data belongs to. See also HH.ObjType |
| ParentFolderId |
Parent folder to form a heirarchy. Null if top level. FK to HH.Folders |
| SortOrder |
Number to sort by, for customer specific sorting of the list. |
| Version |
The number of times the data was been changed. See the corresponding AUDIT table for full audit trail. |