|
Name |
|
|
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. |
|
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. |
|
Name |
|
CONTRACTID |
|
FROMREGIONID |
|
INTERCONNECTORID |
|
PARTICIPANTID |
|
PERIODID |
|
SETTLEMENTDATE |
|
SETTLEMENTRUNNO |
|
Name |
|
LASTCHANGED |
|
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(3,0) |
X |
Settlements Trading Interval. |
|
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 |
|
|
|