Dim.PrimaryWorkitem

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 instance. It will also contain columns for Custom Drop-downs and Custom Booleans defined on these assets in .

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, set when the Primary Workitem enters a status assigned to the Completed Reporting Category. Updated only 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 to the Dim.Member that closed this Primary Workitem	int
PrimaryWorkitemClosedByName	The name of the Member that closed this Primary Workitem	nvarchar
PrimaryWorkitemEstimate	Estimate value for this Primary Workitem	real
PrimaryWorkitemCreatedByName	Full Name of the Member who created this Primary Workitem	nvarchar
PrimaryWorkitemLastModifiedByName	Full Name of the Member who last modified this Primary Workitem	nvarchar
PrimaryWorkitemCreateDateUTC	UTC Date the Primary Workitem was created	datetime
PrimaryWorkitemLastModifiedDateUTC	UTC Date the Primary Workitem was last modified	datetime
PrimaryWorkitemCreatedByKey	Foreign Key to the Member who created this Primary Workitem	int
PrimaryWorkitemLastModifiedByKey	Foreign Key to the Member who last modified this Primary Workitem	int
PrimaryWorkitemCreateDateKey	Foreign Key to Dim.Date for the Create Date	int
PrimaryWorkitemLastModifiedDateKey	Foreign Key to Dim.Date for the Last Modified Date	int