Represents a historical record of a particular business unit from a closed repository
Data model
Fields
| Field | Type | Description |
|---|---|---|
| action_id* | INT | History type identifier, (1 = creation, 2 = edit, 5 = file added, 6 = file deleted, 9 = note, 14 = reopened, 15 = closed, 20 = baseline, 21 = related article addition, 21 = article deletion, 23 = restored baseline, 24 = converted) |
| author_id* | INT | Identifier of the user who created the record, reference the table AFW_USERS.user_id |
| author_name* | NVARCHAR (510) | Name of the user who created the record |
| created* | DATETIME | Record creation date |
| description | NVARCHAR (MAX) | Description of the historical change in html or Json format that represents the values before and after modification of the properties of an item |
| description_nohtml | NVARCHAR (MAX) | Description of the historical record without html elements |
| id* | INT | Unique identifier of the record |
| item_id* | INT | Related Business Unit Item Identifier |
| item_rev | INT | Item revision number |
| item_type_id* | INT | Related item type, reference table ASMS_TYPES.id |
| visible* | BIT | Indicates whether the record is visible, (0 = not visible, 1 = visible) |