Skip to main content
System StatusContact Support
VersionOne Community

Dim.Epic

This feature is available in Enterprise and Ultimate editions.

VersionOne 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 VersionOne 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
EpicPlannedStartDate    

The Planned End Date for this Epic.

This value is intended to be inclusive of the end date entered, therefore the value in this field is one more than the value presented on the VersionOne details page.

  • To filter on this value, use less than, not less than or equal to.
  • To view the data that is displayed on the Epic Details page, subtract 1 from this date.
datetime
EpicPath Fully qualified path for this epic. This is useful for sorting epics in a list nvarchar
EpicDoneDate Complete Date in the UI.  This is the date this Epic first entered a Status value that is assigned to the 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 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 the Dim.Member that created this Epic int
EpicLastModifiedByKey Foreign Key the 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
  • Was this article helpful?