Package: SETTLEMENT_DATA

Name

SETTLEMENT_DATA

Comment

Results from a published Settlements 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.


List of tables

Name

Comment

Visibility

DAYTRACK

DAYTRACK identifies the actual settlement run processed for each settlement day. Settlement run is in the column EXPOSTRUNNO. Generally the number of the settlement run used in the latest statement is the maximum number.

Public

SET_ APC_COMPENSATION

APC Compensation payment amounts in the Settlements timeframe

Private

SET_ APC_RECOVERY

APC Compensation recovery amounts in the Settlements timeframe

Private

SET_ANCILLARY_SUMMARY

SET_ANCILLARY_SUMMARY summarises payments for all Ancillary Services to participants on the basis of regions and trading intervals.

Public

SET_ENERGY_GENSET_DETAIL

The Settlement Energy Genset report contains the Energy Transactions data for each generation meter point. This report is produced only for Settlement Date post the IESS rule effective date.

Private

SET_ENERGY_REGION_SUMMARY

The Settlement Energy Region Summary report contains the Energy Transactions Summary for all the NEM regions. This report is produced only for Settlement Date post the IESS rule effective date.

Public

SET_ENERGY_TRAN_SAPS

The table shows the Transaction Details for the SAPS Connection Points. The table contains both the MSRPs and Retailers data

Private

SET_ENERGY_TRANSACTIONS

The Settlement Energy Transactions report contains the Energy Transactions data for all the Participants based on their ACE and ASOE at each customer and generator Connection Point ID. This table is populated The Settlement Energy Transactions report contains the Energy Transactions data for all the Participants based on their ACE and ASOE at each customer and generator Connection Point ID. This table is populated only if Settlement Date is post the IESS rule effective date.

Private

SET_FCAS_PAYMENT

SET_FCAS_PAYMENT sets out the enabling payment details for frequency controlled Ancillary Services.

Private

SET_FCAS_RECOVERY

SET_FCAS_RECOVERY shows reimbursements for the Frequency Control Ancillary Services (FCAS) to be recovered from participants. Beware of potential confusion with the table SETFCASRECOVERY, which reports reimbursements for Frequency Control Ancillary Services Compensation (now unused).

Private

SET_FCAS_REGULATION_TRK

SET_FCAS_REGULATION_TRK shows FCAS Regulation Service Constraint tracking for Regional FCAS Regulation recovery

Public

SET_NMAS_RECOVERY

SET_NMAS_RECOVERY sets out the NSCAS recovery data for payments other than testing.

Private

SET_NMAS_RECOVERY_RBF

SET_NMAS_RECOVERY_RBF publishes the RBF for NSCAS non testing payments on a half hourly basis.

Public

SET_RECOVERY_ENERGY

Settlements substitution recovery energy used

Private

SET_RUN_PARAMETER

SET_RUN_PARAMETER shows the input parameters and value associated with each settlement run (e.g. Residual System Load Causer Pays Factor).

Public

SET_SUBST_RUN_VERSION

Settlements substitution demand run version numbers

Public

SET_SUBSTITUTE_DEMAND

Settlements substitution demand for Zero Demand figures

Private

SET_WDR_RECON_DETAIL

Settlements WDR reconciliation details

Private

SET_WDR_TRANSACT

Settlements WDR transactions summary

Private

SETCPDATA

SETCPDATA shows meter settlement data for each connection point. This is the key view for retailers to verify energy charges. A regional summary view is also provided. As the view has values for each connection point by period, for each meter data file, it is a very large view.

Private

SETCPDATAREGION

SETCPDATAREGION sets out summary meter settlement data for each region.

Public

SETFCASREGIONRECOVERY

The FCAS Recovery amount from each NEM Region and the Energy MWh used for the FCAS Recovery calculation from Participants

Public

SETGENDATA

SETGENDATA shows meter settlement data for each generation meter point. A regional summary is also provided.

Private

SETGENDATAREGION

SETGENDATAREGION sets out summary settlement data for generation within the specified region.

Public

SETINTRAREGIONRESIDUES

The Settlement Intra Region Residues Result.

Public

