Dim.EpicTest

This table contains Type 1 data for Test defined on Epics in your core application.

Table Description

Column Name	Description	Datatype
EpicTestKey	Datamart unique identifier	int
EpicTestOid	VersionOne value for the Epic Test	int
EpicTestName	Name	nvarchar
EpicTestDisplayId	VersionOne identifier seen in the grids	varchar
EpicTestAssetState	Indicates the state of this Epic Test (Open/Closed)	varchar
EpicTestProjectKey	Foreign Key to Dim.Project for the project containing this Epic Test	int
EpicTestProject	Name of the project containing this Epic Test	nvarchar
EpicTestEpicName	Name of the Epic that owns this test	nvarchar
EpicTestEpicDisplayId	VersionOne identifier for the Epic that owns this test	varchar
EpicTestStatus	Current Status Value	nvarchar
EpicTestType	Current Type Value	nvarchar
EpicTestReference	Current Reference Value	nvarchar
EpicTestCreateDateUTC	UTC Date that this Epic test was created	datetime
EpicTestLastModifiedUTC	UTC Date that this Epic test was last modified	datetime
EpicTestCreatedByKey	Foreign Key to Dim.Member for the person who created this Epic Test	int
EpicTestLastModifiedByKey	Foreign Key to Dim.Member for the person who last modified this Epic Test	int
EpicTestCreateDateKey	Foreign Key to Dim.Date for the Create Date	int
EpicTestLastModifiedDateKey	Foreign Key to Dim.Date for the Last Modified Date	int