Fact.EpicDaysIn
The Fact.EpicDaysIn table contain information about how many days an Epic was in a given status value. Each row in the table represents a single Epic in a single status value. The DateKey is always set the the maximum date value from Fact.Epic. It is important to note that oscillation between status values is not reflected in this table. Therefore, the "DaysInStatus" value may be greater than the value determined when you subtract FirstDateInStatus from LastDateInStatus.
Table Description
The following table describes the columns available in the default table.
| Column Name | Description | Datatype | Foreign Key To |
|---|---|---|---|
| DateKey | Maximum Date in Fact.Epic | int | Dim.Date |
| EpicKey | Data Mart identifier for the Epic | int | Dim.Epic |
| EpicStatusKey | Data Mart identifier for the Epic Status value | int | Dim.EpicStatus |
| DaysInStatus | The number of days that this Epic has been in this status value | int | |
| FirstDateInStatus | The first date this Epic was seen in this status value | datetime | |
| LastDateInStatus | The last date this Epic was seen in this status value | datetime |