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.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


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

RAISE6SEC_RECOVERY

NUMBER(18,8)

 

Recovery amount for the Raise 6 Second service attributable to customer connection points

LOWER60SEC_RECOVERY

NUMBER(18,8)

 

Recovery amount for the Lower 60 Second service attributable to customer connection points

RAISE60SEC_RECOVERY

NUMBER(18,8)

 

Recovery amount for the Raise 60 Second service attributable to customer connection points

LOWER5MIN_RECOVERY

NUMBER(18,8)

 

Recovery amount for the Lower 5 Minute service attributable to customer connection points

RAISE5MIN_RECOVERY

NUMBER(18,8)

 

Recovery amount for the Raise 5 Minute service attributable to customer connection points

LOWERREG_RECOVERY

NUMBER(18,8)

 

Recovery amount for the Lower Regulation service attributable to customer connection points

RAISEREG_RECOVERY

NUMBER(18,8)

 

Recovery amount for the Raise Regulation Second service attributable to customer connection points

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

RAISE6SEC_RECOVERY_GEN

NUMBER(18,8)

 

Recovery amount for the Raise 6 Second service attributable to generator connection points

LOWER60SEC_RECOVERY_GEN

NUMBER(18,8)

 

Recovery amount for the Lower 60 Second service attributable to generator connection points

RAISE60SEC_RECOVERY_GEN

NUMBER(18,8)

 

Recovery amount for the Raise 60 Second service attributable to generator connection points

LOWER5MIN_RECOVERY_GEN

NUMBER(18,8)

 

Recovery amount for the Lower 5 Minute service attributable to generator connection points

RAISE5MIN_RECOVERY_GEN

NUMBER(18,8)

 

Recovery amount for the Raise 5 Minute service attributable to generator connection points

LOWERREG_RECOVERY_GEN

NUMBER(18,8)

 

Recovery amount for the Lower Regulation service attributable to generator connection points

RAISEREG_RECOVERY_GEN

NUMBER(18,8)

 

Recovery amount for the Raise Regulation Second service attributable to generator connection points