Package: BILLING_RUN

Name

BILLING_RUN

Comment

Results from a published Billing Run. The settlement data and billing run data are updated daily between 6am and 8am for AEMO's prudential processes. In a normal week, AEMO publishes one PRELIM, one FINAL and two REVISION runs in addition to the daily runs.

Each billing run is uniquely identified by contract year, week no and bill run no.


List of tables

Name

Comment

BILLING_APC_COMPENSATION

Billing result table for APC compensation payments.

BILLING_APC_RECOVERY

Billing result table for recovery of APC compensation payments

BILLING_CO2E_PUBLICATION

Carbon Dioxide Intensity Index publication table

BILLING_CO2E_PUBLICATION_TRK

Carbon Dioxide Intensity Index publication tracking table

BILLING_DAILY_ENERGY_SUMMARY

Billing result table containing daily summary data for customer and generator energy amounts

BILLING_DIRECTION_RECON_OTHER

Billing reconciliation result table for both provisional and final directions

BILLING_DIRECTION_RECONCILIATN

Billing reconciliation result table for both provisional and final directions using the FPP methodology (prior to 1st July 2011)

BILLING_EFTSHORTFALL_AMOUNT

The billing shortfall run amounts

BILLING_EFTSHORTFALL_DETAIL

The Billing Shortfall Run Amount details

BILLING_GST_DETAIL

BILLING_GST_DETAIL shows the BAS class, GST_Exclusive and GST amount (if any) attributable to a participant for each transaction type.

BILLING_GST_SUMMARY

BILLING_GST_SUMMARY shows the GST_Exclusive and GST amount (if any) attributable to a participant for each BAS class.

BILLING_NMAS_TST_PAYMENTS

BILLING_NMAS_TEST_PAYMENTS publish the NSCAS/SRAS Testing Payments data for a posted billing week.

BILLING_NMAS_TST_RECOVERY

BILLING_NMAS_TEST_RECOVERY sets out the recovery of NMAS testing payments

BILLING_NMAS_TST_RECVRY_RBF

BILLING_NMAS_TEST_RECVRY_RBF sets out the NSCAS/SRAS Testing Payment recovery data for the posted billing week.

BILLING_NMAS_TST_RECVRY_TRK

BILLING_NMAS_TEST_RECVRY_TRK tracks the energy data used to allocate the test payment recovery over the recovery period.

BILLING_SECDEP_INTEREST_PAY

The interest amount for security deposit calculated by billing, based on whether it is a fixed/floating rate

BILLING_SECDEP_INTEREST_RATE

The DAILY interest rates used by billing when calculating the interest amount

BILLING_SECDEPOSIT_APPLICATION

The security deposit application details

BILLING_SUBST_DEMAND

Demand Values Substituted in Billing Calculation

BILLING_SUBST_RUN_VERSION

Details of settlement runs used as input in the substitute demand calculation

BILLING_WDR

Billing WDR Transaction Weekly Summary

BILLING_WDR_DETAIL

Billing WDR transaction detail summary

BILLINGAPCCOMPENSATION

BILLINGAPCCOMPENSATION shows Administered Price Cap (APC) compensation amounts for the billing period. Data is for each participant by region.

BILLINGAPCRECOVERY

BILLINGAPCRECOVERY shows the Administered Price Cap (APC) Recovery for the billing period. Data is for each participant by region.

BILLINGASPAYMENTS

BILLINGASPAYMENTS shows Ancillary Service payments for each billing period by each of the Ancillary Service types for each participant’s connection points.

BILLINGASRECOVERY

BILLINGASRECOVERY shows participant charges for Ancillary Services for the billing period. This view shows the billing amounts for Ancillary Service Recovery.

BILLINGCPDATA

BILLINGCPDATA shows energy quantity and $ value purchased per participant connection point.

BILLINGDAYTRK

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.

BILLINGFEES

BILLINGFEES presents pool fees applied to the statement, per billing run.

BILLINGFINANCIALADJUSTMENTS

BILLINGFINANCIALADJUSTMENTS contains any manual adjustments included in the billing run.

BILLINGGENDATA

BILLINGGENDATA shows the total energy sold and purchased per participant transmission connection point for a billing period.

BILLINGINTERRESIDUES

BILLINGINTERRESIDUES shows interregion residues payable to NSP.

BILLINGINTRARESIDUES

BILLINGINTRARESIDUES shows intra-region settlement residue details for each Transmission Network Service Provider participant by region.

BILLINGIRAUCSURPLUS

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.

