Electricity Data Model Report

This document is made available to you on the foll

List of packages

Description of the model AEMO Electricity Data Mod

Each table description has a Note providing some i

Visibility refers to the nature of confidentiality

Private: meaning the data is confidential to the P

Package: CONFIGURATION

Diagram: Entities: Configuration

Table: MMS_DATA_MODEL_AUDIT

Package: ANCILLARY_SERVICES

Diagram: Entities: Ancillary Services

Table: CONTRACTAGC

Table: CONTRACTLOADSHED

Table: CONTRACTREACTIVEPOWER

Table: CONTRACTRESTARTSERVICES

Table: CONTRACTRESTARTUNITS

Package: ASOFFER

Diagram: Entities: Ancillary Service Contracts

Table: OFFERAGCDATA

Table: OFFERASTRK

Table: OFFERLSHEDDATA

Table: OFFERRESTARTDATA

Table: OFFERRPOWERDATA

Package: BILLING_CONFIG

Diagram: Entities: Billing Config

Table: BILLINGCALENDAR

Table: GST_BAS_CLASS

Table: GST_RATE

Table: GST_TRANSACTION_CLASS

Table: GST_TRANSACTION_TYPE

Table: SECDEPOSIT_INTEREST_RATE

Table: SECDEPOSIT_PROVISION

Package: BILLING_RUN

Diagram: Entities: Billing Run

Table: BILLING_APC_COMPENSATION

Table: BILLING_APC_RECOVERY

Table: BILLING_CO2E_PUBLICATION

Table: BILLING_CO2E_PUBLICATION_TRK

Table: BILLING_DAILY_ENERGY_SUMMARY

Table: BILLING_DIR_FINAL_AMOUNT

Table: BILLING_DIR_FINAL_RECOVERY

Table: BILLING_DIR_PROV_AMOUNT

Table: BILLING_DIR_PROV_RECOVERY

Table: BILLING_DIR_RECOVERY_DETAIL

Table: BILLING_DIRECTION_RECON_OTHER

Table: BILLING_DIRECTION_RECONCILIATN

Table: BILLING_EFTSHORTFALL_AMOUNT

Table: BILLING_EFTSHORTFALL_DETAIL

Table: BILLING_ENERGY_GENSET_DETAIL

Table: BILLING_ENERGY_TRAN_SAPS

Table: BILLING_ENERGY_TRANSACTIONS

Table: BILLING_GST_DETAIL

Table: BILLING_GST_SUMMARY

Table: BILLING_NMAS_TST_PAYMENTS

Table: BILLING_NMAS_TST_RECOVERY

Table: BILLING_NMAS_TST_RECVRY_RBF

Table: BILLING_NMAS_TST_RECVRY_TRK

Table: BILLING_SECDEP_INTEREST_PAY

Table: BILLING_SECDEP_INTEREST_RATE

Table: BILLING_SECDEPOSIT_APPLICATION

Table: BILLING_SUBST_DEMAND

Table: BILLING_SUBST_RUN_VERSION

Table: BILLING_WDR

Table: BILLING_WDR_DETAIL

Table: BILLINGAPCCOMPENSATION

Table: BILLINGAPCRECOVERY

Table: BILLINGASPAYMENTS

Table: BILLINGASRECOVERY

Table: BILLINGCPDATA

Table: BILLINGDAYTRK

Table: BILLINGFEES

Table: BILLINGFINANCIALADJUSTMENTS

Table: BILLINGGENDATA

Table: BILLINGINTERRESIDUES

Table: BILLINGINTRARESIDUES

Table: BILLINGIRAUCSURPLUS

Table: BILLINGIRAUCSURPLUSSUM

Table: BILLINGIRFM

Table: BILLINGIRNSPSURPLUS

Table: BILLINGIRNSPSURPLUSSUM

Table: BILLINGIRPARTSURPLUS

Table: BILLINGIRPARTSURPLUSSUM

Table: BILLINGPRIORADJUSTMENTS

Table: BILLINGREALLOC

Table: BILLINGREALLOC_DETAIL

Table: BILLINGREGIONEXPORTS

