Skip to main content
System StatusContact Support
VersionOne Community

Dim.TaskSource

This feature is available in Enterprise and Ultimate editions.

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

Table Description

Column Name Description DataType
TaskSourceKey Data Mart unique identifier for this value int
TaskSourceOid VersionOne identifier for this value int
TaskSourceName Name nvarchar
TaskSourceOrder The order this value appears in the VersionOne dropdown list int
TaskSourceAssetState State of the list value (Active or Closed) varchar
TaskSourceCreateDateUTC UTC Date the value was created datetime
TaskSourceLastModifiedDateUTC UTC Date the value was last modified datetime
TaskSourceCreatedByKey Data Mart identifier of the Member that created this value int
TaskSourceLastModifiedByKey Data Mart identifier of the Member that last modified this value int
TaskSourceCreateDateKey Foreign Key to Dim.Date for the Create Date int
TaskSourceLastModifiedDateKey Foreign Key to Dim.Date for the Last Modified Date int
  • Was this article helpful?