Table: SET_FCAS_RECOVERY

SET_FCAS_RECOVERY

Name

SET_FCAS_RECOVERY

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).


Description

SET_FCAS_RECOVERY data is confidential to the relevant participant.

Volume

Approximately 1, 500, 000 per week.


Primary Key Columns

Name

PARTICIPANTID

PERIODID

REGIONID

SETTLEMENTDATE

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

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.


Previous
Home
Next