Table: BILLINGREGIONFIGURES

Table: BILLINGREGIONIMPORTS

Table: BILLINGRUNTRK

Table: BILLRESERVETRADERPAYMENT

Table: BILLRESERVETRADERRECOVERY

Table: BILLWHITEHOLE

Package: DEMAND_FORECASTS

Package: DISPATCH

Package: FORCE_MAJEURE

Package: GD_INSTRUCT

Diagram: Entities: GD Instruct

Table: GDINSTRUCT

Table: INSTRUCTIONSUBTYPE

Table: INSTRUCTIONTYPE

Package: GENERIC_CONSTRAINT

Package: IRAUCTION

Diagram: Entities: IRAuction

Table: AUCTION_CALENDAR

Table: AUCTION_IC_ALLOCATIONS

Table: AUCTION_REVENUE_ESTIMATE

Table: AUCTION_REVENUE_TRACK

Table: AUCTION_RP_ESTIMATE

Table: AUCTION_TRANCHE

Table: RESIDUE_BID_TRK

Table: RESIDUE_CON_DATA

Table: RESIDUE_CON_ESTIMATES_TRK

Table: RESIDUE_CON_FUNDS

Table: RESIDUE_CONTRACTS

Table: RESIDUE_FUNDS_BID

Table: RESIDUE_PRICE_BID

Table: RESIDUE_PRICE_FUNDS_BID

Table: RESIDUE_PUBLIC_DATA

Table: RESIDUE_TRK

Table: RESIDUECONTRACTPAYMENTS

Table: RESIDUEFILETRK

Table: SRA_CASH_SECURITY

Table: SRA_FINANCIAL_AUC_MARDETAIL

Table: SRA_FINANCIAL_AUC_MARGIN

Table: SRA_FINANCIAL_AUC_RECEIPTS

Table: SRA_FINANCIAL_AUCPAY_DETAIL

Table: SRA_FINANCIAL_AUCPAY_SUM

Table: SRA_FINANCIAL_RUNTRK

Table: SRA_OFFER_PRODUCT

Table: SRA_OFFER_PROFILE

Table: SRA_PRUDENTIAL_CASH_SECURITY

Table: SRA_PRUDENTIAL_COMP_POSITION

Table: SRA_PRUDENTIAL_EXPOSURE

Table: SRA_PRUDENTIAL_RUN

Table: VALUATIONID

Package: MARKET_CONFIG

Package: MARKET_NOTICE

Diagram: Entities: Market Notices

Table: MARKETNOTICEDATA

Table: MARKETNOTICETYPE

Table: PARTICIPANTNOTICETRK

Package: METER_DATA

Diagram: Entities: Meter Data

Table: METERDATA_AGGREGATE_READS

Table: METERDATA_INDIVIDUAL_READS

Table: METERDATA_INTERCONNECTOR

Table: METERDATA_SAPS

Table: METERDATA_WDR_READS

Package: MTPASA

Package: PARTICIPANT_REGISTRATION

Package: PRE_DISPATCH

Package: RESERVE_DATA

Diagram: Entities: Reserve Data

Table: MTPASA_RESERVELIMIT

Table: MTPASA_RESERVELIMIT_REGION

Table: MTPASA_RESERVELIMIT_SET

Package: SETTLEMENT_CONFIG

Package: SETTLEMENT_DATA

Diagram: Entities: Settlement Data

Table: DAYTRACK

Table: SET_ APC_COMPENSATION

Table: SET_ APC_RECOVERY

Table: SET_ANCILLARY_SUMMARY

Table: SET_ENERGY_GENSET_DETAIL

Table: SET_ENERGY_REGION_SUMMARY

Table: SET_ENERGY_TRAN_SAPS

Table: SET_ENERGY_TRANSACTIONS

Table: SET_FCAS_PAYMENT

Table: SET_FCAS_RECOVERY

Table: SET_FCAS_REGULATION_TRK

Table: SET_NMAS_RECOVERY

Table: SET_NMAS_RECOVERY_RBF

Table: SET_RECOVERY_ENERGY