SETIRAUCSURPLUS

This view supports the Settlements Residue Auction, by holding the NSP participant allocations of IRSurplus arising as a result of the unsold units for a quarter.

Private

SETIRNSPSURPLUS

This view supports the Settlements Residue Auction, by showing the TNSP participant allocations of Interconnector Residue (IR) Surplus (i.e. derogated amounts) arising as a result of the sold units for a quarter.

Private

SETIRPARTSURPLUS

This view supports the Settlements Residue Auction, holding the participant allocations of IRSurplus.

Private

SETIRSURPLUS

SETIRSURPLUS records the interregional residue calculation for each interconnector and each side of the interconnector.

Public

SETLOCALAREAENERGY

SETLOCALAREAENERGY shows the UFE, AGE and associated values for each local area and trading interval in a settlement run.

Public

SETLOCALAREATNI

SETLOCALAREATNI shows the list of TNIs constituent to a local area in a settlement run.

Public

SETLSHEDPAYMENT

SETLSHEDPAYMENT shows specific payment details for load shed services by period.

Private

SETLSHEDRECOVERY

SETLSHEDRECOVERY shows reimbursements for Load shed Ancillary Services to be recovered from participants. (Data no longer created for Settlement Days from 01/07/2012)

Private

SETMARKETFEES

SETMARKETFEES shows payments for market fees for each settlement date.

Private

SETREALLOCATIONS

SETREALLOCATIONS shows the trading interval value of reallocations processed, for those participants whose reallocation submissions have been accepted by AEMO.

Private

SETRESERVERECOVERY

SETRESERVERECOVERY shows reserve recovery details.

Private

SETRESTARTPAYMENT

SETRESTARTPAYMENT shows specific payment details for System Restart services by period.

Private

SETRESTARTRECOVERY

SETRESTARTRECOVERY shows reimbursements for system restart Ancillary Services to be recovered from participants. (Data no longer created for Settlement Days from 01/07/2012)

Private

SETRPOWERPAYMENT

SETRPOWERPAYMENT shows specific payment details for Reactive power services by period.

Private

SETRPOWERRECOVERY

SETRPOWERRECOVERY shows reimbursements for Reactive Power Ancillary Services to be recovered from participants. (Data no longer created for Settlement Days from 01/07/2012)

Private

SETSMALLGENDATA

Publishes metering data and associated settlement values for with a registered Small Generator Aggregator participants connection points.

Private


Diagram: Entities: Settlement Data

Table: DAYTRACK Table: SET_RUN_PARAMETER Table: SETLOCALAREATNI Table: SETCPDATAREGION Table: SETIRSURPLUS Table: SETCPDATA Table: SET_FCAS_PAYMENT Table: SETGENDATAREGION Table: SETGENDATA Table: SETLOCALAREAENERGY Table: SETLSHEDPAYMENT Table: SETSMALLGENDATA Table: SETREALLOCATIONS Table: SETLSHEDRECOVERY Table: SET_FCAS_RECOVERY Table: SETRESTARTPAYMENT Table: SET_WDR_RECON_DETAIL Table: SET_SUBST_RUN_VERSION Table: SET_SUBSTITUTE_DEMAND Table: SETRESTARTRECOVERY Table: SETRESERVERECOVERY Table: SETINTRAREGIONRESIDUES Table: SETMARKETFEES Table: SET_RECOVERY_ENERGY Table: SET_FCAS_REGULATION_TRK Table: SETIRNSPSURPLUS Table: SETIRAUCSURPLUS Table: SET_ENERGY_TRAN_SAPS Table: SETIRPARTSURPLUS Table: SETFCASREGIONRECOVERY Table: SET_ APC_RECOVERY Table: SET_ENERGY_REGION_SUMMARY Table: SET_ APC_COMPENSATION Table: SET_ANCILLARY_SUMMARY Table: SET_NMAS_RECOVERY Table: SET_WDR_TRANSACT Table: SET_ENERGY_TRANSACTIONS Table: SET_ENERGY_GENSET_DETAIL Table: SET_NMAS_RECOVERY_RBF
Entities: Settlement Data