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 |