Skip to main content
System StatusContact Support
VersionOne Community

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
  • Was this article helpful?