| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Settlement date |
| SETTLEMENTRUNNO |
numeric(3, 0) |
smallint |
Settlement run number |
| PARTICIPANTID |
varchar(20) |
varchar(20) |
Unique identifier for the participant |
| REGIONID |
varchar(20) |
varchar(20) |
Unique Identifier for the Region to which the TNI belongs on this settlement date |
| PERIODID |
numeric(3, 0) |
smallint |
Trading interval identifier, with Period 1 being the first TI for the calendar day, i.e interval ending 00:05 for 5MS or 00:30 for 30MS. |
| CUSTOMERENERGYACTUAL |
numeric(18, 8) |
numeric(18, 8) |
Actual Customer Demand. NULL for Settlement dates post the IESS rule effective date. |
| CUSTOMERENERGYMPFEXACTUAL |
numeric(18, 8) |
numeric(18, 8) |
Actual Customer Demand excluding TNIs that have a causer pays MPF. NULL for Settlement dates post the IESS rule effective date. |
| CUSTOMERENERGYSUBSTITUTE |
numeric(18, 8) |
numeric(18, 8) |
Substitute Customer Demand. NULL for Settlement dates post the IESS rule effective date. |
| CUSTOMERENERGYMPFEXSUBSTITUTE |
numeric(18, 8) |
numeric(18, 8) |
Substitute Customer Demand excluding TNIs that have a causer pays MPF. NULL for Settlement dates post the IESS rule effective date. |
| GENERATORENERGYACTUAL |
numeric(18, 8) |
numeric(18, 8) |
Actual Generator Output. NULL for Settlement dates post the IESS rule effective date. |
| REGIONCUSTENERGYACTUAL |
numeric(18, 8) |
numeric(18, 8) |
Region Total of Actual Customer Demand. NULL for Settlement dates post the IESS rule effective date. |
| REGIONCUSTENERGYMPFEXACTUAL |
numeric(18, 8) |
numeric(18, 8) |
Region Total of Actual Customer Demand excluding TNIs that have a causer pays MPF. NULL for Settlement dates post the IESS rule effective date. |
| REGIONCUSTENERGYSUBST |
numeric(18, 8) |
numeric(18, 8) |
Region Total of Substitute Customer Demand. NULL for Settlement dates post the IESS rule effective date. |
| REGIONCUSTENERGYMPFEXSUBST |
numeric(18, 8) |
numeric(18, 8) |
Region total of Substitute Customer Demand excluding TNIs that have a causer pays MPF. NULL for Settlement dates post the IESS rule effective date. |
| REGIONGENENERGYACTUAL |
numeric(18, 8) |
numeric(18, 8) |
Region Total of Actual Generator Output. NULL for Settlement dates post the IESS rule effective date. |
| ACE_MWH_ACTUAL |
numeric(18, 8) |
numeric(18, 8) |
Actual ACE MWh Value for the Recovery Calculation. NULL Value for Settlement date prior to the IESS rule effective date |
| ACE_MWH_MPFEX_ACTUAL |
numeric(18, 8) |
numeric(18, 8) |
The Actual ACE MWh Value excluding the MPF Connection Points for the Recovery Calculation. This is used only in FCAS Residue Recovery Calculation. NULL Value for Settlement date prior to the IESS rule effective date. |
| ACE_MWH_MPFEX_SUBSTITUTE |
numeric(18, 8) |
numeric(18, 8) |
The Substitute ACE MWh Value excluding the MPF Connection Points for the Recovery Calculation. This is used only in FCAS Residue Recovery Calculation. There is no substitute demand post IESS Rule Change. Hence this column will have same value as ACE_MWh_MPFExActual. NULL Value for Settlement date prior to the IESS rule effective date. |
| ACE_MWH_SUBSTITUTE |
numeric(18, 8) |
numeric(18, 8) |
The Substitute ACE MWh Value for the Recovery Calculation. There is no substitute demand post IESS Rule Change. Hence this column will have same value as ACE_MWh_Actual. NULL Value for Settlement date prior to the IESS rule effective date. |
| ASOE_MWH_ACTUAL |
numeric(18, 8) |
numeric(18, 8) |
The Actual ASOE MWh Value for the Recovery Calculation. NULL Value for Settlement date prior to the IESS rule effective date. |
| REGION_ACE_MWH_ACTUAL |
numeric(18, 8) |
numeric(18, 8) |
The Region total of Actual ACE MWh Value. NULL Value for Settlement date prior to the IESS rule effective date. |
| REGION_ACE_MWH_MPFEX_ACTUAL |
numeric(18, 8) |
numeric(18, 8) |
The Region total of Actual ACE MWh Value excluding the MPF Connection Points. NULL Value for Settlement date prior to the IESS rule effective date. |
| REGION_ACE_MWH_MPFEX_SUBST |
numeric(18, 8) |
numeric(18, 8) |
The Region total of Substitute ACE MWh Value excluding the MPF Connection Points . NULL Value for Settlement date prior to the IESS rule effective date. |
| REGION_ACE_MWH_SUBST |
numeric(18, 8) |
numeric(18, 8) |
The Region total of Substitute ACE MWh Value. NULL Value for Settlement date prior to the IESS rule effective date. |
| REGION_ASOE_MWH_ACTUAL |
numeric(18, 8) |
numeric(18, 8) |
The Region total of Actual ASOE MWh Value. NULL Value for Settlement date prior to the IESS rule effective date. |