Skip to main content
System StatusContact Support
VersionOne Community

Dim.WorkitemSource

This feature is available in Enterprise and Ultimate editions.

All Workitems in VersionOne have an attribute called Source. This is a single select list used to indicate the Workitems Source (i.e. Customer, Sales, Product Management). This table contains Type 1 data for the Workitem Source values defined in your VersionOne instance.

Table Description

Column Name Description DataType
WorkitemSourceKey Data Mart unique identifier for this value int
WorkitemSourceOid VersionOne identifier for this value int
WorkitemSourceName Name nvarchar
WorkitemSourceOrder The order this value appears in the VersionOne dropdown list nvarchar
WorkitemSourceAssetState State of the list value int
WorkitemSourceCreateDateUTC UTC Date the value was created datetime
WorkitemSourceLastModifiedDateUTC UTC Date the value was last modified datetime
WorkitemSourceCreatedByKey Data Mart identifier of the Member that created this value int
WorkitemSourceLastModifiedByKey Data Mart identifier of the Member that last modified this value int
WorkitemSourceCreateDateKey Foreign Key to Dim.Date for the Create Date int
WorkitemSourceLastModifiedDateKey Foreign Key to Dim.Date for the Last Modified Date int
  • Was this article helpful?