Skip to main content
System StatusContact Support
VersionOne Community

Dim.TaskStatus

This feature is available in Enterprise and Ultimate editions.

Task assets in VersionOne have an attribute called Status. This is a single select list used to indicate the Status of the Task (i.e. In Progress). This table contains Type 1 data for the Task Status values defined in your VersionOne instance.

Table Description

Column Name Description DataType
TaskStatusKey Data Mart unique identifier for this value int
TaskStatusOid VersionOne identifier for this value int
TaskStatusName Name nvarchar
TaskStatusOrder The order this value appears in the VersionOne dropdown list int
TaskStatusAssertState State of the list value (Active or Closed) int
TaskStatusCreateDateUTC UTC Date the value was created datetime
TaskStatusLastModifiedDateUTC UTC Date the value was last modified datetime
TaskStatusCreatedByKey Data Mart identifier of the Member that created this value int
TaskStatusLastModifiedByKey Data Mart identifier of the Member that last modified this value int
TaskStatusCreateDateKey Foreign Key to Dim.Date for the Create Date int
TaskStatusLastModifiedDateKey Foreign Key to Dim.Date for the Last Modified Date int
  • Was this article helpful?