Contains version information about cases in the ASMS suite - DataWareHouse
Data model
Fields
| Field | Type | Description |
|---|---|---|
| cause | NVARCHAR (MAX) | Case Cause |
| cause_nohtml | NVARCHAR (MAX) | Case Cause Without HTML Elements |
| commentary | NVARCHAR (MAX) | Case Solution |
| commentary_nohtml | NVARCHAR (MAX) | Case solution without HTML elements |
| description | NVARCHAR (MAX) | Case description |
| description_nohtml | NVARCHAR (MAX) | Description of the case without HTML elements |
| end_date | DATETIME2 | Date that represents the end of the validity of the registration |
| is_current* | BIT | Indicates that the current row is the most recent row for each value in the dimension. |
| item_sk* | INT | Case ID |
| start_date* | DATETIME2 | Date that represents the start of the validity of the registration |
| subject | NVARCHAR (800) | Describe the subject of the case |
Primary Key
| PK_DIM_ASDK_ITEM_TEXT |
|---|
| item_sk, start_date |