|
Name |
|
|
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. |
|
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. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private |
|
Name |
|
CONTRACTID |
|
FROMREGIONID |
|
INTERCONNECTORID |
|
PARTICIPANTID |
|
PERIODID |
|
SETTLEMENTDATE |
|
SETTLEMENTRUNNO |
|
Name |
|
LASTCHANGED |
|
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(2,0) |
X |
Settlement Period in day (1..48) |
|
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 |
|
|
|