Contains historical information for each version of the item log in DataWareHouse
Data model
Fields
| Field | Type | Description |
|---|---|---|
| author_id | INT | Identifier of the user who authored the article, references the table AFW_USERS.user_id |
| author_name | NVARCHAR (510) | Name of the user who authored the article |
| class_id | INT | Article Source Type, 0 Internal (Embedded), 1 External (Url) |
| closed_date | DATETIME | Date the item entered closed status |
| content | NVARCHAR (MAX) | Current Article Content |
| created_date | DATETIME | Article creation date |
| description | NVARCHAR (510) | Article Overview |
| group_id | INT | Identifier of the specialist group to which the responsible user belongs, reference to AFW_GROUPS.grou_id |
| group_name | NVARCHAR (510) | Name of the specialist group to which the responsible user belongs |
| hit | FLOAT | Identify the total number of views of the item |
| id* | INT | Unique Item Identifier |
| identifier | NVARCHAR (510) | Alphanumeric code identifying the item |
| integration_id | INT | Integration record identifier related to the item, reference the ASMS_INTEGRATIONS.ID table |
| interface_id | NVARCHAR (200) | Identifier of the source system related to the article, this is given by integration |
| is_public | INT | Identify whether or not the item is public to the customer (0 = not public, 1 = public) |
| keyword | NVARCHAR (510) | List of keywords related to the article |
| modified_date* | DATETIME | Last Date of Article Modification |
| modifier_id | INT | Identifier of the last user who modified the article, references the table AFW_USERS.user_id |
| modifier_name | NVARCHAR (510) | Name of the last user who modified the article |
| note | NVARCHAR (510) | Last article related to the article |
| previous_status_id | INT | Previous status identifier related to the item, reference the table ASMS_STATUS.stat_id |
| project_id | INT | Project ID related to the article, reference the table ASMS_PROJECTS.proj_id |
| project_name | NVARCHAR (510) | Name of the project related to the article |
| rating | FLOAT | Identify the average grade of the item |
| reason_id | INT | Identifier of the reason for the current status related to the item, reference the table ASMS_STATUS_REASON.reas_id |
| reason_name | NVARCHAR (510) | Name of the reason for the current status related to the item |
| responsible_id | INT | Responsible user ID assigned to the item, reference table AFW_USERS.user_id |
| responsible_name | NVARCHAR (510) | Name of the responsible user assigned to the item |
| state_color | NVARCHAR (510) | Text representing the RGB code of the status color related to the item |
| state_final | INT | Indicates whether the item reached a final state, (0 = did not reach final state, 1 = reached final state) |
| state_id | INT | Identifier of the current status related to the item, reference the table ASMS_STATUS.stat_id |
| state_name | NVARCHAR (510) | Name of the current status related to the item |
| title* | NVARCHAR (510) | Article Title |
| type_id | INT | Identifier of the type of case model related to the article, reference the table ASMS_MODEL.id |
| type_name | NVARCHAR (510) | Model name related to the item |
| url | NVARCHAR (2000) | If the source of the article is external, it represents the url where the article is hosted |
Primary Key
| PK_ASS_ARTICLE_DW |
|---|
| id, modified_date |