Data Model

Your submission populates the Data Model The definition of the interface to participants of data published by AEMO for gas or electricity. A database conforming to the Data Model can contain a local copy of all current participant-specific data recorded in the main database. The Data Model includes database tables, indexes, and primary keys. tables and files mentioned in this section.

 

For help with:

  • The relationships between tables, see the MMS Data Model Report.

  • The relationships between tables and files, see Markets Portal > Data Subscriptions > Data Subscriptions

  • For help with the Data Model and Data Interchange, see Data Interchange Online Help.

Bids package

Table

Purpose

File
BIDOFFERFILETRK Entries are added for each Energy The unit must be a generator for the service type: ‘energy’. Loads cannot bid for mandatory restrictions capacity. or FCAS Frequency Controlled Ancillary Services. A service that balances, over short intervals (shorter than the dispatch interval), the power supplied by generating units and the power consumed by loads. submission whether it is valid or not NEM_BIDS
BIDDAYOFFER Updated for every successful Energy submission NEM_BIDS
BIDOFFERPERIOD Updated with 5-minute Bid/Offer The term Bid relates to the following Dispatch Bids: Energy (Scheduled Loads or Wholesale Demand Response Units). The term Offer relates to the following Dispatch Offers: 1. Energy (Generation Dispatch Offer) 2. Frequency Control Ancillary Service (FCAS) 3. Market Network Service Provider (MNSP - Network Dispatch Offer) information NEM_BIDS
MNSP Market Network Service Provider. A network service provider (NSP) that earns revenue from the spot market._DAYOFFER Updated for every successful MNSP Offer Energy, Dispatch, FCAS Offer, MNSP, MTPASA Bid or Offer submission NEM_BIDS
MNSP_BIDOFFERPERIOD Updated with 5-minute Bid See Relevant Rules or Procedures/Offer information NEM_BIDS

Dispatch package

Table

Purpose

File
DISPATCHOFFERTRK The energy and ancillary service bid tracking table for the Dispatch See National Electricity Rules process DISPATCHIS NEXT_DAY_DISPATCH
DISPATCH_MNSPBIDTRK Shows the MNSP bid tracking, including the bid version used in each dispatch run for each MNSP Interconnector See Relevant Rules or Procedures link DISPATCHIS NEXT_DAY_DISPATCH

Pre_Dispatch package

Table

Purpose

File
PREDISPATCHOFFERTRK The ancillary service bid tracking of Pre-dispatch See Relevant Rules or Procedures processing, identifying the bids applied for a given unit and ancillary service for each Pre-dispatch run NEXT_DAY_PREDISPATCH_D PREDISPATCHIS

Trading_Data package

Table

Purpose

File
AveragePrice30 Reflects the 30-minute average price (the pre-5MS trading price) AVERAGEPRICE30
TRADINGINTERCONNECT Shows the Trading Period The 288 periods from 4:30 am to 4:00 am. summary of Interconnector flows TRADINGIS
TRADINGPRICE Sets out the 5-minute spot market price, including fields to handle the Ancillary Services See Relevant Rules or Procedures functionality. If prices are adjusted, the final price is recorded in the regional reference price (RRP Region Reference Price. Spot price at the regional reference node in $/MWh (exclusive of GST).) field with price before adjustment recorded in the regional original price (ROP) field PRICE_REVISION_TRADINGIS TRADINGIS

Non-data model

Table

Purpose

File
BIDDAYOFFER_D Public summary of the energy and FCAS offers applicable in Dispatch for the intervals identified BIDMOVE_COMPLETE
BIDPEROFFER_D Public summary of the energy and FCAS offers applicable in Dispatch for the intervals identified BIDMOVE_COMPLETE

Display of decimals in reports and tables

Reports display values up to eight decimal places. When the data loads into a Data Model table, it truncates to five decimal places. For example, in the AS_PAYMENTS_SUMMARY report, the value displayed is 200.00000000. In the BILLINGASPAYMENTS table, it is 200.00000.