Dim.WorkitemPriority
All Workitems in have an attribute called Priority. This is a single select list used to indicate the Workitems Priority (High, Medium, Low). This table contains Type 1 data for the Workitem Priority values defined in your instance.
Table Description
| Column Name | Description | DataType |
|---|---|---|
| WorkitemPriorityKey | Datamart unique identifier for this value | int |
| WorkitemPriorityOid | Identifier for this value | int |
| WorkitemPriorityName | Name | nvarchar |
| WorkitemPriorityOrder | The order this value appears in the dropdown list | int |
| WorkitemPriorityAssetState | State of the list value (Active or Closed) | varchar |
| WorkitemPriorityCreateDateUTC | UTC Date the value was created | datetime |
| WorkitemPriorityLastModifiedDateUTC | UTC Date the value was last modified | datetime |
| WorkitemPriorityCreatedByKey | Data Mart identifier of the Member that created this value | int |
| WorkitemPriorityLastModifiedByKey | Data Mart identifier of the Member that last |