Table: BILLINGIRPARTSURPLUS

BILLINGIRPARTSURPLUS

Name

BILLINGIRPARTSURPLUS

Comment

BILLINGIRPARTSURPLUS supports the Settlements Residue Auction, by showing the weekly billing SRA distribution to Auction participants by Contract Identifier.


Description

BILLINGIRPARTSURPLUS data is confidential to the relevant participant.

Source

BILLINGIRPARTSURPLUS is populated by the posting of a billing run where the participant has purchased auction units relating to that billing run.

Volume

An indicative maximum is 64 records inserted per billing run, or 700 records inserted per week.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

BILLRUNNO

CONTRACTID

CONTRACTYEAR

FROMREGIONID

INTERCONNECTORID

PARTICIPANTID

WEEKNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

CONTRACTYEAR

NUMBER(4,0)

X

SRA Contracted Year (calendar year)

WEEKNO

NUMBER(2,0)

X

Week no within the contract year. Week no 1 is the week containing 1st January

RESIDUEYEAR

NUMBER(4,0)

 

Year of the Residue Contract; may differ from the calendar year at week 1.

QUARTER

NUMBER(2,0)

 

Residue Contract Quarter

BILLRUNNO

NUMBER(3,0)

X

The sequential number of a billing run

CONTRACTID

VARCHAR2(30)

X

SRA Contract unique identifier

PARTICIPANTID

VARCHAR2(10)

X

Unique participant identifier

INTERCONNECTORID

VARCHAR2(10)

X

Contracted Interconnector

FROMREGIONID

VARCHAR2(10)

X

Nominated source region for Interconnector

TOTALRESIDUES

NUMBER(15,5)

 

Total residues allocated to participant

ADJUSTMENT

NUMBER(15,5)

 

Adjustment allocated to participant

LASTCHANGED

DATE

 

Date and time this record was last modified

ACTUALPAYMENT

NUMBER(15,5)

 

Net actual payment to participant, including auction fees