Table: SET_RUN_PARAMETER

Table: SET_SUBST_RUN_VERSION

Table: SET_SUBSTITUTE_DEMAND

Table: SET_WDR_RECON_DETAIL

Table: SET_WDR_TRANSACT

Table: SETCPDATA

Table: SETCPDATAREGION

Table: SETFCASREGIONRECOVERY

Table: SETGENDATA

Table: SETGENDATAREGION

Table: SETINTRAREGIONRESIDUES

Table: SETIRAUCSURPLUS

Table: SETIRNSPSURPLUS

Table: SETIRPARTSURPLUS

Table: SETIRSURPLUS

Table: SETLOCALAREAENERGY

Table: SETLOCALAREATNI

Table: SETLSHEDPAYMENT

Table: SETLSHEDRECOVERY

Table: SETMARKETFEES

Table: SETREALLOCATIONS

Table: SETRESERVERECOVERY

Table: SETRESTARTPAYMENT

Table: SETRESTARTRECOVERY

Table: SETRPOWERPAYMENT

Table: SETRPOWERRECOVERY

Table: SETSMALLGENDATA

Package: STPASA_SOLUTION

Diagram: Entities: ST PASA Solution

Table: STPASA_CASESOLUTION

Table: STPASA_CONSTRAINTSOLUTION

Table: STPASA_INTERCONNECTORSOLN

Table: STPASA_REGIONSOLUTION

Package: TRADING_DATA

Diagram: Entities: Trading Data

Table: AVERAGEPRICE30

Table: TRADINGINTERCONNECT

Table: TRADINGPRICE

Package: HISTORICAL TABLES

Diagram: Entities: Historical Tables

Table: APCCOMPAMOUNT

Table: APCCOMPAMOUNTTRK

Table: BIDPEROFFER

Table: BILLADJUSTMENTS

Table: BILLING_CSP_DEROGATION_AMOUNT

Table: BILLING_MR_PAYMENT

Table: BILLING_MR_RECOVERY

Table: BILLING_MR_SHORTFALL

Table: BILLING_MR_SUMMARY

Table: BILLING_RES_TRADER_PAYMENT

Table: BILLING_RES_TRADER_RECOVERY

Table: BILLINGCPSUM

Table: BILLINGCUSTEXCESSGEN

Table: BILLINGEXCESSGEN

Table: BILLINGINTERVENTION

Table: BILLINGINTERVENTIONREGION

Table: BILLINGRESERVERECOVERY

Table: BILLINGRESERVEREGIONRECOVERY

Table: BILLINGRESERVETRADER

Table: BILLINGRESERVETRADERREGION

Table: BILLINGSMELTERREDUCTION

Table: BILLINTERVENTIONRECOVERY

Table: BILLINTERVENTIONREGIONRECOVERY

Table: BILLSMELTERRATE

Table: CONNECTIONPOINT

Table: CONNECTIONPOINTDETAILS

Table: CONNECTIONPOINTOPERATINGSTA

Table: CONTRACTGOVERNOR

Table: CONTRACTRESERVEFLAG

Table: CONTRACTRESERVETHRESHOLD

Table: CONTRACTRESERVETRADER

Table: CONTRACTUNITLOADING

Table: CONTRACTUNITUNLOADING

Table: DAYOFFER

Table: DAYOFFER_D

Table: DEFAULTDAYOFFER

Table: DEFAULTOFFERTRK

Table: DEFAULTPEROFFER

Table: DISPATCHBIDTRK

Table: DISPATCHCASE_OCD

Table: DISPATCHCASESOLUTION_BNC

Table: DISPATCHLOAD_BNC

Table: DISPATCHTRK

Table: FORCEMAJEURE

Table: FORCEMAJEUREREGION

Table: GENUNITMTRINPERIOD

Table: INTCONTRACT

Table: INTCONTRACTAMOUNT

Table: INTCONTRACTAMOUNTTRK

Table: INTERCONNMWFLOW

Table: MARKETSUSPENSION

Table: MARKETSUSREGION

Table: MAS_CP_CHANGE

