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 |