|
Name |
|
|
Comment |
This view supports the Settlements Residue Auction, holding the participant allocations of IRSurplus. |
|
SETIRPARTSURPLUS data is confidential to each participant. Source SETIRPARTSURPLUS updates with each settlement run. Volume SETIRPARTSURPLUS contains a maximum of 20 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 |
Settlement date |
|
SETTLEMENTRUNNO |
NUMBER(3,0) |
X |
Settlement run number |
|
CONTRACTID |
VARCHAR2(10) |
X |
Ancillary Service Contract |
|
PERIODID |
NUMBER(2,0) |
X |
Settlement period in the day (1..48) |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant unique identifier |
|
INTERCONNECTORID |
VARCHAR2(10) |
X |
Identifier of the Contracted Interconnector |
|
FROMREGIONID |
VARCHAR2(10) |
X |
Nominated source region for Interconnector |
|
TOTALSURPLUS |
NUMBER(15,5) |
|
Total value of surplus before allocation |
|
CONTRACTALLOCATION |
NUMBER(8,5) |
|
Allocated percentage 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 updated |
|
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 |
|
|
|