Electricity Data Model Report

Table: AVERAGEPRICE30

AVERAGEPRICE30

Name	AVERAGEPRICE30
Comment	Reflects the 30-minute average price (the pre-5MS trading price).

Content

PERIODDATE

DATE

30-minute interval period, 1 to 48 from the start of the calendar day

REGIONID

VARCHAR2(10)

Region Identifier

PERIODID

NUMBER(3,0)

The 30-minute interval period, 1 to 48

RRP

NUMBER(15,5)

Regional reference price for this period

PRICE_CONFIDENCE

VARCHAR2(20)

Result of Manifestly Incorrect Inputs Price Status and OCD_Status - either "FIRM" or "NOT FIRM". Only FIRM if the Dispatch Interval is resolved for both MII and OCD

LASTCHANGED

DATE

Last date and time record changed

Table: TRADINGINTERCONNECT

TRADINGINTERCONNECT

Name	TRADINGINTERCONNECT
Comment	TRADINGINTERCONNECT shows the Interconnector flows for the 5 minutes Trading Interval. Prior to 5 Minute Settlements, this was the average of the six 5 minute dispatch intervals within the 30 minute period.

Description

TRADINGINTERCONNECT is public data, and is available to all participants.

Source

TRADINGINTERCONNECT is updated half hourly.

Primary Key Columns

INTERCONNECTORID

PERIODID

RUNNO

SETTLEMENTDATE

Content

SETTLEMENTDATE

DATE

Date that this data applies to

RUNNO

NUMBER(3,0)

Dispatch run no.

INTERCONNECTORID

VARCHAR2(10)

Interconnector identifier

PERIODID

NUMBER(3,0)

Period number where 1 represents the trading interval ending at 00:05 AEST

METEREDMWFLOW

NUMBER(15,5)

Average of the metered MW flow from the start of each dispatch interval.

MWFLOW

NUMBER(15,5)

Calculated MW Flow from SPD

MWLOSSES

NUMBER(15,5)

MW losses at calculated MW flow

LASTCHANGED

DATE

Last date and time record changed

TRADINGPRICE sets out 5 minutes spot market price, including fields to handle the Ancillary Services functionality. If prices are adjusted, the final price is recorded in the regional reference price (RRP) field with price before adjustment recorded in the regional original price (ROP) field.
Prior to 5 Minute Settlements, this was half-hourly spot market values, which was calculated as the average of the six 5 minute dispatch intervals within the 30 minute period.

Description

TRADINGPRICE data is public, so is available to all participants.

Source

TRADINGPRICE updates every 30 minutes.

Notes

INVALIDFLAG

The INVALIDFLAG field is used to indicate whether the Trading interval price has been adjusted after the trading interval was completed. On a very restricted set of events, the market rules allow a dispatch price (5 min) to be adjusted on the next business day, and, when this occurs, the corresponding trading interval price for that region is also adjusted and marked as adjusted with INVALIDFLAG of 'A'.

The INVALIDFLAG = 'Y' only applies to historical periods when not all six of the 5-minute dispatch intervals were run in the trading interval. System changes implemented on 30 September 2001 mean this situation no longer occurs since missing dispatch intervals are automatically populated from a previous interval.

If the INVALIDFLAG field = '0', the price was not adjusted and all six dispatch intervals are present.

Prices

There is no field in the TRADINGPRICE table (or the MMS data model anywhere) telling you that the price is provisional or final. The only reliable method is to ensure that the trading date is at least 2 business days old.

Notes

Visibility

Public

Primary Key Columns

PERIODID

REGIONID

RUNNO

SETTLEMENTDATE

Index Columns

LASTCHANGED

Content

SETTLEMENTDATE

DATE

Date that this data applies to

RUNNO

NUMBER(3,0)

Run No

REGIONID

VARCHAR2(10)

Region Identifier

PERIODID

NUMBER(3,0)

Period number where 1 represents the trading interval ending at 00:05 AEST

RRP

NUMBER(15,5)

Regional reference price for this dispatch period

EEP

NUMBER(15,5)

Excess energy price where negative average

INVALIDFLAG

VARCHAR2(1)

Indicates when the Trading interval price has been adjusted after the trading interval was completed

LASTCHANGED

DATE

Last date and time record changed

ROP

NUMBER(15,5)

Regional Original Price. The price before any adjustments were made

RAISE6SECRRP

NUMBER(15,5)

Regional reference price for this dispatch period

RAISE6SECROP

NUMBER(15,5)

Original regional price - prior to APC or VoLL overrides applied

RAISE60SECRRP

NUMBER(15,5)

Regional reference price for this dispatch period

RAISE60SECROP

NUMBER(15,5)

Original regional price - prior to APC or VoLL overrides applied

RAISE5MINRRP

NUMBER(15,5)

Regional reference price for this dispatch period

RAISE5MINROP

NUMBER(15,5)

Original regional price - prior to APC or VoLL overrides applied

RAISEREGRRP

NUMBER(15,5)

Regional reference price for this dispatch period

RAISEREGROP

NUMBER(15,5)

Original regional price - prior to APC or VoLL overrides applied

LOWER6SECRRP

NUMBER(15,5)

Regional reference price for this dispatch period

LOWER6SECROP

NUMBER(15,5)

Original regional price - prior to APC or VoLL overrides applied

LOWER60SECRRP

NUMBER(15,5)

Regional reference price for this dispatch period

LOWER60SECROP

NUMBER(15,5)

Original regional price - prior to APC or VoLL overrides applied

LOWER5MINRRP

NUMBER(15,5)

Regional reference price for this dispatch period

LOWER5MINROP

NUMBER(15,5)

Original regional price - prior to APC or VoLL overrides applied

LOWERREGRRP

NUMBER(15,5)

Regional reference price for this dispatch period

LOWERREGROP

NUMBER(15,5)

Original regional price - prior to APC or VoLL overrides applied

PRICE_STATUS

VARCHAR2(20)

Status of regional prices for this dispatch interval "NOT FIRM" or "FIRM"

RAISE1SECRRP

NUMBER(15,5)

Regional Raise 1Sec Price - R1Price attribute after capping/flooring

RAISE1SECROP

NUMBER(15,5)

Raise1Sec Regional Original Price - uncapped/unfloored and unscaled

LOWER1SECRRP

NUMBER(15,5)

Regional Lower 1Sec Price - RegionSolution element L1Price attribute

LOWER1SECROP

NUMBER(15,5)

Lower1Sec Regional Original Price - uncapped/unfloored and unscaled

Home