BILLINGIRAUCSURPLUSSUM

BILLINGIRAUCSURPLUSSUM contains Auction fees and Settlements Residue Auction distribution that may arise from unpurchased auction units that accrue to Transmission Network Service Providers.

BILLINGIRFM

BILLINGIRFM shows billing amounts associated with Industrial Relations Forced Majeure events for each participant.

BILLINGIRNSPSURPLUS

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).

BILLINGIRNSPSURPLUSSUM

BILLINGIRNSPSURPLUSSUM contains derogated payments made to TNSPs arising from the Settlements Residue Auction process.

BILLINGIRPARTSURPLUS

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

BILLINGIRPARTSURPLUSSUM

BILLINGIRPARTSURPLUSSUM supports the Settlements Residue Auction, by showing the weekly billing SRA distribution and associated fees to Auction participants.

BILLINGPRIORADJUSTMENTS

BILLINGPRIORADJUSTMENTS sets out prior period adjustments and associated interest inserted in subsequent Final Statements arising from Revision Statement postings.

BILLINGREALLOC

BILLINGREALLOC shows reallocation contract values in each billing run, where participants have used reallocations.

BILLINGREALLOC_DETAIL

Billing Reallocation Data aggregated by REALLOCATIONID for each billing run over the billing week.

BILLINGREGIONEXPORTS

BILLINGREGIONEXPORTS sets out the region summary table of overall energy exported to and from each region for each billing run.

BILLINGREGIONFIGURES

BILLINGREGIONFIGURES sets out additional summary region details including ancillary service amounts for each billing run.

BILLINGREGIONIMPORTS

BILLINGREGIONIMPORTS sets out the region summary table of overall energy imported to and from each region for each billing run.

BILLINGRUNTRK

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.

BILLRESERVETRADERPAYMENT

Details of the RERT Usage and Availability Payments made to the participant.

BILLRESERVETRADERRECOVERY

Provides details of the RERT Recovery Amount for the Market Customers.

BILLWHITEHOLE

BILLWHITEHOLE shows white hole payments based on participant vs region demand.


Diagram: Entities: Billing Run

Table: BILLINGRUNTRK Table: BILLINGIRFM Table: BILLING_WDR Table: BILLINGDAYTRK Table: BILLWHITEHOLE Table: BILLINGREALLOC Table: BILLINGGENDATA Table: BILLING_CO2E_PUBLICATION_TRK Table: BILLINGCPDATA Table: BILLINGREGIONFIGURES Table: BILLINGASRECOVERY Table: BILLINGASPAYMENTS Table: BILLINGAPCRECOVERY Table: BILLINGFEES Table: BILLING_GST_SUMMARY Table: BILLINGINTRARESIDUES Table: BILLING_CO2E_PUBLICATION Table: BILLINGREGIONEXPORTS Table: BILLING_GST_DETAIL Table: BILLINGREGIONIMPORTS Table: BILLINGAPCCOMPENSATION Table: BILLINGINTERRESIDUES Table: BILLING_EFTSHORTFALL_AMOUNT Table: BILLINGREALLOC_DETAIL Table: BILLING_SUBST_DEMAND Table: BILLING_WDR_DETAIL Table: BILLRESERVETRADERPAYMENT Table: BILLING_APC_COMPENSATION Table: BILLINGIRNSPSURPLUS Table: BILLINGIRAUCSURPLUS Table: BILLING_SECDEPOSIT_APPLICATION Table: BILLING_SUBST_RUN_VERSION Table: BILLING_DIRECTION_RECONCILIATN Table: BILLINGIRPARTSURPLUS Table: BILLING_APC_RECOVERY Table: BILLING_EFTSHORTFALL_DETAIL Table: BILLING_SECDEP_INTEREST_PAY Table: BILLINGFINANCIALADJUSTMENTS Table: BILLING_SECDEP_INTEREST_RATE Table: BILLING_DIRECTION_RECON_OTHER Table: BILLING_NMAS_TST_PAYMENTS Table: BILLINGPRIORADJUSTMENTS Table: BILLING_NMAS_TST_RECVRY_RBF Table: BILLING_NMAS_TST_RECVRY_TRK Table: BILLINGIRNSPSURPLUSSUM Table: BILLINGIRAUCSURPLUSSUM Table: BILLRESERVETRADERRECOVERY Table: BILLING_NMAS_TST_RECOVERY Table: BILLING_DAILY_ENERGY_SUMMARY Table: BILLINGIRPARTSURPLUSSUM
Entities: Billing Run