| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Settlement Date |
| VERSIONNO |
varchar(3) |
varchar(3) |
Settlement Run No |
| PARTICIPANTID |
varchar(10) |
varchar(10) |
Participant identifier |
| REGIONID |
varchar(10) |
varchar(10) |
Region Identifier |
| PERIODID |
numeric(3, 0) |
smallint |
Settlements Trading Interval. |
| LOWER6SEC_RECOVERY |
numeric(18, 8) |
numeric(18, 8) |
Recovery amount for the Lower 6 Second service attributable to customer connection points. NULL for Settlement date post the IESS rule effective date |
| RAISE6SEC_RECOVERY |
numeric(18, 8) |
numeric(18, 8) |
Recovery amount for the Raise 6 Second service attributable to customer connection points. NULL for Settlement dates post the IESS rule effective date |
| LOWER60SEC_RECOVERY |
numeric(18, 8) |
numeric(18, 8) |
Recovery amount for the Lower 60 Second service attributable to customer connection points. NULL for Settlement dates post the IESS rule effective date |
| RAISE60SEC_RECOVERY |
numeric(18, 8) |
numeric(18, 8) |
Recovery amount for the Raise 60 Second service attributable to customer connection points. NULL for Settlement dates post the IESS rule effective date |
| LOWER5MIN_RECOVERY |
numeric(18, 8) |
numeric(18, 8) |
Recovery amount for the Lower 5 Minute service attributable to customer connection points. NULL for Settlement dates post the IESS rule effective date |
| RAISE5MIN_RECOVERY |
numeric(18, 8) |
numeric(18, 8) |
Recovery amount for the Raise 5 Minute service attributable to customer connection points. NULL for Settlement dates post the IESS rule effective date |
| LOWERREG_RECOVERY |
numeric(18, 8) |
numeric(18, 8) |
For Settlement Date post the IESS rule effective date the column represent the Lower Regulation FCAS MPF Recovery Amount from Customer and Generator Connection Point MPFs only. Residue Recovery Amount is not included in this amount. For Settlement Dates past FPP Rule Effective Dates this column will be NULL. |
| RAISEREG_RECOVERY |
numeric(18, 8) |
numeric(18, 8) |
For Settlement Date post the IESS rule effective date the column represent the Raise Regulation FCAS MPF Recovery Amount from Customer and Generator Connection Point MPFs only. Residue Recovery Amount is not included in this amount. For Settlement Dates past FPP Rule Effective Dates this column will be NULL. |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| LOWER6SEC_RECOVERY_GEN |
numeric(18, 8) |
numeric(18, 8) |
Recovery amount for the Lower 6 Second service attributable to generator connection points. NULL for Settlement dates post the IESS rule effective date |
| RAISE6SEC_RECOVERY_GEN |
numeric(18, 8) |
numeric(18, 8) |
Recovery amount for the Raise 6 Second service attributable to generator connection points. NULL for Settlement dates post the IESS rule effective date |
| LOWER60SEC_RECOVERY_GEN |
numeric(18, 8) |
numeric(18, 8) |
Recovery amount for the Lower 60 Second service attributable to generator connection points. NULL for Settlement dates post the IESS rule effective date |
| RAISE60SEC_RECOVERY_GEN |
numeric(18, 8) |
numeric(18, 8) |
Recovery amount for the Raise 60 Second service attributable to generator connection points. NULL for Settlement dates post the IESS rule effective date |
| LOWER5MIN_RECOVERY_GEN |
numeric(18, 8) |
numeric(18, 8) |
Recovery amount for the Lower 5 Minute service attributable to generator connection points. NULL for Settlement dates post the IESS rule effective date |
| RAISE5MIN_RECOVERY_GEN |
numeric(18, 8) |
numeric(18, 8) |
Recovery amount for the Raise 5 Minute service attributable to generator connection points. NULL for Settlement dates post the IESS rule effective date |
| LOWERREG_RECOVERY_GEN |
numeric(18, 8) |
numeric(18, 8) |
For Settlement date prior to the IESS rule effective date, the column represent Sum of MPF Lower Regulation recovery amount from Generator Connection Points. NULL for Settlement dates post the IESS rule effective date. |
| RAISEREG_RECOVERY_GEN |
numeric(18, 8) |
numeric(18, 8) |
For Settlement date prior to the IESS rule effective date, the column represent Sum of MPF Raise Regulation recovery amount from Generator Connection Points. NULL for Settlement dates post the IESS rule effective date. |
| LOWER1SEC_RECOVERY |
numeric(18, 8) |
numeric(18, 8) |
Customer recovery amount for the very fast lower service. NULL for Settlement dates post the IESS rule effective date |
| LOWER1SEC_RECOVERY_GEN |
numeric(18, 8) |
numeric(18, 8) |
Generator recovery amount for the very fast lower service. NULL for Settlement dates post the IESS rule effective date |
| RAISE1SEC_RECOVERY |
numeric(18, 8) |
numeric(18, 8) |
Customer recovery amount for the very fast raise service. NULL for Settlement dates post the IESS rule effective date |
| RAISE1SEC_RECOVERY_GEN |
numeric(18, 8) |
numeric(18, 8) |
Generator recovery amount for the very fast raise service. NULL for Settlement dates post the IESS rule effective date |
| LOWER1SEC_ACE |
numeric(18, 8) |
numeric(18, 8) |
The Lower1Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
| LOWER1SEC_ASOE |
numeric(18, 8) |
numeric(18, 8) |
The Lower1Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
| LOWER5MIN_ACE |
numeric(18, 8) |
numeric(18, 8) |
The Lower5Min FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
| LOWER5MIN_ASOE |
numeric(18, 8) |
numeric(18, 8) |
The Lower5Min FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
| LOWER60SEC_ACE |
numeric(18, 8) |
numeric(18, 8) |
The Lower60Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
| LOWER60SEC_ASOE |
numeric(18, 8) |
numeric(18, 8) |
The Lower60Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
| LOWER6SEC_ACE |
numeric(18, 8) |
numeric(18, 8) |
The Lower6Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
| LOWER6SEC_ASOE |
numeric(18, 8) |
numeric(18, 8) |
The Lower6Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
| LOWERREG_ACE |
numeric(18, 8) |
numeric(18, 8) |
The Lower Regulation FCAS Residue Recovery Amount using ACE MWh values excluding the MPF Connection Points. NULL value for Settlement Dates prior to the IESS rule effective date. For Settlement dates past FPP Rule Effective date this column will be LOWERREG_USED_ACE + LOWERREG_UNUSED_ACE |
| RAISE1SEC_ACE |
numeric(18, 8) |
numeric(18, 8) |
The Raise1Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
| RAISE1SEC_ASOE |
numeric(18, 8) |
numeric(18, 8) |
The Raise1Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
| RAISE5MIN_ACE |
numeric(18, 8) |
numeric(18, 8) |
The Raise5Min FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
| RAISE5MIN_ASOE |
numeric(18, 8) |
numeric(18, 8) |
The Raise5Min FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
| RAISE60SEC_ACE |
numeric(18, 8) |
numeric(18, 8) |
The Raise60Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
| RAISE60SEC_ASOE |
numeric(18, 8) |
numeric(18, 8) |
The Raise60Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
| RAISE6SEC_ACE |
numeric(18, 8) |
numeric(18, 8) |
The Raise6Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
| RAISE6SEC_ASOE |
numeric(18, 8) |
numeric(18, 8) |
The Raise6Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
| RAISEREG_ACE |
numeric(18, 8) |
numeric(18, 8) |
The Raise Regulation FCAS Residue Recovery Amount using ACE MWh values excluding the MPF Connection Points. NULL Value for Settlement Dates prior to the IESS rule effective date. For Settlement dates past FPP Rule Effective date this column will be RAISEREG_USED_ACE + RAISEREG_UNUSED_ACE |
| LOWERREG_ASOE |
numeric(18, 8) |
numeric(18, 8) |
This column is LOWERREG_USED_ASOE + LOWERREG_UNUSED_ASOE. For Settlement dates prior to FPP Rule Effective date this column will be NULL |
| RAISEREG_ASOE |
numeric(18, 8) |
numeric(18, 8) |
This column is RAISEREG_USED_ASOE + RAISEREG_UNUSED_ASOE. For Settlement dates prior to FPP Rule Effective date this column will be NULL |
| LOWERREG_USED |
numeric(18, 8) |
numeric(18, 8) |
The LowerReg Used amount for the Participant and Region |
| RAISEREG_USED |
numeric(18, 8) |
numeric(18, 8) |
The RaiseReg Used amount for the Participant and Region |
| LOWERREG_UNUSED |
numeric(18, 8) |
numeric(18, 8) |
The LowerReg Unused amount for the Participant and Region |
| RAISEREG_UNUSED |
numeric(18, 8) |
numeric(18, 8) |
The RaiseReg Unused amount for the Participant and Region |
| LOWERREG_USED_ACE |
numeric(18, 8) |
numeric(18, 8) |
The LowerReg Used ACE Portion amount for the Participant and Region |
| LOWERREG_USED_ASOE |
numeric(18, 8) |
numeric(18, 8) |
The LowerReg Used ASOE Portion amount for the Participant and Region |
| LOWERREG_USED_RESIDUAL |
numeric(18, 8) |
numeric(18, 8) |
The LowerReg Used Residual amount for the Participant and Region(LowerReg_Used_ACE + LowerReg_Used_ASOE) |
| RAISEREG_USED_ACE |
numeric(18, 8) |
numeric(18, 8) |
The RaiseReg Used ACE Portion amount for the Participant and Region |
| RAISEREG_USED_ASOE |
numeric(18, 8) |
numeric(18, 8) |
The RaiseReg Used ASOE Portion amount for the Participant and Region |
| RAISEREG_USED_RESIDUAL |
numeric(18, 8) |
numeric(18, 8) |
The RaiseReg Used Residual amount for the Participant and Region RaiseReg_Used_ACE + RaiseReg_Used_ASOE |
| LOWERREG_UNUSED_ACE |
numeric(18, 8) |
numeric(18, 8) |
The LowerReg Unused ACE Portion amount for the Participant and Region |
| LOWERREG_UNUSED_ASOE |
numeric(18, 8) |
numeric(18, 8) |
The LowerReg Unused ASOE Portion amount for the Participant and Region |
| LOWERREG_UNUSED_RESIDUAL |
numeric(18, 8) |
numeric(18, 8) |
The LowerReg Unused Residual amount for the Participant and Region LowerReg_Unused_ACE + LowerReg_Unused_ASOE |
| RAISEREG_UNUSED_ACE |
numeric(18, 8) |
numeric(18, 8) |
The RaiseReg Unused ACE Portion amount for the Participant and Region |
| RAISEREG_UNUSED_ASOE |
numeric(18, 8) |
numeric(18, 8) |
The RaiseReg Unused ASOE Portion amount for the Participant and Region |
| RAISEREG_UNUSED_RESIDUAL |
numeric(18, 8) |
numeric(18, 8) |
The RaiseReg Unused Residual amount for the Participant and Region RaiseReg_Unused_ACE + RaiseReg_Unused_ASOE |