Table: MAS_CP_MASTER

Table: METERDATA

Table: METERDATA_GEN_DUID

Table: METERDATA_TRK

Table: METERDATATRK

Table: MNSP_FILETRK

Table: MNSP_OFFERTRK

Table: MNSP_PEROFFER

Table: MR_DAYOFFER_STACK

Table: MR_EVENT

Table: MR_EVENT_SCHEDULE

Table: MR_PEROFFER_STACK

Table: MTPASA_CASE_SET

Table: MTPASA_CASESOLUTION

Table: MTPASA_CONSTRAINTSOLUTION

Table: MTPASA_INTERCONNECTORSOLUTION

Table: MTPASA_REGIONSOLUTION

Table: MTPASA_RESERVELIMITSOLUTION

Table: MTPASACONSTRAINTSOLUTION_D

Table: MTPASAINTERCONNECTORSOLUTION_D

Table: MTPASAREGIONSOLUTION_D

Table: OARTRACK

Table: OFFERFILETRK

Table: OFFERGOVDATA

Table: OFFERULOADINGDATA

Table: OFFERUNLOADINGDATA

Table: PASACASESOLUTION

Table: PASACONSTRAINTSOLUTION

Table: PASAINTERCONNECTORSOLUTION

Table: PASAREGIONSOLUTION

Table: PEROFFER

Table: PEROFFER_D

Table: PREDISPATCHBIDTRK

Table: REALLOCATIONDETAILS

Table: REALLOCATIONINTERVALS

Table: REALLOCATIONS

Table: REGIONFCASRELAXATION_OCD

Table: SET_CSP_DEROGATION_AMOUNT

Table: SET_CSP_SUPPORTDATA_CONSTRAINT

Table: SET_CSP_SUPPORTDATA_ENERGYDIFF

Table: SET_CSP_SUPPORTDATA_SUBPRICE

Table: SET_MR_PAYMENT

Table: SET_MR_RECOVERY

Table: SETAGCPAYMENT

Table: SETAGCRECOVERY

Table: SETAPCCOMPENSATION

Table: SETAPCRECOVERY

Table: SETFCASCOMP

Table: SETFCASRECOVERY

Table: SETGOVPAYMENT

Table: SETGOVRECOVERY

Table: SETINTERVENTION

Table: SETINTERVENTIONRECOVERY

Table: SETIRFMRECOVERY

Table: SETLULOADPAYMENT

Table: SETLULOADRECOVERY

Table: SETLUNLOADPAYMENT

Table: SETLUNLOADRECOVERY

Table: SETRESERVETRADER

Table: SETVICBOUNDARYENERGY

Table: SETVICENERGYFIGURES

Table: SETVICENERGYFLOW

Table: STPASA_SYSTEMSOLUTION

Table: STPASA_UNITSOLUTION

Table: TRADINGLOAD

Table: TRADINGREGIONSUM

Package: PDPASA

Diagram: Entities: PD PASA

Table: PDPASA_CASESOLUTION

Table: PDPASA_CONSTRAINTSOLUTION

Table: PDPASA_INTERCONNECTORSOLN

Table: PDPASA_REGIONSOLUTION

Package: PRUDENTIALS

Diagram: Entities:Prudentials

Table: PRUDENTIALCOMPANYPOSITION

Table: PRUDENTIALRUNTRK

Package: MCC_DISPATCH

Diagram: Entities: MCC_Dispatch

Table: MCC_CASESOLUTION

Table: MCC_CONSTRAINTSOLUTION

Package: NETWORK

Package: VOLTAGE_INSTRUCTIONS

Diagram: Entities: Voltage Instructions

Table: VOLTAGE_INSTRUCTION

Table: VOLTAGE_INSTRUCTION_TRK

Package: PD7DAY

Diagram: Entities: PD7DAY

Table: PD7DAY_CASESOLUTION

Table: PD7DAY_CONSTRAINTSOLUTION

Table: PD7DAY_INTERCONNECTORSOLUTION

Table: PD7DAY_MARKET_SUMMARY

Table: PD7DAY_PRICESOLUTION