Contains information from the notes related to a case
Data model
Fields
| Field | Type | Description |
|---|---|---|
| is_current* | BIT | Indicates that the current row is the most recent row for each value in the dimension. |
| is_public* | BIT | Indicate if the note is public |
| item_sk* | INT | Case ID |
| note | NVARCHAR (MAX) | Case Note |
| start_date* | DATETIME2 | Date that represents the start of the validity of the registration |
Primary Key
| PK_DIM_ITEM_NOTES |
|---|
| item_sk, start_date |