Table: SETFCASREGIONRECOVERY

SETFCASREGIONRECOVERY

Name

SETFCASREGIONRECOVERY

Comment

SETFCASREGIONRECOVERY shows FCAS Regional Recovery Data against each Trading Interval.


Description

SETFCASREGIONRECOVERY contains public data and is available to all participants.

Source

SETFCASREGIONRECOVERY updates with each settlements run.

Volume

Approximately 10,000 rows per day


Primary Key Columns

Name

BIDTYPE

PERIODID

REGIONID

SETTLEMENTDATE

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

Settlement Date of trading interval

VERSIONNO

NUMBER(3,0)

X

Settlement run no

BIDTYPE

VARCHAR2(10)

X

FCAS Service Type

REGIONID

VARCHAR2(10)

X

RegionID

PERIODID

NUMBER(3,0)

X

Settlements Trading Interval.

GENERATORREGIONENERGY

NUMBER(16,6)

 

Generator Regional Energy Amount

CUSTOMERREGIONENERGY

NUMBER(16,6)

 

Customer Region Energy Amount

REGIONRECOVERY

NUMBER(18,8)

 

The NEM Regional Recovery Amount for FCAS

LASTCHANGED

DATE

 

Last Date record changed