Table: SETIRNSPSURPLUS

SETIRNSPSURPLUS

Name

SETIRNSPSURPLUS

Comment

This view supports the Settlements Residue Auction, by showing the TNSP participant allocations of Interconnector Residue (IR) Surplus (i.e. derogated amounts) arising as a result of the sold units for a quarter.


Description

SETIRNSPSURPLUS data is confidential to the relevant participant.

Source

SETIRNSPSURPLUS updates with each settlement run.

Volume

SETIRNSPSURPLUS 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

Settlement date

SETTLEMENTRUNNO

NUMBER(3,0)

X

Settlement run number

CONTRACTID

VARCHAR2(10)

X

SRA Contract unique identifier

PERIODID

NUMBER(2,0)

X

Settlement period in day (1..48)

PARTICIPANTID

VARCHAR2(10)

X

Participant unique identifier

INTERCONNECTORID

VARCHAR2(10)

X

Identifier of Contracted Interconnector

FROMREGIONID

VARCHAR2(10)

X

Nominated source region for Interconnector

TOTALSURPLUS

NUMBER(15,5)

 

Total value of surplus

CONTRACTALLOCATION

NUMBER(8,5)

 

Percentage of total surplus allocated to participant

SURPLUSVALUE

NUMBER(15,5)

 

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

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