Dim.EpicType
All Epics in have an attribute called Type. This is a single select list used to indicate the Epic's Type (i.e. Initiative, Feature, Sub-Feature, Non-Functional). This table contains Type 1 data for the Epic Type values defined in your instance.
Table Description
| Column Name | Description | Datatype |
|---|---|---|
| EpicTypeKey | Datamart unique identifier for this value | int |
| EpicTypeOid | VersionOne unique identifier for this value | int |
| EpicTypeName | Name | nvarchar |
| EpicTypeOrder | The order this value appears in the drop-down list | int |
| EpicTypeAssetState | State of the list value (Active or Closed) | varchar |
| EpicTypeCreateDateUTC | UTC Date the value was created | datetime |
| EpicTypeLastModifiedDateUTC | UTC Date the value was last modified | datetime |
| EpicTypeCreatedByKey | Data Mart identifier of the Member that created this value | int |
| EpicTypeLastModifiedByKey | Data Mart identifier of the Member that last modified this value | int |
| EpicTypeCreateDateKey | Foreign Key to Dim.Date for the Create Date | int |
| EpicTypeLastModifiedDateKey | Foreign Key to Dim.Date for the Last Modified Date | int |