Table: SETIRPARTSURPLUS

SETIRPARTSURPLUS

Name

SETIRPARTSURPLUS

Comment

This view supports the Settlements Residue Auction, holding the participant allocations of IRSurplus.


Description

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.


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

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