Name |
|
Comment |
SET_FCAS_RECOVERY shows reimbursements for the Frequency Control Ancillary Services (FCAS) to be recovered from participants. Beware of potential confusion with the table SETFCASRECOVERY, which reports reimbursements for Frequency Control Ancillary Services Compensation (now unused). |
SET_FCAS_RECOVERY data is confidential to the relevant participant. Volume Approximately 1, 500, 000 per week. |
Name |
PARTICIPANTID |
PERIODID |
REGIONID |
SETTLEMENTDATE |
VERSIONNO |
Name |
LASTCHANGED |
Name |
Data Type |
Mandatory |
Comment |
SETTLEMENTDATE |
DATE |
X |
Settlement Date |
VERSIONNO |
VARCHAR2(3) |
X |
Settlement Run No |
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant identifier |
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
PERIODID |
NUMBER(3,0) |
X |
Settlements Trading Interval. |
LOWER6SEC_RECOVERY |
NUMBER(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 |
NUMBER(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 |
NUMBER(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 |
NUMBER(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 |
NUMBER(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 |
NUMBER(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 |
NUMBER(18,8) |
|
For a Settlement date prior to the IESS rule effective date, the column represent Sum of MPF Lower Regulation recovery amount from Customer Connection Points and the Residue Recovery amount from Customers excluding the MPF Connection Points. 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. |
RAISEREG_RECOVERY |
NUMBER(18,8) |
|
For a Settlement date prior to the IESS rule effective date, the column represent Sum of MPF Raise Regulation recovery amount from Customer Connection Points and the Residue Recovery amount from Customers excluding the MPF Connection Points. 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. |
LASTCHANGED |
DATE |
|
Last date and time record changed |
LOWER6SEC_RECOVERY_GEN |
NUMBER(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 |
NUMBER(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 |
NUMBER(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 |
NUMBER(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 |
NUMBER(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 |
NUMBER(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 |
NUMBER(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 |
NUMBER(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. |
RAISE1SEC_RECOVERY |
NUMBER(18,8) |
|
Customer recovery amount for the very fast raise service. NULL for Settlement dates post the IESS rule effective date |
LOWER1SEC_RECOVERY |
NUMBER(18,8) |
|
Customer recovery amount for the very fast lower service. NULL for Settlement dates post the IESS rule effective date |
RAISE1SEC_RECOVERY_GEN |
NUMBER(18,8) |
|
Generator recovery amount for the very fast raise service. NULL for Settlement dates post the IESS rule effective date |
LOWER1SEC_RECOVERY_GEN |
NUMBER(18,8) |
|
Generator recovery amount for the very fast lower service. NULL for Settlement dates post the IESS rule effective date |
LOWERREG_ACE |
NUMBER(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. |
RAISEREG_ACE |
NUMBER(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. |
RAISE1SEC_ACE |
NUMBER(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 |
NUMBER(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. |
LOWER1SEC_ACE |
NUMBER(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 |
NUMBER(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. |
RAISE6SEC_ACE |
NUMBER(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 |
NUMBER(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. |
LOWER6SEC_ACE |
NUMBER(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 |
NUMBER(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. |
RAISE60SEC_ACE |
NUMBER(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 |
NUMBER(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. |
LOWER60SEC_ACE |
NUMBER(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 |
NUMBER(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. |
RAISE5MIN_ACE |
NUMBER(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 |
NUMBER(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. |
LOWER5MIN_ACE |
NUMBER(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 |
NUMBER(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. |
|
|
|