|
Name |
|
|
Comment |
BILLINGIRPARTSURPLUSSUM supports the Settlements Residue Auction, by showing the weekly billing SRA distribution and associated fees to Auction participants. |
|
BILLINGIRPARTSURPLUSSUM data is confidential to the relevant participant. Source BILLINGIRPARTSURPLUSSUM 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 16 records inserted per billing run, or 166 records inserted per week. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
FROMREGIONID |
|
INTERCONNECTORID |
|
PARTICIPANTID |
|
QUARTER |
|
RESIDUEYEAR |
|
WEEKNO |
|
Name |
|
RESIDUEYEAR |
|
QUARTER |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
SRA Contracted Year (calendar year) |
|
WEEKNO |
NUMBER(3,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1st January |
|
RESIDUEYEAR |
NUMBER(4,0) |
X |
Year of the Residue Contract; may differ from the calendar year at week 1. |
|
QUARTER |
NUMBER(2,0) |
X |
Residue Contract Quarter |
|
BILLRUNNO |
NUMBER(3,0) |
X |
The sequential number of a billing run |
|
INTERCONNECTORID |
VARCHAR2(10) |
X |
Contracted Interconnector |
|
FROMREGIONID |
VARCHAR2(10) |
X |
Nominated source region for Interconnector |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
TOTALSURPLUS |
NUMBER(15,5) |
|
Total residue amount allocated to participant |
|
AUCTIONFEES |
NUMBER(15,5) |
|
Total auction fees payable in this week (negative amount). If AUCTIONFEES + AUCTIONFEES_GST >= TOTALSURPLUS then ACTUALPAYMENT is zero. |
|
ACTUALPAYMENT |
NUMBER(15,5) |
|
Net payment to participant, including auction fees |
|
AUCTIONFEES_GST |
NUMBER(15,5) |
|
The GST amount on the auction fees, always being zero. |
|
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. |
|
AUCTIONFEES_TOTALGROSS_ADJ |
Number(18,8) |
|
The adjusted total Auction fees for the Directional Interconnector. Calculated as the amount of the total fees due from the SRA Auction Participant, pro-rated based on the total surplus for each Directional Interconnector the SRA Auction Participant contracted. |
|
|
|