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 |