Table: SETFCASREGIONRECOVERY

SETFCASREGIONRECOVERY

Name

SETFCASREGIONRECOVERY

Comment

The FCAS Recovery amount from each NEM Region and the Energy MWh used for the FCAS Recovery calculation from Participants


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. NULL for Settlement dates post the IESS rule effective date

CUSTOMERREGIONENERGY

NUMBER(16,6)

 

Customer Region Energy Amount. NULL for Settlement dates post the IESS rule effective date

REGIONRECOVERY

NUMBER(18,8)

 

The NEM Regional Recovery Amount for FCAS

LASTCHANGED

DATE

 

Last Date record changed

REGION_ACE_MWH

NUMBER(18,8)

 

The Regional ACE MWh value used for the FCAS Recovery. NULL for Settlement dates prior to the IESS rule effective date

REGION_ASOE_MWH

NUMBER(18,8)

 

The Regional ASOE MWh value used for the FCAS Recovery. NULL for Settlement dates prior to the IESS rule effective date

REGIONRECOVERYAMOUNT_ACE

NUMBER(18,8)

 

The Total Dollar Amount for the Region recovered using the ACE MWh Values. NULL for Settlement dates prior to the IESS rule effective date

REGIONRECOVERYAMOUNT_ASOE

NUMBER(18,8)

 

The Total Dollar Amount for the Region recovered using the ASOE MWh Values. NULL for Settlement dates prior to the IESS rule effective date

REGIONRECOVERYAMOUNT

NUMBER(18,8)

 

The Total Dollar Amount for the Region (RegionRecoveryAmountACE + RegionRecoveryAmountASOE). NULL for Settlement dates prior to the IESS rule effective date