Contains item log information in DataWareHouse
Data model
Fields
| Field | Type | Description |
|---|---|---|
| author_id | INT | Identifier of the user who authored the article |
| 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) | Article Contents |
| created_date | DATETIME | Article creation date |
| description | NVARCHAR (510) | Article Overview |
| enable_groups_relation | BIT | Last Configuration Setting for Enabling Group Relationships |
| group_id | INT | Identifier of the specialist group to which the responsible user belongs |
| 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 ID related to the item |
| 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 |
| 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 | Identifier of the previous to the current state related to the item |
| project_id | INT | Project ID related to the item |
| 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 |
| 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 |
| 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 last registered status for the item |
| state_name | NVARCHAR (510) | Name of the current status related to the item |
| title* | NVARCHAR (510) | Article Title |
| type_id | INT | Item model type identifier |
| type_name | NVARCHAR (510) | Item Model Name |
| 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_LAST |
|---|
| id |