Dim.EpicStatus
All Epics in Agility have an attribute called Status. This is a single select list used to indicate the Epic's Status (i.e. Define, Breakdown, Build, Test, Deploy). This table contains Type 1 data for the Epic Status values defined in your instance.
Table Description
| Column Name | Description | DataType |
|---|---|---|
| EpicStatusKey | Datamart unique identifier for this value | int |
| EpicStatusOid | VersionOne unique identifier for this value | int |
| EpicStatusName | Name | nvarchar |
| EpicStatusOrder | The order this value appears in the VersionOne drop-down list | int |
| EpicStatusAssetState | State of the list value (Active or Closed) | varchar |
| EpicStatusCreateDateUTC | UTC Date the value was created | datetime |
| EpicStatusLastModifiedDateUTC | UTC Date the value was last modified | datetime |
| EpicStatusCreatedByKey | Data Mart identifier of the Member that created this value | int |
| EpicStatusLastModifiedByKey | Data Mart identifier of the Member that last modified this value | int |
| EpicStatusCreateDateKey | Foreign Key to Dim.Date for the Create Date | int |
| EpicStatusLastModifiedDateKey | Foreign Key to Dim.Date for the Last Modified Date | int |