Dim.RegressionTest
A Regression Test is a template for testing an existing feature on a repeated basis after it has been delivered to ensure new feature development has not broken the previous functionality. This table contains Type 1 data for the Regression Tests defined in your instance.
Table Description
| Column Name | Description | DataType |
|---|---|---|
| RegressionTestKey | Datamart unique identifier for the Regression Test | int |
| RegressionTestOid | Identifier for this Regression Test | int |
| RegressionTestName | Name of the Regression Test | nvarchar |
| RegressionTestDisplayId | Regression Test Identifier visible in grids | varchar |
| RegressionTestProjectName | Name of Project where the Regression Test is defined | nvarchar |
| RegressionTestTeamName | Name of the Team that owns this Regression Test | nvarchar |
| RegressionTestStatusName | Status value for the Regression Test | nvarchar |
| RegressionTestTypeName | Type value for the Regression Test | nvarchar |
| RegressionTestReference | Value of Reference field on Regression Test | nvarchar |
| RegressionTestProjectKey | Foreign Key to the Project where the Regression Test is defined | int |
| RegressionTestTeamKey | Foreign Key to the Team that owns the Regression Test | int |
| RegressionTestGeneratedFromTestKey | Foreign Key to Acceptance Test that was used to generate this Regression Test | int |
| RegressionTestGeneratedFromTestName | Name of Acceptance Test that was used to generate this Regression Test | nvarchar |
| RegressionTestGeneratedFromTestDisplayId | Display ID of Acceptance Test that was used to generate this Regression Test | varchar |
| RegressionTestAssetState | AssetState of the Regression Test | varchar |
| RegressionTestCreatedByName | Full Name of the member who created this Regression Test | nvarchar |
| RegressionTestLastModifiedByName | Full Name of the member who last modified this Regression Test | nvarchar |
| RegressionTestCreateDateUTC | UTC Date the Regression Test was created | datetime |
| RegressionTestLastModifiedDateUTC | UTC Date the Regression Test was last modified | datetime |
| RegressionTestCreateByKey | Foreign Key to the Dim.Member who created this Regression Test | int |
| RegressionTestLastModifiedByKey | Foreign Key to the Dim.Member who last modified this Regression Test | int |
| RegressionTestCreateDateKey | Foreign Key to Dim.Date for the Create Date | int |
| RegressionTestLastModifiedDateKey | Foreign Key to Dim.Date for the Last Modified Date | int |