Dim.Epic
Epics are large stories that have been decomposed into smaller stories. These smaller stories may be needed to define a portion that is small enough to fit in a single sprint or to allow different projects or teams to work on the same high level feature. This table contains Type 1 data for epics defined in your instance.
Table Description
| Column Name | Description | Datatype |
|---|---|---|
| EpicKey | Datamart unique identifier for this epic | int |
| EpicOid | VersionOne unique identifier for this epic | int |
| EpicName | Name | nvarchar |
| EpicDisplayId | VersionOne identifier seen in the grids | varchar |
| EpicProjectKey | Foreign key into Dim.Project for the project containing this epic | int |
| EpicProjectName | Name of the project containing this epic | nvarchar |
| EpicStatusName | Status value for this Epic | nvarchar |
| EpicPriorityName | Priority value for this Epic | nvarchar |
| EpicTypeName | Type value for this Epic | nvarchar |
| EpicSourceName | Source value for this Epic | nvarchar |
| EpicTeamName | Target Team value for this Epic | nvarchar |
| EpicReference | Reference value for this Epic | nvarchar |
| EpicRequestedBy | Requested By value for this Epic | nvarchar |
| EpicValue | Value field on the Epic | real |
| EpicSwag | Swag value on the Epic | real |
| EpicRisk | Risk value for this Epic | real |
| EpicParentKey | Foreign Key into this table to identify this epic's parent | int |
| EpicParentDisplayId | Display Id for the Epic Parent | varchar |
| EpicParentName | Name of the Epic parent | nvarchar |
| EpicAssetState | Indicate the epic's state (Open/Closed) | varchar |
| EpicOrder | Epic Order in a list | int |
| EpicPlannedStartDate | The Planned Start Date, or Begin Date, for this Epic | datetime |
| EpicPlannedEndDate | The Planned End Date for this Epic | datetime |
| EpicPath | Fully qualified path for this epic. Useful for sorting epics in a list | nvarchar |
| EpicDoneDate | Complete Date in the UI. Date the Epic first entered a Status value assigned to Complete Reporting Category | datetime |
| EpicDoneDateKey | Foreign Key to Dim.Date for the Epic Done Date | int |
| EpicClosedDateUTC | The UTC date and time this Epic was Closed/Archived | datetime |
| EpicClosedDateKey | Foreign Key to Dim.Date for the Closed Date | int |
| EpicClosedByID | Foreign Key the Dim.Member that closed this Epic | int |
| EpicClosedByName | The name of the Member that closed this Epic | nvarchar |
| EpicCreatedByName | Full Name of the member who created this Epic | nvarchar |
| EpicLastModifiedByName | Full Name of the member who last modified this Epic | nvarchar |
| EpicCreateDateUTC | Create date for epic UTC | datetime |
| EpicLastModifiedDateUTC | Modify date for epic UTC | datetime |
| EpicCreateByKey | Foreign Key the Dim.Member that created this Epic | int |
| EpicLastModifiedByKey | Foreign Key the Dim.Member that last modified this Epic | int |
| EpicCreateDateKey | Foreign Key to Dim.Date for the Create Date | int |
| EpicLastModifiedDateKey | Foreign Key to Dim.Date for the Last Modified Date | int |