Skip to main content
System StatusContact Support
VersionOne Community

Fact.PrimaryWorkitem

This feature is available in Enterprise and Ultimate editions.

Overview

The Fact.PrimaryWorkitem table contain metrics available on Primary Workitems (Stories, Defects, and TestSets) in your VersionOne instance. Each row in the table represents a single Primary Workitem on a given day. All metrics in the table are semi-additive, meaning that are cumulative only for a given day.

The following metrics are available from this table

  • Estimate
  • Detail Estimate
  • ToDo
  • Done
  • Supported Custom Fields defined on Primary and Secondary Workitems

Estimate

Detail Estimate

ToDo

Done

  • The Done attribute on primary workitems.  This value represents the amount of Effort recorded against the primary workitem, regardless of of other attributes.  The value is correct, but not always historically accurate.  For more information, see the notes on Fact.Effort.
  • VersionOne Reports using this metric

Table Description

The following table describes the columns available in the default table.

Column Name Description Datatype Foreign Key To
DateKey Date of this measure int Dim.Date
WorkitemKey The PrimaryWorkitemKey for this measure int  
AssetTypeKey Data Mart identifier for the type of workitem int Dim.AssetType
PrimaryWorkitemKey Data Mart identifier for the Story or Defect int Dim.PrimaryWorkitem
SplitFromKey Data Mart identifier for the Primary Workitem this Workitem was split from int Dim.PrimaryWorkitem
ProjectKey Data Mart identifier for the Project containing this workitem int Dim.Project
IterationKey entifier for the Theme containing this workitemng this workitem int Dim.Iteration
ThemeKey Data Mart identifier for the Iteration containiData Mart id int Dim.Theme
TeamKey Data Mart identifier for the Team assigned to this workitem int Dim.Team
CustomerKey Data Mart identifier for the Member acting as Customer when the measure is related to a Story int Dim.Member
EpicKey Data Mart identifier for the Epic, when this measure is on a Story that is part of an Epic int Dim.Epic
WorkitemSourceKey Data Mart identifier for Source of this workitem int Dim.WorkitemSource
WorkitemPriorityKey Data Mart identifier for the Priority of this workitem int Dim.WorkitemPriority
WorkitemStatusKey Data Mart identifier for the Status of this workitem int Dim.WorkitemStatus
StoryRiskKey Data Mart identifier for Risk when the workitem is a Story int Dim.StoryRisk
StoryTypeKey Data Mart identifier for Type when the workitem is a Story int Dim.StoryType
DefectTypeKey Data Mart identifier for Type when the workitem is a Defect int Dim.DefectType
DefectResolutionKey Data Mart identifier for the Defect Resolution int Dim.DefectResolution
VerifiedByKey Data Mart identifier for the Member that verified the Defect int Dim.Member
RegressionSuiteKey Data Mart identifier for the Regression Suite int Dim.RegressionSuite
EnvironmentKey Data Mart identifier for the Environment int Dim.Environment
RegressionPlanKey Data Mart identifier for the Regression Plan int Dim.RegressionPlan
PrimaryAssetStateKey Data Mart identifier for the state this workitem int Dim.AssetState
ClassOfServiceKey Data Mart identifier for the Class Of Service int Dim.ClassOfService
Estimate Estimate Measure real  
DetailEstimate Detail Estimate Measure. (Note 1) real  
ToDo ToDo Measure. (Note 1) real  
Done Done Measure. (Note 1) real  

Note 1: This field is populated based on the Tracking Level settings in your VersionOne instance.

  • Was this article helpful?