Dim.RegressionPlan

Regression Plans represent a coordinated set of testing activity focused on ensuring existing functionality still works properly. A regression plan contains multiple regression suites. This table contains Type 1 data for the Regression Plans defined in your instance.

Table Description

Column Name	Description	DataType
RegressionPlanKey	Datamart unique identifier for the Regression Plan	int
RegressionPlanOid	VersionOne identifier for this Regression Plan	int
RegressionPlanName	Regression Plan Name	nvarchar
RegressionPlanDisplayId	Regression Plan Identifier visible in VersionOne grids	varchar
RegressionPlanProjectName	Name of Project where the Regression Plan is defined	nvarchar
RegressionPlanOwnerName	Full Name of the member who owns the project	nvarchar
RegressionPlanOwnerShortName	Short Name of the member who owns the project	nvarchar
RegressionPlanOwnerUserName	Username of the member that owns the project	nvarchar
RegressionPlanReference	Reference field value on the Regression Plan	nvarchar
RegressionPlanProjectKey	Foreign Key to the Project where the Regression Plan is defined	int
RegressionPlanOwnerKey	Foreign Key to the Regression Plan Owner	int
RegressionPlanAssetState	AssetState of the Regression Plan	varchar
RegressionPlanCreatedByName	Full Name of the member who created this Regression Plan	nvarchar
RegressionPlanLastModifiedByName	Full Name of the member who last modified this Regression Plan	nvarchar
RegressionPlanCreateDateUTC	UTC Date the Regression Plan was created	datetime
RegressionPlanLastModifiedDateUTC	UTC Date the Regression Plan was last modified	datetime
RegressionPlanCreatedByKey	Foreign Key to the Dim.Member who created this Regression Plan	int
RegressionPlanLastModifiedByKey	Foreign Key to the Dim.Member who last modified this Regression Plan	int
RegressionPlanCreateDateKey	Foreign Key to Dim.Date for the Create Date	int
RegressionPlanLastModifiedDateKey	Foreign Key to Dim.Date for the Last Modified Date	int