Dim.WorkitemStatus
All Workitems in have an attribute called Status. This is a single select list used to indicate the Workitems Status (i.e. Future, Done). This table contains Type 1 data for the Workitem Status values defined in your instance.
Table Description
| Column Name | Description | DataType |
|---|---|---|
| WorkitemStatusKey | Data Mart unique identifier for this value | int |
| WorkitemStatusOid | Identifier for this value | int |
| WorkitemStatusName | Name | nvarchar |
| WorkitemStatusOrder | The order this value appears in the dropdown list | nvarchar |
| WorkitemStatusAssetState | State of the list value (Active or Closed) | varchar |
| WorkitemStatusReportingCategory | The Reporting Category assigned to this Status Value | varchar |
| WorkitemStatusCreateDateUTC | UTC Date the value was created | datetime |
| WorkitemStatusLastModifiedDateUTC | UTC Date the value was last modified | datetime |
| WorkitemStatusCreatedByKey | Data Mart identifier of the Member that created this value | int |
| WorkitemStatusLastModifiedByKey | Data Mart identifier of the Member that last modified this value | int |
| WorkitemStatusCreateDateKey | Foreign Key to Dim.Date for the Create Date | int |
| WorkitemStatusLastModifiedDateKey | Foreign Key to Dim.Date for the Last Modified Date | int |