Skip to main content
System StatusContact Support
VersionOne Community

Dim.PrimaryWorkitem

This feature is available in Enterprise and Ultimate editions.

Primary Workitem is a generic term used when referring to Stories, Defects, and TestSets. This table contains Type 1 data for Primary 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
PrimaryWorkitemKey Datamart unique identifier for this Primary Workitem int
PrimaryWorkitemOid VersionOne identifier for this Primary Workitem int
PrimaryWorkitemName Primary Workitem name nvarchar
PrimaryWorkitemDisplayId Primary Workitem identifier visible in VersionOne grids varchar
PrimaryWorkitemType Type of Primary Workitem (Story or Defect) varchar
PrimaryWorkitemPlannedEstimate Planned Estimate value for this Primary Workitem real
PrimaryWorkitemReference Reference value for this Primary Workitem nvarchar
PrimaryWorkitemRequestedBy Requested By value for this Primary Workitem nvarchar
PrimaryWorkitemBuild Build value when Primary Workitem is a Story nvarchar
PrimaryWorkitemEnvironment Environment value when this Primary Workitem is a Defect nvarchar
PrimaryWorkitemFoundInBuild Found in Build value when Primary Workitem is a Defect nvarchar
PrimaryWorkitemFoundInVersion Found in Version value when Primary Workitem is a Defect nvarchar
PrimaryWorkitemFoundBy Found By value when Primary Workitem is a Defect nvarchar
PrimaryWorkitemResolvedInBuild Resolved in Build value when Primary Workitem is a Defect nvarchar
PrimaryWorkitemSplitFromKey Foreign Key to this table for the Primary Workitem this workitem was split from int
PrimaryWorkitemSplitFromDisplayID Display ID of the Primary Workitem that was split to create this Primary Workitem varchar
PrimaryWorkitemSplitFromName Name of the Primary Workitem that was split to create this Primary Workitem nvarchar
PrimaryWorkitemAssetState Primary Workitem Asset State varchar
PrimaryWorkitemOrder Primary Workitem Order in a list int
PrimaryWorkitemTeamName Name of the Team assigned to this Primary Workitem nvarchar
PrimaryWorkitemThemeName Name of the Theme for this Primary Workitem nvarchar
PrimaryWorkitemSourceName Source value for this Primary Workitem nvarchar
PrimaryWorkitemPriorityName Priority value for this Primary Workitem nvarchar
PrimaryWorkitemStatusName Status value for this Primary Workitem nvarchar
PrimaryWorkitemIterationName Name of the Iteration for this Primary Workitem nvarchar
PrimaryWorkitemProjectName Name of the Project containing this Primary Workitem nvarchar
PrimaryWorkitemCustomerName Name of the Custom Field for this Primary Workitem nvarchar
PrimaryWorkitemRiskName Risk/Complexity value for this Primary Workitem nvarchar
PrimaryWorkitemEpicName Name of the Epic if this Primary Workitem is part of an Epic nvarchar
PrimaryWorkitemDefectTypeName Type value when the Primary Workitem is a Defect nvarchar
PrimaryWorkitemStoryTypeName Type value when the Primary Workitem is a Story nvarchar
PrimaryWorkitemVerifiedByName Verified By value when the Primary Workitem is a Defect nvarchar
PrimaryWorkitemResolutionName Resolution value when the Primary Workitem is a Defect nvarchar
PrimaryWorkitemRegressionSuiteName Regression Suite value when the Primary Workitem is a TestSet nvarchar
PrimaryWorkitemEnvironmentName Environment value when the Primary Workitem is a TestSet nvarchar
PrimaryWorkitemClassOfService Class Of Service value for this Primary Workitem nvarchar
PrimaryWorkitemDoneDate Complete Date in the UI.  This is the first date the Primary Workitem last (most recently) entered a Status value that is assigned to the Completed Reporting Category.  If you have multiple status values assigned to the Completed Reporting Category, this date is not updated as the Primary Workitem is moved from Status to Status, it is only set once. datetime
PrimaryWorkitemDoneDateKey Foreign Key to Dim.Date for the Primary Workitem Done Date int
PrimaryWorkitemClosedDateUTC The UTC date and time this Primary Workitem was Closed / Archived datetime
PrimaryWorkitemClosedDateKey Foreign Key to Dim.Date for the Closed Date int
PrimaryWorkitemClosedByID Foreign Key the the Dim.Member that closed this Primary Workitem int
PrimaryWorkitemClosedByName The name of the Member that closed this Primary Worktem nvarchar
PrimaryWorkitemEstimate Estimate value for this Primary Workitem Real
PrimaryWorkitemCreatedByName Full Name of the Member who created this PrimaryWorkitem nvarchar
PrimaryWorkitemLastModifiedByName Full Name of the Member who last modified this PrimaryWorkitem nvarchar
PrimaryWorkitemCreateDateUTC UTC Date the Primary Workitem was created datetime
PrimaryWorkitemLastModifiedDateUTC UTC Date the Primary Workitem was last modified datetime
PrimaryWorkitemCreatedByKey Foreign Key the the Member who created this PrimaryWorkitem int
PrimaryWorkitemLastModifiedByKey Foreign Key the the Member who last modified this PrimaryWorkitem int
PrimaryWorkitemCreateDateKey Foreign Key to Dim.Date for the Create Date int
PrimaryWorkitemLastModifiedDateKey Foreign Key to Dim.Date for the Last Modified Date int
  • Was this article helpful?