Skip to main content
System StatusContact Support
VersionOne Community

Dim.WorkitemStatus

This feature is available in Enterprise and Ultimate editions.

All Workitems in VersionOne 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 VersionOne instance.

Table Description

Column Name Description DataType
WorkitemStatusKey Data Mart unique identifier for this value int
WorkitemStatusOid VersionOne identifier for this value int
WorkitemStatusName Name nvarchar
WorkitemStatusOrder The order this value appears in the VersionOne 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
  • Was this article helpful?