SETTLEMENT_DATA

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.

Tables

This package contains the following tables:

Name	Description
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.
SET_APC_COMPENSATION	APC Compensation payment amounts in the Settlements timeframe
SET_APC_RECOVERY	APC Compensation recovery amounts in the Settlements timeframe
SET_ANCILLARY_SUMMARY	SET_ANCILLARY_SUMMARY summarises payments for all Ancillary Services to participants on the basis of regions and trading intervals.
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.
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.
SET_ENERGY_TRAN_SAPS	The table shows the Transaction Details for the SAPS Connection Points. The table contains both the MSRPs and Retailers data
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.
SET_FCAS_CLAWBACK_REQ	This report contains the Interval Datetime affected by the Clawback Run and the adjusted FCAS requirement Costs.
SET_FCAS_CLAWBACK_RUN_TRK	This Settlements FCAS Clawback Run Track report contains the Interval Datetime for which a Clawback has occurred and included in the Settlement run. The report will be produced only if there is any Clawback Run for the Interval date time in the Settlement Date
SET_FCAS_CLAWBACK_UNITSOLN	This report contains the Interval Datetime affected by the Clawback Run and the reduced MW for the FCAS Service for each affected DUID.
SET_FCAS_PAYMENT	SET_FCAS_PAYMENT sets out the enabling payment details for frequency controlled Ancillary Services.
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).
SET_FCAS_REG_AMOUNT	This report contains the the FCAS Regulation Amounts that include FPP Amounts, Used Amounts and Unused Amounts calculated using the Contribution Factors
SET_FCAS_REG_DEF_AMT	This report contains the the FCAS Regulation Amounts that include FPP Amounts, Used Amounts and Unused Amounts calculated using the Default Contribution Factors. This is when FPP Factors are not available for a particular interval and system used DCF in the calculation.
SET_FCAS_REG_DEF_RESIDAMT	This report contains the FCAS Regulation Residue Amounts that include FPP Residual Amounts, Used Residual Amounts and Unused Residual Amounts calculated using the Energy Ratio for each Requirement Region and the Default Residual CF.
SET_FCAS_REG_RESIDAMT	This report contains the FCAS Regulation Residue Amounts that include FPP Residual Amounts, Used Residual Amounts and Unused Residual Amounts calculated using the Energy Ratio for each Requirement Region.
SET_FCAS_REGULATION_TRK	SET_FCAS_REGULATION_TRK shows FCAS Regulation Service Constraint tracking for Regional FCAS Regulation recovery
SET_FPP	This report contains the summary of FPP Amounts for each ParticipantId in each region
SET_IRSR_DIRECTIONAL_LINK	This report contains the MW Flow and Inter-Regional Residue Amounts for all primary interconnectors.
SET_IRSR_LOOP_NETTRADE_AMOUNT	This report contains the final net trade amount for the two directional interconnectors to allocate.
SET_IRSR_LOOP_NSP_ALLOCATION	This report contains Inter-Regional Negative Residue Amounts to allocate to TNSPs.
SET_IRSR_LOOP_REGION_SUMMARY	This report contains Inter-Regional Net Loop Allocations and Net Regional Export Quantities.
SET_NMAS_MANUAL_PAYMENT	This report contains the NMAS Manual TI Payments that are uploaded by the Settlement Business Team. Amounts in this table are not calculated by the Settlement System.
SET_NMAS_RECOVERY	SET_NMAS_RECOVERY sets out the NSCAS recovery data for payments other than testing This Table may also be used for NSCAS and Type 1 transitional services procured by AEMO under the ISF framework during 2025 and prior to the implementation of all system changes. During this time descriptions in these tables may not be correct.
SET_NMAS_RECOVERY_RBF	SET_NMAS_RECOVERY_RBF publishes the RBF for NSCAS non testing payments on a half hourly basis. This Table may also be used for NSCAS and Type 1 transitional services procured by AEMO under the ISF framework during 2025 and prior to the implementation of all system changes. During this time descriptions in these tables may not be correct.
SET_RECOVERY_ENERGY	Settlements substitution recovery energy used
SET_SUBST_RUN_VERSION	Settlements substitution demand run version numbers
SET_SUBSTITUTE_DEMAND	Settlements substitution demand for Zero Demand figures
SET_WDR_RECON_DETAIL	Settlements WDR reconciliation details
SET_WDR_TRANSACT	Settlements WDR transactions summary
SETFCASREGIONRECOVERY	The FCAS Recovery amount from each NEM Region and the Energy MWh used for the FCAS Recovery calculation from Participants
SETINTRAREGIONRESIDUES	The Settlement Intra Region Residues Result.
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.
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.
SETIRPARTSURPLUS	This view supports the Settlements Residue Auction, holding the participant allocations of IRSurplus.
SETIRSURPLUS	SETIRSURPLUS records the interregional residue calculation for each interconnector and each side of the interconnector.
SETLOCALAREAENERGY	SETLOCALAREAENERGY shows the UFE, AGE and associated values for each local area and trading interval in a settlement run.
SETLOCALAREATNI	SETLOCALAREATNI shows the list of TNIs constituent to a local area in a settlement run.
SETLSHEDPAYMENT	SETLSHEDPAYMENT shows specific payment details for load shed services by period. This Table may also be used for NSCAS and Type 1 transitional services procured by AEMO under the ISF framework during 2025 and prior to the implementation of all system changes. During this time descriptions in these tables may not be correct.
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)
SETMARKETFEES	SETMARKETFEES shows payments for market fees for each settlement date.
SETREALLOCATIONS	SETREALLOCATIONS shows the trading interval value of reallocations processed, for those participants whose reallocation submissions have been accepted by AEMO.
SETRESERVERECOVERY	SETRESERVERECOVERY shows reserve recovery details.
SETRESTARTPAYMENT	SETRESTARTPAYMENT shows specific payment details for System Restart services by period.
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)
SETRPOWERPAYMENT	SETRPOWERPAYMENT shows specific payment details for Reactive power services by period. This Table may also be used for NSCAS and Type 1 transitional services procured by AEMO under the ISF framework during 2025 and prior to the implementation of all system changes. During this time descriptions in these tables may not be correct.
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)

Diagram

Links

Package Documentation

Copy as Markdown