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_MR_PAYMENT

BILLING_MR_PAYMENT shows aggregate payments on a dispatchable unit/MR Event basis for accepted MR capacity

BILLING_MR_RECOVERY

BILLING_MR_RECOVERY shows aggregate recovery charges on a dispatchable unit / MR Event basis for spot market income from dispatch of MR capacity.

BILLING_MR_SHORTFALL

BILLING_MR_SHORTFALL shows aggregate MR shortfall payments (or recovery charges) to each participant in the region for the MR event.

BILLING_MR_SUMMARY

BILLING_MR_SUMMARY shows aggregate payment/recovery and shortfall figures for an MR Event.

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_RES_TRADER_PAYMENT

Billing result table for reserve trader contract payments

BILLING_RES_TRADER_RECOVERY

Billing result table for reserve trader contract recovery

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

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.

BILLINGSMELTERREDUCTION

BILLINGSMELTERREDUCTION shows the smelter reduction payment (only applies to participants with Victorian customer connection points).


2