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 |