|
Name |
|
|
Comment |
BILLINGIRAUCSURPLUSSUM contains Auction fees and Settlements Residue Auction distribution that may arise from unpurchased auction units that accrue to Transmission Network Service Providers. |
|
BILLINGIRAUCSURPLUSSUM is confidential to the relevant participant. Source BILLINGIRAUCSURPLUSSUM is populated by the posting of a billing run where there are unpurchased auction units. Volume An indicative maximum is eight records inserted per billing run, or 88 records inserted per week. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
FROMREGIONID |
|
INTERCONNECTORID |
|
PARTICIPANTID |
|
QUARTER |
|
RESIDUEYEAR |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
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. |
|
NEGATIVE_RESIDUES |
NUMBER(18,8) |
|
Negative residues in the billing week for this participant in the SRA Year/Quarter |
|
|
|