Table: SETIRAUCSURPLUS

SETIRAUCSURPLUS

Name

SETIRAUCSURPLUS

Comment

This view supports the Settlements Residue Auction, by holding the NSP participant allocations of IRSurplus arising as a result of the unsold units for a quarter.


Description

SETIRAUCSURPLUS data is confidential to the relevant participant.

Source

SETIRAUCSURPLUS updates with each settlement run.

Volume

SETIRAUCSURPLUS contains a maximum of 10 million records per year.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

CONTRACTID

FROMREGIONID

INTERCONNECTORID

PARTICIPANTID

PERIODID

SETTLEMENTDATE

SETTLEMENTRUNNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

Calendar Settlement Date

SETTLEMENTRUNNO

NUMBER(3,0)

X

Settlement run number

CONTRACTID

VARCHAR2(10)

X

SRA Contract unique identifier

PERIODID

NUMBER(3,0)

X

Settlements Trading Interval.

PARTICIPANTID

VARCHAR2(10)

X

Unique participant identifier

INTERCONNECTORID

VARCHAR2(10)

X

Contracted Interconnector identifier

FROMREGIONID

VARCHAR2(10)

X

Nominated source region for Interconnector

TOTALSURPLUS

NUMBER(15,5)

 

Total value of surplus before allocation

CONTRACTALLOCATION

NUMBER(8,5)

 

Percentage allocated to participant

SURPLUSVALUE

NUMBER(15,5)

 

Amount NSP is paid for Inter/intra-Regional surplus energy produced

LASTCHANGED

DATE

 

Date and time this record was last modified

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