Dim.SecondaryWorkitem
Secondary Workitem is a generic term used when referring to Task and Test. This table contains Type 1 data for Secondary 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 |
|---|---|---|
| SecondaryWorkitemKey | Datamart unique identifier for this Secondary Workitem | int |
| SecondaryWorkitemOid | Identifier for this Secondary Workitem | int |
| SecondaryWorkitemName | Name on Task or Test | nvarchar |
| SecondaryWorkitemDisplayId | Identifier visible in grid | varchar |
| SecondaryWorkitemType | Type of Secondary Workitem (Task or Test) | varchar |
| SecondaryWorkitemAssetState | Asset State | varchar |
| SecondaryWorkitemProject | Name of the project containing this Task or Test | nvarchar |
| SecondaryWorkitemIterationName | Name of the Iteration containing this Task or Test | nvarchar |
| SecondaryWorkitemTeamName | Name of the Team that owns this Task or Test | nvarchar |
| SecondaryWorkitemWorkitemName | Name of the Primary Workitem Parent for this Task or Test | nvarchar |
| SecondaryWorkitemWorkitemDisplayId | Display Id of the Primary Workitem Parent for this Task or Test | varchar |
| SecondaryWorkitemReference | Reference value for this Task or Test | nvarchar |
| SecondaryWorkitemTaskStatus | Status value for when Secondary Workitem is a Task | nvarchar |
| SecondaryWorkitemTaskType | Type value for when Secondary Workitem is a Task | nvarchar |
| SecondaryWorkitemTaskSource | Source value for when Secondary Workitem is a Task | nvarchar |
| SecondaryWorkitemTaskBuild | Build value for when Secondary Workitem is a Task | nvarchar |
| SecondaryWorkitemTestStatus | Status value for when Secondary Workitem is a Test | nvarchar |
| SecondaryWorkitemTestType | Type value for when Secondary Workitem is a Test | nvarchar |
| SecondaryWorkitemTestGeneratedFromName | Name of Regression Test used to generate this Test | nvarchar |
| SecondaryWorkitemTestGeneratedFromDisplayId | Display Id of Regression Test used to generate this Test | varchar |
| SecondaryWorkitemOrder | Order of this Secondary Workitem in a list | int |
| SecondaryWorkitemDetailEstimate | Detail Estimate value for this Secondary Workitem | real |
| SecondaryWorkitemToDo | Current ToDo value for this Secondary Workitem | real |
| SecondaryWorkitemCreatedByName | Full Name of the Member who created this Secondary Workitem | nvarchar |
| SecondaryWorkitemLastModifiedByName | Full Name of the Member who last modified this Secondary Workitem | nvarchar |
| SecondaryWorkitemClosedDateUTC | The UTC date and time this Secondary Workitem was Closed / Archived | datetime |
| SecondaryWorkitemClosedDateKey | Foreign Key to Dim.Date for the Closed Date | int |
| SecondaryWorkitemClosedByID | Foreign Key to the Dim.Member that closed this Secondary Workitem | int |
| SecondaryWorkitemClosedByName | The name of the Member that closed this Secondary Workitem | nvarchar |
| SecondaryWorkitemCreateDateUTC | UTC Date the Secondary Workitem was created | datetime |
| SecondaryWorkitemLastModifiedDateUTC | UTC Date the Secondary Workitem was last modified | datetime |
| SecondaryWorkitemCreatedByKey | Foreign Key to the Member who created this Secondary Workitem | int |
| SecondaryWorkitemLastModifiedByKey | Foreign Key to the Member who last modified this Secondary Workitem | int |
| SecondaryWorkitemCreateDateKey | Foreign Key to Dim.Date for the Create Date | int |
| SecondaryWorkitemLastModifiedDateKey | Foreign Key to Dim.Date for the Last Modified Date | int |