Table: SETIRSURPLUS

SETIRSURPLUS

Name

SETIRSURPLUS

Comment

SETIRSURPLUS records the interregional residue calculation for each interconnector and each side of the interconnector.


Description

SETIRSURPLUS data is public, so is available to all participants.

Source

SETIRSURPLUS updates once a day at 8am.

Note

MWFLOW and LOSSFACTOR are now both calculated as MWh (energy) values for the half hour, and not MW (average demand) values. By way of clarification, the MWFLOW value is derived from half-hour revenue class metering, adjusted by a fixed fraction of the LOSSFACTOR value. The LOSSFACTOR value is taken to be exactly half of the MWLOSSES value in the TRADINGINTERCONNECT table.

The METEREDMWFLOW field in the TRADINGINTERCONNECT table contains averaged SCADA metering demand values available in “real time”, whereas the MWFLOW field in the SETIRSURPLUS table contains settlement energy metering values available only after a settlement run is posted.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

INTERCONNECTORID

PERIODID

REGIONID

SETTLEMENTDATE

SETTLEMENTRUNNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

Settlement date

SETTLEMENTRUNNO

NUMBER(3,0)

X

Settlement run number

PERIODID

NUMBER(3,0)

X

Trading interval

INTERCONNECTORID

VARCHAR2(10)

X

Interconnector

REGIONID

VARCHAR2(10)

X

Side of interconnector

MWFLOW

NUMBER(15,6)

 

Net flow at the regional node (MWh), including losses

LOSSFACTOR

NUMBER(15,5)

 

MW losses along interconnector NOTE: This is not a loss factor, but a loss figure expressed in MWH

SURPLUSVALUE

NUMBER(15,5)

 

Amount of surplus in $

LASTCHANGED

DATE

 

Last date and time record changed

CSP_DEROGATION_AMOUNT

NUMBER(18,8)

 

The CSP derogation amount applied as an adjustment to SRA

UNADJUSTED_IRSR

NUMBER(18,8)

 

The SRA amount unadjusted by CSP