|
Name |
|
|
Comment |
BILLINGCPDATA shows energy quantity and $ value purchased per participant connection point. |
|
BILLINGCPDATA data is confidential to relevant participant. Source Populated by the posting of a billing run, being several times each week. Volume The number of records depends on the number of Transmission ConnectionPointIDs a participant may use to purchase energy. An indicative maximum is approximately 150 records per billrunno, or about 1,500 records inserted per week. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONNECTIONPOINTID |
|
CONTRACTYEAR |
|
MDA |
|
PARTICIPANTID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
|
PARTICIPANTID |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
AEMO Contract Year number starting in week containing 1st January |
|
WEEKNO |
NUMBER(3,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1st January |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Unique run no within a given contract year and week no |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
CONNECTIONPOINTID |
VARCHAR2(10) |
X |
Unique connection point identifier |
|
AGGREGATEENERGY |
NUMBER(16,6) |
|
Aggregate energy purchased/sold by customer, in MWh, plus UFEA. When GS commences, this includes the UFEA amount in the settlement runs. |
|
PURCHASES |
NUMBER(16,6) |
|
The Purchase column has the dollar value of the Energy Purchased rather than Aggregate Energy Dollar |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
MDA |
VARCHAR2(10) |
X |
relevant MDA for this connection point. |
|
AFE |
NUMBER(18,8) |
|
Adjusted Gross Energy for this Market Customer FRMP and TNI in the Billing run, excluding any UFEA component. |
|
DME |
NUMBER(18,8) |
|
Sum of ME- for all NMIs at this Market Customer FRMP and TNI in the Billing run. |
|
UFEA |
NUMBER(18,8) |
|
Share of UFE allocated to this FRMP and TNI in the Billing run. |
|
AGE |
NUMBER(18,8) |
|
Adjusted Gross Energy for this Market Customer FRMP and TNI in the trading interval. This will include the UFEA value once financial settlement of UFE commences with GS. |
|
SOLDENERGY |
NUMBER(18,8) |
|
Energy sold at the connection point by the participant in this billing run |
|
SALES |
NUMBER(18,8) |
|
The total cost of energy sold at the connection point by the participant in this billing run |
|
PURCHASEDENERGY |
NUMBER(18,8) |
|
The energy consumed at the connection point by the participant in this billing run |
|
Name |
|
|
Comment |
BILLINGDAYTRK is key for matching settlement versions with billing runs. BILLINGDAYTRK displays the billrunnos per billing week, and the settlement version numbers per settlement day comprising the billrunno. |
|
BILLINGDAYTRK is public data, and is available to all participants. Source BILLINGDAYTRK is populated by the posting of a billing run, being several times each week. Volume Each billing run inserts approximately 7 records, being about 77 records per week. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
SETTLEMENTDATE |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
AEMO Contract Year number starting in week containing 1st January |
|
WEEKNO |
NUMBER(3,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1st January |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Unique run no within a given contract year and week no |
|
SETTLEMENTDATE |
DATE |
X |
Calendar Settlement Date contained in the billing run. |
|
RUNNO |
NUMBER(3,0) |
|
Settlement run number used for each settlement date in that billing run. |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
BILLINGFEES presents pool fees applied to the statement, per billing run. |
|
BILLINGFEES data is confidential to the relevant participant. Source BILLINGFEES is populated by the posting of a billing run, being several times each week. Volume The number of records varies according to the number of pool fee types the participant may be subject to. An indicative maximum is about 13 records inserted per billrunno or 143 records inserted per week. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
MARKETFEEID |
|
PARTICIPANTCATEGORYID |
|
PARTICIPANTID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
|
PARTICIPANTID |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
AEMO Contract Year number starting in week containing 1st January |
|
WEEKNO |
NUMBER(3,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1st January |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Unique run no within a given contract year and week no |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
MARKETFEEID |
VARCHAR2(10) |
X |
Market fee identifier |
|
RATE |
NUMBER(15,5) |
|
Market fee rate |
|
ENERGY |
NUMBER(16,6) |
|
Energy, in MWh |
|
VALUE |
NUMBER(15,5) |
|
Fee in $ |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
PARTICIPANTCATEGORYID |
VARCHAR2(10) |
X |
The participant category pertaining to the market fee recovery. Corresponds to the PARTICIPANTCATEGORYID column of the SETMARKETFEES table. |
|
Name |
|
|
Comment |
BILLINGFINANCIALADJUSTMENTS contains any manual adjustments included in the billing run. |
|
BILLINGFINANCIALADJUSTMENTS data is confidential to the relevant participant. Source BILLINGFINANCIALADJUSTMENTS is populated by the posting of a billing run, being several times each week. The insertion of a manual adjustment in a billing run is infrequent. Volume Infrequent and, if included in a billing run, low volume. An indicative maximum is 15 records inserted. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
ADJUSTMENTITEM |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
AEMO Contract Year number starting in week containing 1st January |
|
WEEKNO |
NUMBER(3,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1st January |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Unique run no within a given contract year and week no |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
PARTICIPANTTYPE |
VARCHAR2(10) |
|
Not Used |
|
ADJUSTMENTITEM |
VARCHAR2(64) |
X |
Description of the adjustment being made |
|
AMOUNT |
NUMBER(15,5) |
|
The amount of the manual adjustment line item |
|
VALUE |
NUMBER(15,5) |
|
Not Used |
|
LASTCHANGED |
DATE |
|
Last date and time the record changed. |
|
FINANCIALCODE |
NUMBER(10,0) |
|
The GL financial code of the manual adjustment line item. Used internally by AEMO systems. |
|
BAS_CLASS |
VARCHAR2(30) |
|
The BAS classification of the manual adjustment line item. |
|
Name |
|
|
Comment |
BILLINGGENDATA shows the total energy sold and purchased per participant transmission connection point for a billing period. |
|
BILLINGGENDATA data is confidential to the the relevant participant. Source BILLINGGENDATA is populated by the posting of a billing run, being several times each week. Volume The number of records depends on the number of transmission ConnectionPointIDs a Participant may have sold energy from per billrunno. An indicative maximum is approximately 15 records inserted per billrunno, or about 165 records inserted per week. BILLINGGENDATA is confidential to the the relevant participant. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONNECTIONPOINTID |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
|
PARTICIPANTID |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
AEMO Contract Year number starting in week containing 1st January |
|
WEEKNO |
NUMBER(3,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1st January |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Unique run no within a given contract year and week no |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
CONNECTIONPOINTID |
VARCHAR2(10) |
X |
Connection point identifier |
|
STATIONID |
VARCHAR2(10) |
|
not populated |
|
DUID |
VARCHAR2(10) |
|
not populated |
|
AGGREGATEENERGY |
NUMBER(16,6) |
|
Aggregate energy sold, in MWh |
|
SALES |
NUMBER(16,6) |
|
$ income |
|
PURCHASES |
NUMBER(16,6) |
|
$ outgoing |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
PURCHASEDENERGY |
NUMBER(16,6) |
|
Amount of energy purchased in MWh |
|
MDA |
VARCHAR2(10) |
|
Metering Data Agent supplying data |
|
Name |
|
|
Comment |
BILLINGINTERRESIDUES shows interregion residues payable to NSP. |
|
Source Obsolete, was weekly with billing run. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
INTERCONNECTORID |
|
PARTICIPANTID |
|
REGIONID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
ALLOCATION |
NUMBER(6,3) |
|
May not be necessary |
|
TOTALSURPLUS |
NUMBER(15,5) |
|
May not be necessary |
|
INTERCONNECTORID |
VARCHAR2(10) |
X |
Unique identifier for an interconnector which joins two regions. |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
AEMO Contract Year number starting in week containing 1st January |
|
WEEKNO |
NUMBER(3,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1st January |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Unique run no within a given contract year and week no |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
SURPLUSVALUE |
NUMBER(15,6) |
|
Amount NSP is paid for Inter-Regional Residues |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
REGIONID |
VARCHAR2(10) |
X |
Region ID |
|
Name |
|
|
Comment |
BILLINGINTRARESIDUES shows intra-region settlement residue details for each Transmission Network Service Provider participant by region. |
|
BILLINGINTRARESIDUES is confidential to the relevant participant. Source BILLINGINTRARESIDUES is populated by the posting of a billing run, being several times each week. Volume An indicative maximum is two records inserted per billing run, or 22 records inserted per week. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
REGIONID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
ALLOCATION |
NUMBER(6,3) |
|
TNSP allocation |
|
TOTALSURPLUS |
NUMBER(15,5) |
|
Total $ residue amount for the region |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
AEMO Contract Year number starting in week containing 1st January |
|
WEEKNO |
NUMBER(3,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1st January |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Unique run no within a given contract year and week no |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
SURPLUSVALUE |
NUMBER(15,6) |
|
Amount TNSP is paid for Intra-Regional Residues |
|
LASTCHANGED |
DATE |
|
Last changed date |
|
REGIONID |
VARCHAR2(10) |
X |
Region ID |
|
Name |
|
|
Comment |
BILLINGIRAUCSURPLUS supports the Settlements Residue Auction, by showing the weekly billing Interconnector Residue (IR) payments as calculated for each bill run for Network Service Providers (NSPs) from the amount not auctioned. |
|
Source Obsolete Volume This view contains a maximum of 30, 000 records per year. |
|
Name |
Comment |
Value |
|
Visibility |
|
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 |
|
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 |
|
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 |
|
Name |
|
|
Comment |
BILLINGIRFM shows billing amounts associated with Industrial Relations Forced Majeure events for each participant. |
|
BILLINGIRFM is confidential to the relevant participant. Source BILLINGIRFM is updated with each billing run as required. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
Settlement Year |
|
WEEKNO |
NUMBER(3,0) |
X |
Week number starting 1 Jan each year. |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Unique bill run |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant Identifier |
|
IRFMPAYMENT |
NUMBER(15,5) |
|
Industrial Relations Forced Majeure payment for the billing period. |
|
LASTCHANGED |
DATE |
|
Last changed. |
|
Name |
|
|
Comment |
BILLINGIRNSPSURPLUS supports the Settlements Residue Auction (SRA), by showing the weekly billing Interconnector Residue (IR) payments as calculated for each bill run for Transmission Network Service Providers (TNSP) from the amount paid by participants (i.e. derogated amounts). |
|
BILLINGIRNSPSURPLUS data is confidential to the relevant participant. Source BILLINGIRNSPSURPLUS updates in a billing run where any derogated Settlement Residue Auction purchase flows to a TNSP. Volume BILLINGIRNSPSURPLUS contains a maximum of 30, 000 records per year. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTID |
|
CONTRACTYEAR |
|
FROMREGIONID |
|
INTERCONNECTORID |
|
PARTICIPANTID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
AEMO Contract Year number starting in week containing 1st January |
|
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 |
|
Name |
|
|
Comment |
BILLINGIRNSPSURPLUSSUM contains derogated payments made to TNSPs arising from the Settlements Residue Auction process. |
|
BILLINGIRNSPSURPLUSSUM data is confidential to the relevant participant. Source BILLINGIRNSPSURPLUSSUM is populated by the posting of a billing run where derogated payments apply. Volume An indicative maximum is two records inserted per billing run, or 22 records inserted per week. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
FROMREGIONID |
|
INTERCONNECTORID |
|
PARTICIPANTID |
|
QUARTER |
|
RESIDUEYEAR |
|
WEEKNO |
|
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 |
SRA Contracted 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) |
|
This field is 0. |
|
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. |
|
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 |
|
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 |
|
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 |
|
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. |
|
Name |
|
|
Comment |
BILLINGPRIORADJUSTMENTS sets out prior period adjustments and associated interest inserted in subsequent Final Statements arising from Revision Statement postings. |
|
BILLINGPRIORADJUSTMENTS data is confidential to the relevant participant. Source BILLINGPRIORADJUSTMENTS is populated on the posting of a Final billing run only. Volume Approximately two records inserted per week. Note Actual adjustment payable is ADJAMOUNT - PERAMOUNT + INTEREST AMOUNT. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
ADJBILLRUNNO |
|
ADJCONTRACTYEAR |
|
ADJWEEKNO |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
|
PARTICIPANTID |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
Settlement year. |
|
WEEKNO |
NUMBER(3,0) |
X |
Settlement week number. |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Billing run number. |
|
ADJCONTRACTYEAR |
NUMBER(4,0) |
X |
ContractYear of the posted revision statement inserted to the Final Statement |
|
ADJWEEKNO |
NUMBER(3,0) |
X |
WeekNo of the posted revision statement inserted to the Final Statement |
|
ADJBILLRUNNO |
NUMBER(3,0) |
X |
Bill run number of the posted revision statement inserted to the Final Statement |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant ID |
|
PREVAMOUNT |
NUMBER(15,5) |
|
Statement total of the previous posted revision statement inserted to the Final Statement. |
|
ADJAMOUNT |
NUMBER(15,5) |
|
Adjusted amount. |
|
IRN |
NUMBER(15,5) |
|
Interest rate applied to the revision adjustment |
|
IRP |
NUMBER(15,5) |
|
unused; always null |
|
INTERESTAMOUNT |
NUMBER(15,5) |
|
Interest amount. |
|
LASTCHANGED |
DATE |
|
Last changed. |
|
IRSR_PREVAMOUNT |
NUMBER(15,5) |
|
unused; always null |
|
IRSR_ADJAMOUNT |
NUMBER(15,5) |
|
unused; always null |
|
IRSR_INTERESTAMOUNT |
NUMBER(15,5) |
|
unused; always null |
|
Name |
|
|
Comment |
BILLINGREALLOC shows reallocation contract values in each billing run, where participants have used reallocations. |
|
BILLINGREALLOC data is confidential to the relevant participant. Source BILLINGREALLOC is populated by the posting of a billing run. Volume An indicative maximum is two records inserted per billing run, or 22 records inserted per week. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
COUNTERPARTY |
|
PARTICIPANTID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
|
PARTICIPANTID |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
AEMO Contract Year number starting in week containing 1st January |
|
WEEKNO |
NUMBER(3,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1st January |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Unique run no within a given contract year and week no |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
COUNTERPARTY |
VARCHAR2(10) |
X |
Participant who is the counter party to this contract |
|
VALUE |
NUMBER(15,5) |
|
Value billed on this contract |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
Billing Reallocation Data aggregated by REALLOCATIONID for each billing run over the billing week. |
|
The BILLINGREALLOC_DETAIL table that will give a breakdown of the reallocations that form part of that billing run. This assists participants in their settlement reconciliation process.
Private data Volume max 100 rows per day |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
COUNTERPARTY |
|
PARTICIPANTID |
|
REALLOCATIONID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
BILLING CONTRACTYEAR |
|
WEEKNO |
NUMBER(3,0) |
X |
BILLING WEEKNO |
|
BILLRUNNO |
NUMBER(3,0) |
X |
BILLING RUN NO |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
REALLOCATION PARTICIPANTID |
|
COUNTERPARTY |
VARCHAR2(10) |
X |
REALLOCATION COUNTERPARTY PARTICIPANTID |
|
REALLOCATIONID |
VARCHAR2(20) |
X |
REALLOCATIONID |
|
VALUE |
NUMBER(15,5) |
|
REALLOCATION VALUE |
|
LASTCHANGED |
DATE |
|
DATETIME WHEN RECORD SAVED |
|
Name |
|
|
Comment |
BILLINGREGIONEXPORTS sets out the region summary table of overall energy exported to and from each region for each billing run. |
|
BILLINGREGIONEXPORTS data is public, and is available to all participants. Source BILLINGREGIONEXPORTS is populated by the posting of a billing run. Volume Eight records inserted per billing run, or 88 records inserted per week. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
EXPORTTO |
|
REGIONID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
AEMO Contract Year number starting in week containing 1st January |
|
WEEKNO |
NUMBER(3,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1st January |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Unique run no within a given contract year and week no |
|
REGIONID |
VARCHAR2(10) |
X |
Unique region identifier |
|
EXPORTTO |
VARCHAR2(10) |
X |
Region exported to |
|
ENERGY |
NUMBER(16,6) |
|
MWh Energy value exported |
|
VALUE |
NUMBER(15,5) |
|
$ Value of energy exported |
|
SURPLUSENERGY |
NUMBER(16,6) |
|
This field is populated with 0 |
|
SURPLUSVALUE |
NUMBER(15,5) |
|
$ Interregional residue |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
BILLINGREGIONFIGURES sets out additional summary region details including ancillary service amounts for each billing run. |
|
BILLINGREGIONFIGURES is public data, and is available to all participants. Source BILLINGREGIONFIGURES is populated by the posting of a billing run. Volume Five records inserted per billing run, or 55 records inserted per week. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
REGIONID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
AEMO Contract Year number starting in week containing 1st January |
|
WEEKNO |
NUMBER(3,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1st January |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Unique run no within a given contract year and week no |
|
REGIONID |
VARCHAR2(10) |
X |
Unique region identifier |
|
ENERGYOUT |
NUMBER(16,6) |
|
MWh Energy output in the region during the billing period |
|
VALUEOUT |
NUMBER(16,6) |
|
$ Value of energy output in region during billing period |
|
ENERGYPURCHASED |
NUMBER(16,6) |
|
MWh Amount of energy purchased in region during billing period |
|
VALUEPURCHASED |
NUMBER(16,6) |
|
$ Value of energy purchased during billing period |
|
EXCESSGEN |
NUMBER(16,6) |
|
This field is populated with 0 |
|
RESERVETRADING |
NUMBER(16,6) |
|
This field is populated with 0 |
|
INTCOMPO |
NUMBER(16,6) |
|
This field is populated with 0 |
|
ADMINPRICECOMPO |
NUMBER(16,6) |
|
This field is populated with 0 |
|
SETTSURPLUS |
NUMBER(16,6) |
|
Intraregional residues in $ |
|
ASPAYMENT |
NUMBER(16,6) |
|
Ancillary service payments in $ |
|
POOLFEES |
NUMBER(16,6) |
|
This field is populated with 0 |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
WDRSQ |
NUMBER(18,8) |
|
WDR Settlement Quantity Capped in MWh |
|
WDRTA |
NUMBER(18,8) |
|
WDR transaction amount in $ |
|
Name |
|
|
Comment |
BILLINGREGIONIMPORTS sets out the region summary table of overall energy imported to and from each region for each billing run. |
|
BILLINGREGIONIMPORTS is public data, and is available to all participants. Source BILLINGREGIONIMPORTS is populated by the posting of a billing run. Volume Eight records inserted per billing run, or 88 records inserted per week. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
IMPORTFROM |
|
REGIONID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
AEMO Contract Year number starting in week containing 1st January |
|
WEEKNO |
NUMBER(3,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1st January |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Unique run no within a given contract year and week no |
|
REGIONID |
VARCHAR2(10) |
X |
Unique region identifier |
|
IMPORTFROM |
VARCHAR2(10) |
X |
Region energy imported from |
|
ENERGY |
NUMBER(16,6) |
|
Amount of energy imported |
|
VALUE |
NUMBER(15,5) |
|
Value of energy imported |
|
SURPLUSENERGY |
NUMBER(16,6) |
|
Populated with 0 |
|
SURPLUSVALUE |
NUMBER(15,5) |
|
Interregional residue |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
BILLINGRUNTRK identifies the Statement type (i.e. Status of PRELIM, FINAL, REVISE) and date of the BillRunNo posted, per WeekNo. This provides a further extension of tracking data from the BILLINGDAYTRK table. |
|
BILLINGRUNTRK is public data, and is available to all participants. Source BILLINGRUNTRK is populated by the posting of a billing run. Volume An indicative maximum is one record inserted per billing run, or 11 records inserted per week. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
Year of the run |
|
WEEKNO |
NUMBER(3,0) |
X |
Week number of the run |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Sequential run number |
|
STATUS |
VARCHAR2(6) |
|
The billing run type, PRELIM, FINAL, REVISE or INTERIM |
|
ADJ_CLEARED |
VARCHAR2(1) |
|
Flag |
|
AUTHORISEDDATE |
DATE |
|
null, since not used |
|
AUTHORISEDBY |
VARCHAR2(10) |
|
null, since not used |
|
POSTDATE |
DATE |
|
When the results were posted |
|
POSTBY |
VARCHAR2(10) |
|
Who posted the results |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
RECEIPTPOSTDATE |
DATE |
|
null, since not used |
|
RECEIPTPOSTBY |
VARCHAR2(10) |
|
null, since not used |
|
PAYMENTPOSTDATE |
DATE |
|
When the payment was posted |
|
PAYMENTPOSTBY |
VARCHAR2(10) |
|
Who posted the payment |
|
SHORTFALL |
NUMBER(16,6) |
|
Payment shortfall amount |
|
MAKEUP |
NUMBER(15,5) |
|
Not Used |
|
Name |
|
|
Comment |
Details of the RERT Usage and Availability Payments made to the participant. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTID |
|
CONTRACTYEAR |
|
PAYMENT_ID |
|
WEEKNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
Billing contract year |
|
WEEKNO |
NUMBER(3,0) |
X |
Billing week number |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Billing posted run number |
|
PARTICIPANTID |
VARCHAR2(20) |
|
Participant identifier. |
|
CONTRACTID |
VARCHAR2(20) |
X |
RERT payment contract ID |
|
PAYMENT_ID |
NUMBER(3,0) |
X |
RERT payment number |
|
PAYMENT_TYPE |
VARCHAR2(40) |
|
Description for the reserve trader contract payment amount. |
|
PAYMENT_AMOUNT |
NUMBER(18,8) |
|
RERT payment amount for the payment type |
|
Name |
|
|
Comment |
Provides details of the RERT Recovery Amount for the Market Customers. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
PAYMENT_ID |
|
PUBLICATION_ID |
|
REGIONID |
|
WEEKNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
Billing contract year |
|
WEEKNO |
NUMBER(3,0) |
X |
Billing week number |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Billing posted run number |
|
PUBLICATION_ID |
VARCHAR2(40) |
X |
Unique Publication Identifier for RERT Payment |
|
PAYMENT_ID |
NUMBER(3,0) |
X |
RERT payment number |
|
PAYMENT_AMOUNT |
NUMBER(18,8) |
|
RERT payment amount |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
Participant identifier. |
|
REGIONID |
VARCHAR2(20) |
X |
Region from which the amount is recovered |
|
PARTICIPANT_DEMAND |
NUMBER(18,8) |
|
Participant Demand Value used for RERT Recovery. NULL for Billing Week post the IESS rule effective date. |
|
REGION_DEMAND |
NUMBER(18,8) |
|
Region Demand Value used for RERT Recovery. NULL for Billing Week post the IESS rule effective date. |
|
ELIGIBILITY_START_INTERVAL |
DATE |
|
Starting Period of RERT Recovery for Usage Payments |
|
ELIGIBILITY_END_INTERVAL |
DATE |
|
Ending Period of RERT Recovery for Usage Payments |
|
RECOVERY_AMOUNT |
NUMBER(18,8) |
|
Recovery Amount applicable for each Market Customer |
|
EXCLUDED_ENERGY |
NUMBER(18,8) |
|
The Energy Value (Scheduled Loads) that is excluded |
|
PARTICIPANT_ACE_MWH |
NUMBER(18,8) |
|
The Participant ACE MWh Value used in the Recovery of the RERT Amount. NULL for Billing Week prior to the IESS rule effective date |
|
REGION_ACE_MWH |
NUMBER(18,8) |
|
The Region ACE MWh Value used in the Recovery of the RERT Amount. NULL for Billing Week prior to the IESS rule effective date |
|
Name |
|
|
Comment |
BILLWHITEHOLE shows white hole payments based on participant vs region demand. |
|
Confidential Source Obsolete; was updated weekly with each billing run. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
INTERCONNECTORID |
|
PARTICIPANTID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(22,0) |
X |
AEMO Contract Year number starting in week containing 1st January |
|
WEEKNO |
NUMBER(22,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1st January |
|
BILLRUNNO |
NUMBER(22,0) |
X |
Unique run no within a given contract year and week no |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
NL |
NUMBER(15,6) |
|
Sum of billing week (RRP * interconnector flow) |
|
PARTICIPANTDEMAND |
NUMBER(15,6) |
|
The sum of all customer purchases in MWh |
|
REGIONDEMAND |
NUMBER(15,6) |
|
Sum of all region purchases in MWh |
|
WHITEHOLEPAYMENT |
NUMBER(15,6) |
|
Payment in $ |
|
LASTCHANGED |
DATE |
|
The latest date and time that a file was updated or inserted |
|
INTERCONNECTORID |
VARCHAR2(10) |
X |
Interconnector ID |
|
|
|