Skip to main content
System StatusContact Support
VersionOne Community

Dim.SecondaryWorkitem

This feature is available in Enterprise and Ultimate editions.

Secondary Workitem is a generic term used when referring to Task and Test. This table contains Type 1 data for Secondary Workitems defined in your VersionOne instance. It will also contain columns for Custom Dropdowns and Custom Booleans defined on these assets in VersionOne.

Table Description

Column Name Description Datatype
SecondaryWorkitemKey Datamart unique identifier for this Secondary Workitem int
SecondaryWorkitemOid VersionOne identifier for this Secondary Workitem int
SecondaryWorkitemName Name on Task or Test nvarchar
SecondaryWorkitemDisplayId Identifier visible in grid varchar
SecondaryWorkitemType Type of Secondary Workitem (Task or Test) varchar
SecondaryWorkitemAssetState Asset State varchar
SecondaryWorkitemProject Name of the project containing this Task or Test nvarchar
SecondaryWorkitemIterationName Name of the Iteration containing this Task or Test nvarchar
SecondaryWorkitemTeamName Name of the Team that owns this Task or Test nvarchar
SecondaryWorkitemWorkitemName Name of the Primary Workitem Parent for this Task or Test nvarchar
SecondaryWorkitemWorkitemDisplayId Display Id of the Primary Workitem Parent for this Task or Test varchar
SecondaryWorkitemReference Reference value for this Task or Test nvarchar
SecondaryWorkitemTaskStatus Status value for when Secondary Workitem is a Task nvarchar
SecondaryWorkitemTaskType Type value for when Secondary Workitem is a Task nvarchar
SecondaryWorkitemTaskSource Source value for when Secondary Workitem is a Task nvarchar
SecondaryWorkitemTaskBuild Build value for when Secondary Workitem is a Task nvarchar
SecondaryWorkitemTestStatus Status value for when Secondary Workitem is a Test nvarchar
SecondaryWorkitemTestType Type value for when Secondary Workitem is a Test nvarchar
SecondaryWorkitemTestGeneratedFromName Name of Regression Test used to generate this Test nvarchar
SecondaryWorkitemTestGeneratedFromDisplayId Display Id of Regression Test used to generate this Test varchar
SecondaryWorkitemOrder Order of this Secondary Workitem in a list int
SecondaryWorkitemDetailEstimate Detail Estimate value for this Secondary Workitem real
SecondaryWorkitemToDo Current ToDo value for this Secondary Workitem real
SecondaryWorkitemCreatedByName Full Name of the Member who created this SecondaryLastWorkitem nvarchar
SecondaryWorkitemLastModifiedByName Full Name of the Member who last modified this SecondaryLastWorkitem nvarchar
SecondaryWorkitemClosedDateUTC The UTC date and time this Secondary Workitem was Closed / Archived datetime
SecondaryWorkitemClosedDateKey Foreign Key to Dim.Date for the Closed Date int
SecondaryWorkitemClosedByID Foreign Key the the Dim.Member that closed this Secondary Workitem int
SecondaryWorkitemClosedByName The name of the Member that closed this Secondary Worktem nvarchar
SecondaryWorkitemCreateDateUTC UTC Date the Secondary Workitem was created datetime
SecondaryWorkitemLastModifiedDateUTC UTC Date the Secondary Workitem was last modified datetime
SecondaryWorkitemCreatedByKey Foreign Key to the Member who created this SecondaryLastWorkitem int
SecondaryWorkitemLastModifiedByKey Foreign Key to the Member who last modified this SecondaryLastWorkitem int
SecondaryWorkitemCreateDateKey Foreign Key to Dim.Date for the Create Date int
SecondaryWorkitemLastModifiedDateKey Foreign Key to Dim.Date for the Last Modified Date int
  • Was this article helpful?