MMS Data Model Report

Package: HISTORICAL TABLES

Name	HISTORICAL TABLES
Comment	These tables are no longer used

List of tables

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.

BILLADJUSTMENTS

BILLING_CSP_DEROGATION_AMOUNT

CSP derogation amounts with respect to participant allocated payment

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.

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.

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.

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.

1 2

Home