HISTORICAL TABLES

These tables are no longer used

Tables

This package contains the following tables:

Name	Description
APCCOMP	APCCOMP is to set out Administered Price Cap (APC) compensation periods for a participant.
APCCOMPAMOUNT	APCCOMPAMOUNT shows the Administered Price Cap (APC) compensation amount.
APCCOMPAMOUNTTRK	APCCOMPAMOUNTTRK sets out the relevant Administered Price Cap (APC) period for compensation purposes. Use the APCCOMPAMOUNTTRK table in conjunction with APCAMOUNT.
BIDPEROFFER	BIDPEROFFER shows period-based Energy and Ancillary Service bid data. BIDPEROFFER is a child table of BIDDAYOFFER.
BILLADJUSTMENTS
BILLING_CSP_DEROGATION_AMOUNT	CSP derogation amounts with respect to participant allocated payment
BILLING_DIRECTION_RECONCILIATN	Billing reconciliation result table for both provisional and final directions using the FPP methodology (prior to 1st July 2011)
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_RES_TRADER_PAYMENT	Billing result table for reserve trader contract payments
BILLING_RES_TRADER_RECOVERY	Billing result table for reserve trader contract recovery
BILLINGCPDATA	BILLINGCPDATA shows energy quantity and $ value purchased per participant connection point. The table is populated for participants using Data Model 5.2. For participants using Data Model 5.3 or higher, BILLING_ENERGY_TRANSACTIONS AND BILLING_ENERGY_GENSET_DETAIL replace BILLINGCPDATA.
BILLINGCPSUM	BILLINGCPSUM shows adjustments for a billing run by participant.
BILLINGCUSTEXCESSGEN	BILLINGCUSTEXCESSGEN shows excess generation payments for each participant cutover.
BILLINGEXCESSGEN	BILLINGEXCESSGEN shows the excess generation cost by period for each participant.
BILLINGGENDATA	BILLINGGENDATA shows the total energy sold and purchased per participant transmission connection point for a billing period. The table is populated for participants using Data Model 5.2. For participants using Data Model 5.3 or higher, BILLING_ENERGY_TRANSACTIONS AND BILLING_ENERGY_GENSET_DETAIL replace BILLINGGENDATA.
BILLINGINTERVENTION	BILLINGINTERVENTION shows billing intervention recovery details.
BILLINGINTERVENTIONREGION	BILLINGINTERVENTIONREGION shows recovery charges for region intervention.
BILLINGRESERVERECOVERY	BILLINGRESERVERECOVERY shows Market Reserve recovery details for each participant in a bill run.
BILLINGRESERVEREGIONRECOVERY	BILLINGRESERVEREGIONRECOVERY shows Billing Region Reserve region recovery details for each participant (by region).
BILLINGRESERVETRADER	BILLINGRESERVETRADER shows Billing Market Reserve TRADER payment details to Generators.
BILLINGRESERVETRADERREGION	BILLINGRESERVETRADERREGION shows Billing Region Reserve Trader payment details.
BILLINGSMELTERREDUCTION	BILLINGSMELTERREDUCTION shows the smelter reduction payment (only applies to participants with Victorian customer connection points).
BILLINTERVENTIONRECOVERY	BILLINTERVENTIONRECOVERY shows billing market intervention recovery details for each participant.
BILLINTERVENTIONREGIONRECOVERY	BILLINTERVENTIONREGIONRECOVERY shows billing region intervention recovery details for each participant by region.
BILLSMELTERRATE	BILLSMELTERRATE is standing data, setting out the rates used in smelter reduction calculations.
CONNECTIONPOINT	CONNECTIONPOINT shows all valid connection points and their type. Transmission loss factors are available for all connection points in TRANSMISSIONLOSSFACTOR.
CONNECTIONPOINTDETAILS	CONNECTIONPOINTDETAILS is obsolete, since it was never populated by Participants accessing AEMO's Oracle Interface. CONNECTIONPOINTDETAILS was designed to show relevant details for each connection point including the responsible party, loss factor and relevant MDAs.
CONNECTIONPOINTOPERATINGSTA	CONNECTIONPOINTOPERATINGSTA shows whether a connection point is active or not.
CONTRACTGOVERNOR	CONTRACTGOVERNOR became unused when Ancillary Services Review was implemented in 2001. For more details, see Change Notice 126. CONTRACTGOVERNOR shows Governor contract details used in the settlement and dispatch of this service. Note services are dispatched as 6 and 60 raise and lower Frequency Control Ancillary Services (FCAS). Lower and raise 6 and 60 second fields are used in dispatch of services. Deadband and Droop details are used in settlements.
CONTRACTRESERVEFLAG	CONTRACTRESERVEFLAG has never been or will be used. It was to show a period by period flag for regional or market recovery of reserve trading contract amounts.
CONTRACTRESERVETHRESHOLD	CONTRACTRESERVETHRESHOLD shows reserve contract threshold details for enabling, usage and availability thresholds and rates for reserve trader contracts.
CONTRACTRESERVETRADER	CONTRACTRESERVETRADER shows reserve trader contract details. Version numbers do not apply as contracts exist for specified purposes.
CONTRACTUNITLOADING	CONTRACTUNITLOADING became unused when Ancillary Services Review was implemented in 2001. For more details, see Change Notice 126. CONTRACTUNITLOADING shows Unit Loading contract details used in the settlement and dispatch of this service.
CONTRACTUNITUNLOADING	CONTRACTUNITUNLOADING shows Ancillary Service contract data for rapid generator unit unloading.
DAYOFFER	DAYOFFER sets out the participants’ daily components of participant bid containing details applying for the whole day (such as prices, daily energy constraint and fast start profiles). To retrieve full bid details, read in conjunction with PEROFFER.
DAYOFFER_D	DAYOFFER_D sets out the participants’ daily components of participant bid containing just the latest details (such as prices, daily energy constraint and fast start profiles). To retrieve latest bid details, read in conjunction with PEROFFER_D.
DEFAULTDAYOFFER	DEFAULTDAYOFFER shows day-based details of participants’ default bids unit for the same day.
DEFAULTOFFERTRK	DEFAULTOFFERTRK shows the file names of default offers submitted for each unit.
DEFAULTPEROFFER	DEFAULTPEROFFER shows half hourly period-based data in the default bid for each Dispatchable Unit, such as period availability, rate of change and band quantities.
DELTAMW	DELTAMW sets out the Frequency Control Ancillary Services (FCAS) requirement to be provided locally within each region and each half-hour period in a market day. Two fields specify Frequency Controlled Ancillary Services requirements to be provided locally for the new regulation ancillary services.
DISPATCH_FCAS_REQ	DISPATCH_FCAS_REQ shows Dispatch Constraint tracking for Regional FCAS recovery.
DISPATCHBIDTRK	DISPATCHBIDTRK shows the bid tracking, including the bid version used in each dispatch run for each unit. DISPATCHBIDTRK is the audit trail of the bid actually used in each dispatch.
DISPATCHCASE_OCD	DISPATCHCASE_OCD shows the key data to indicate when an over-constrained dispatch (OCD) re-run actually occurred. One record per over-constrained dispatch interval.
DISPATCHCASESOLUTION_BNC	DISPATCHCASESOLUTION_BNC was discontinued on 30 September 2009. Prior: DISPATCHCASESOLUTION_BNC is the key data to indicate when a binding intra-regional network constraints (BNC) re-run actually occurred.
DISPATCHLOAD_BNC	DISPATCHLOAD_BNC was discontinued on 30 September 2009. Prior: DISPATCHLOAD_BNC gives binding intra-regional network constraints (BNC) re-run dispatch results for all scheduled generating units. DISPATCHLOAD_BNC has a similar structure to DISPATCHLOAD but does not repeat input type data (e.g. InitialMW, AGCStatus) since these values are available from DISPATCHLOAD.
DISPATCHTRK	DISPATCHTRK is no longer used. DISPATCHTRK was the cross-reference between each dispatch run and SPD case run. DISPATCHTRK may be available on the InfoServer but not replicated to participant databases as it contains data duplicated in other tables.
FORCEMAJEURE	FORCEMAJEURE used to set out the start and end dates / periods of any force majeure event. FORCEMAJEURE is not used.
FORCEMAJEUREREGION	FORCEMAJEUREREGION used to set out regions impacted by a force majeure event. This table is not used.
GENUNITMTRINPERIOD	GENUNITMTRINPERIOD shows meter reading by period for each generator meter. GENUNITMTRINPERIOD covers generated power flowing into the system. It is used to calculate settlement values.
INTCONTRACT	INTCONTRACT shows intervention contract details. These are specific to each intervention.
INTCONTRACTAMOUNT	INTCONTRACTAMOUNT shows intervention contract amounts.
INTCONTRACTAMOUNTTRK	INTCONTRACTAMOUNTTRK shows the latest valid version of each intervention contract.
INTERCONNMWFLOW	INTERCONNMWFLOW shows Metered Interconnector flow data. INTERCONNMWFLOW shows the meter data provided by Meter Data Providers to MSATS. Despite the name, this view shows metered energy (MWh) and not power flow (MW).
MARKETSUSPENSION	MARKETSUSPENSION is obsolete from 2017 End of Year DM4.27 Release. MARKETSUSPENSION sets out a start and end periods of any market suspension and the reason.
MARKETSUSREGION	MARKETSUSREGION is obsolete from 2017 End of Year DM4.27 Release. MARKETSUSREGION sets out a regions affected by a market suspension.
MAS_CP_CHANGE	MAS_CP_CHANGE records pending changes to the current MAS configuration.
MAS_CP_MASTER	MAS_CP_MASTER shows the current MAS configuration.
METERDATA	METERDATA sets out a meter data for each customer connection point. METERDATA covers market load. Use the field METERRUNNO to match the meter data version for each settlement run.
METERDATA_GEN_DUID	Recorded actual generation of non-scheduled units where SCADA data is available.
METERDATA_TRK	Tracking table for the publication of wholesale settlement data associated with BILLING run
METERDATATRK	METERDATATRK records meter data files submitted for each connection point on a daily basis. The same data is provided in METERDATA period by period (i.e. 48 records), whereas METERDATATRK shows one record per day for each file submitted for a connection point.
MNSP_FILETRK	MNSP_FILETRK shows all MNSPOFFERS transmitted to the MMS system.
MNSP_OFFERTRK	MNSP_OFFERTRK records all valid MNSPOFFERS loaded into the MMS system. The authorised date reflects the date and time of the load. MNSP_OFFERTRK is key for tracking MNSP bid submission.
MNSP_PEROFFER	MNSP_PEROFFER shows period by period availability and other period data pertaining to a specific bid and LinkID for the given Settlement Date. MNSP_PEROFFER is a child to MNSP_DAYOFFER and links to MNSP_OFFERTRK.
MR_DAYOFFER_STACK	MR_DAYOFFER_STACK defines the Stack order for each version of the Acceptance Schedule, including all units submitting MR offers for that event. MR_DAYOFFER_STACK is the child to MR_EVENT_SCHEDULE, and parent to MR_PEROFFER_STACK.
MR_EVENT	MR_EVENT defines an MR Event for a given region on a specific trading date.
MR_EVENT_SCHEDULE	MR_EVENT_SCHEDULE defines the Stack version of the Acceptance Schedule and is the parent table to MR_DayOffer_Stack and MR_PerOffer_Stack.
MR_PEROFFER_STACK	MR_PEROFFER_STACK defines the accepted capacity on a period basis for the Acceptance Schedule, is a child table to MR_DayOffer_Stack and only includes records or units with accepted_capacity > 0 for the specific period.
MTPASA_CASE_SET	MTPASA_CASE_SET is obsolete from 2005 End of Year Release. The RUNTYPE added to the primary key of the detail tables for MTPASA allows for the different types of runs for each case. MTPASA_CASE_SET allows a MT PASA scenario to be linked across runs.
MTPASA_CASESOLUTION	MTPASA_CASESOLUTION is obsolete from 2017 End of Year DM4.27 Release. MTPASA_CASESOLUTION holds one record for each entire solution. Change Notice 379 announced the replacement of the MT PASA data model so all MTPASAxxx tables become obsolete, replaced by MTPASA_xxx tables.
MTPASA_CONSTRAINTSOLUTION	MTPASA_CONSTRAINTSOLUTION is obsolete from 2017 End of Year DM4.27 Release. The MTPASA_CONSTRAINTSOLUTION table holds the binding and violated constraint results from the capacity evaluation, including the RHS value. Change Notice 379 announced the replacement of the MT PASA data model so all MTPASAxxx tables become obsolete, replaced by MTPASA_xxx tables.
MTPASA_INTERCONNECTORSOLUTION	MTPASA_INTERCONNECTORSOLUTION is obsolete from 2017 End of Year DM4.27 Release. The MTPASA_INTERCONNECTORSOLUTION table shows the results of the capacity evaluation for Interconnectors, including the calculated limits for the ldcblock within the day. Change Notice 379 announced the replacement of the MT PASA data model so all MTPASAxxx tables become obsolete, replaced by MTPASA_xxx tables (see Change Notices 400, 400a and 400b).
MTPASA_REGIONSOLUTION	MTPASA_CASESOLUTION is obsolete from 2017 End of Year DM4.27 Release. The MTPASA_REGIONSOLUTION table shows the results of the regional capacity, maximum surplus reserve and maximum spare capacity evaluations for each day and ldcblock of the study.
MTPASA_RESERVELIMITSOLUTION	MTPASA_RESERVELIMITSOLUTION is obsolete from 2017 End of Year DM4.27 Release. MT PASA Solution table reporting whether a MT PASA Reserve requirement is binding for each day and LDC block of the run.
MTPASACONSTRAINTSOLUTION_D	MTPASACONSTRAINTSOLUTION_D sets out MT PASA constraint solution results, where constraints are binding.
MTPASAINTERCONNECTORSOLUTION_D	MTPASAINTERCONNECTORSOLUTION_D shows interconnector results for MT PASA, shown region by region.
MTPASAREGIONSOLUTION_D	MTPASAREGIONSOLUTION_D shows region results for MT PASA, showing predicted demand and any capacity limits.
OARTRACK	OARTRACK shows an audit trail of bids for a particular settlement day. Corrupt bids do not update OARTRACK, but are just in OFFERFILETRK.
OFFERFILETRK	OFFERFILETRK shows an audit trail of all bid files submitted containing energy bids, including corrupt bids/rebids.
OFFERGOVDATA	OFFERGOVDATA sets out reoffers of governor (6 and 60 second FCAS) availability.
OFFERULOADINGDATA	OFFERULOADINGDATA shows reoffers of rapid unit loading capability.
OFFERUNLOADINGDATA	OFFERUNLOADINGDATA shows reoffers of rapid unit unloading capability.
P5MIN_FCAS_REQUIREMENT	5-minute Predispatch constraint tracking for Regional FCAS recovery
PASACASESOLUTION	PASACASESOLUTION sets out ST PASA case listing providing details of each STPASA case run.
PASACONSTRAINTSOLUTION	PASACONSTRAINTSOLUTION records the latest binding STPASA constraint details for each period. For each solution, the latest recalculation for each period overwrites the previous entry.
PASAINTERCONNECTORSOLUTION	PASAINTERCONNECTORSOLUTION records ST PASA interconnector solutions for the latest period.
PASAREGIONSOLUTION	PASAREGIONSOLUTION shows the Regional solution for ST PASA showing reserves for each half-hour period. This table (PASAREGIONSOLUTION_D) shows the latest calculated result for each period.
PEROFFER	PEROFFER contains the half-hourly period details of daily bids and rebids, to be used in conjunction with DAYOFFER. These views provide period varying details such as rate of change up (ROCUP), rate of change down (ROCDOWN) and band quantities (BANDAVAIL from 1 to 10). PEROFFER is a child table of DAYOFFER.
PEROFFER_D	PEROFFER_D contains the half-hourly period details of daily bids and rebids, to be used in conjunction with DAYOFFER_D. These views provide period varying details such as rate of change up (ROCUP), rate of change down (ROCDOWN) and band quantities (BANDAVAIL from 1 to 10). PEROFFER_D is a child table of DAYOFFER_D.
PREDISPATCH_FCAS_REQ	PREDISPATCH_FCAS_REQ shows Predispatch Constraint tracking for Regional FCAS Requirements.
PREDISPATCHBIDTRK	PREDISPATCHBIDTRK contains an audit trail of bids used in each predispatch run. Where predispatch is over 2 days, two bids are listed.
REALLOCATIONDETAILS	REALLOCATIONDETAILS sets out specific reallocation agreements.
REALLOCATIONINTERVALS	REALLOCATIONINTERVALS identifies the the reallocation agreement and provides the corresponding reallocation profiles submitted by the participant and accepted by AEMO
REALLOCATIONS	REALLOCATIONS shows reallocation agreement identifiers with corresponding start and end dates of submitted reallocations as accepted by AEMO.
REGIONFCASRELAXATION_OCD	REGIONFCASRELAXATION_OCD contains details of regional FCAS requirements relaxed in the over-constrained dispatch (OCD) re-run (if there was one). Note: INTERVENTION is not included in REGIONFCASRELAXATION_OCD since the relaxation of the FCAS requirement is the same amount in both intervened and non-intervened cases.
RESERVE	RESERVE sets out specific reserve requirements for dispatch, predispatch and STPASA, for each half-hour interval by region. Updates show as new versions for a date.
SET_CSP_DEROGATION_AMOUNT	A settlement table for the publication of Snowy CSP derogation amounts.
SET_CSP_SUPPORTDATA_CONSTRAINT	A settlements table for the publication of support data for the Snowy CSP derogation amounts. This table publishes the constraint-level information for each five minute interval in the settlement run
SET_CSP_SUPPORTDATA_ENERGYDIFF	A settlements table for the publication of support data for the Snowy CSP derogation amounts. This table publishes energy differential information for each half-hour interval in the settlement run
SET_CSP_SUPPORTDATA_SUBPRICE	A settlements table for the publication of support data for the Snowy CSP derogation amounts. This table publishes substitution price information for each five minute interval in the settlement run
SET_MR_PAYMENT	SET_MR_PAYMENT shows trading interval payments on a dispatchable unit basis for accepted MR capacity.
SET_MR_RECOVERY	SET_MR_RECOVERY shows the trading interval recovery charges on a dispatchable unit basis for spot market income from dispatch of MR capacity.
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).
SETAGCPAYMENT	SETAGCPAYMENT sets out specific payment details for Automatic Generation Control (AGC) services by period.
SETAGCRECOVERY	SETAGCRECOVERY shows reimbursements for Automatic Generation Control (AGC) Ancillary Services to be recovered from participants.
SETAPCCOMPENSATION	SETAPCCOMPENSATION shows Administered Price Cap (APC) compensation payments for each period.
SETAPCRECOVERY	SETAPCRECOVERY shows reimbursements for Administered Price Cap (APC) to be recovered from participants.
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. The table is populated for participants using Data Model 5.2. For participants using Data Model 5.3 or higher, SET_ENERGY_TRANSACTIONS and SET_ENERGY_GENSET_DETAIL replace SETCPDATA.
SETCPDATAREGION	SETCPDATAREGION sets out summary meter settlement data for each region. The table is populated for participants using Data Model 5.2. For participants using Data Model 5.3 or higher, SET_ENERGY_REGION_SUMMARY replace SETCPDATAREGION.
SETFCASCOMP	SETFCASCOMP shows the compensation details for Frequency Controlled Ancillary Services (FCAS). These compensation values are calculated by a separate “what if” run of the LP Solver and entered as an unconstrained MW value into settlements.
SETFCASRECOVERY	SETFCASERECOVERY shows reimbursements for the Frequency Control Ancillary Services compensation.
SETGENDATA	SETGENDATA shows meter settlement data for each generation meter point. A regional summary is also provided. The table is populated for participants using Data Model 5.2. For participants using Data Model 5.3 or higher, SET_ENERGY_TRANSACTIONS and SET_ENERGY_GENSET_DETAIL replace SETGENDATA.
SETGENDATAREGION	SETGENDATAREGION sets out summary settlement data for generation within the specified region. The table is populated for participants using Data Model 5.2. For participants using Data Model 5.3 or higher, SET_ENERGY_REGION_SUMMARY replace SETGENDATAREGION.
SETGOVPAYMENT	SETGOVPAYMENTshows specific payment details for Governor services by period.
SETGOVRECOVERY	SETGOVRECOVERY shows reimbursements for the Governor Ancillary Services to be recovered from participants.
SETINTERVENTION	SETINTERVENTION shows intervention settlement payment details by unit.
SETINTERVENTIONRECOVERY	SETINTERVENTIONRECOVERY shows intervention recovery details by participant.
SETIRFMRECOVERY	SETIRFMRECOVERY sets out reimbursements for Industrial Relations Force Majeure to be recovered from participants.
SETLULOADPAYMENT	SETLULOADPAYMENT shows specific payment details for rapid unit load services by period.
SETLULOADRECOVERY	SETLULOADRECOVERY shows reimbursements for rapid-unit-load Ancillary Services to be recovered from participants.
SETLUNLOADPAYMENT	SETLUNLOADPAYMENT shows specific payment details for rapid unit unload service.
SETLUNLOADRECOVERY	SETLUNLOADRECOVERY shows reimbursements for rapid unit unloading Ancillary Services to be recovered from participants.
SETRESERVETRADER	SETRESERVETRADER shows reserve trader details.
SETSMALLGENDATA	Publishes metering data and associated settlement values for with registered Small Generator Aggregator participants connection points. The table is populated for participants using Data Model 5.2. For participants using Data Model 5.3 or higher, SET_ENERGY_TRANSACTIONS and SET_ENERGY_GENSET_DETAIL replace SETSMALLGENDATA.
SETVICBOUNDARYENERGY	SETVICBOUNDARYENERGY is as requested by Participants for the settlement of Victorian Vesting contracts.
SETVICENERGYFIGURES	SETVICENERGYFIGURES is used in settlement of Victorian Vesting contracts.
SETVICENERGYFLOW	SETVICENERGYFLOW is used in settlement of Victorian Vesting contracts.
STPASA_SYSTEMSOLUTION	STPASA_SYSTEMSOLUTION is obsolete from 2005 End of Year Release. For solution information, see Region solution tables. STPASA_SYSTEMSOLUTION showed the results of the system capacity evaluations for each interval of the study.
STPASA_UNITSOLUTION	STPASA_UNITSOLUTION shows the unit results from the capacity evaluations for each period of the study.
TRADINGLOAD	TRADINGLOAD shows half-hourly average dispatch levels, including fields to handle the Ancillary Services functionality.
TRADINGREGIONSUM	TRADINGREGIONSUM sets out the half-hourly average regional demand and frequency control services. TRADINGREGIONSUM includes fields for the Raise Regulation and Lower Regulation Ancillary Services plus improvements to demand calculations.

Diagram

Links

Package Documentation

Copy as Markdown