Dim.WorkitemPriority
This feature is available in Enterprise and Ultimate editions.
All Workitems in VersionOne have an attribute called Priority. This is a single select list used to indicate the Workitems Priority (i.e. High, Medium, Low). This table contains Type 1 data for the Workitem Priority values defined in your VersionOne instance.
Table Description
Column Name | Description | DataType |
WorkitemPriorityKey | Datamart unique identifier for this value | int |
WorkitemPriorityOid | VersionOne identifier for this value | int |
WorkitemPriorityName | Name | nvarchar |
WorkitemPriorityOrder | The order this value appears in the VersionOne 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 modified this value | int |
WorkitemPriorityCreateDateKey | Foreign Key to Dim.Date for the Create Date | int |
WorkitemPriorityLastModifiedDateKey | Foreign Key to Dim.Date for the Last Modified Date | int |