|
Name |
|
|
Comment |
BILLINGIRPARTSURPLUS supports the Settlements Residue Auction, by showing the weekly billing SRA distribution to Auction participants by Contract Identifier. |
|
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. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTID |
|
CONTRACTYEAR |
|
FROMREGIONID |
|
INTERCONNECTORID |
|
PARTICIPANTID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
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 |
|
|
|