pricesensitivities v1

predispatch__pricesensitivities__1

AEMO Description

PREDISPATCHPRICESENSITIVITIES sets out the sensitivity price

Note that the provided table descriptions are truncated by AEMO.

Total Schema Versions 1
Combined Rows 5,509,685
Combined Size 790.09 MiB
MMS Table predispatchpricesensitivities
Unified View nemwebviews.predispatch__pricesensitivities__1

Schema Evolution

Column Type Description 6bcc0d73
DATETIME Nullable(DateTime64(3)) Period date and time ✓
INTERVENTION Nullable(Float64) Flag to indicate if this result set was sourced from the pricing run (INTERVENTION=0) or the physical run (INTERVENTION=1). In the event that there is not intervention in the market, both pricing and physical runs correspond to INTERVENTION=0 ✓
INTERVENTION_ACTIVE Nullable(Float64) Flag to indicate if the sensitivity run contains an active intervention constraint: 0 = No, 1 = Yes ✓
LASTCHANGED Nullable(DateTime64(3)) Last date and time record changed ✓
PERIODID Nullable(Float64) PERIODID is just a period count, starting from 1 for each predispatch run. Use DATETIME to determine half hour period. ✓
PREDISPATCHSEQNO Nullable(Float64) Unique identifier of predispatch run in the form YYYYMMDDPP with 01 at 04:30 ✓
REGIONID LowCardinality(String) Unique region identifier ✓
RRPEEP1 Nullable(Float64) Regional Energy Price for scenario 1 ✓
RRPEEP10 Nullable(Float64) Regional Energy Price for scenario 10 ✓
RRPEEP11 Nullable(Float64) Regional Energy Price for scenario 11 ✓
RRPEEP12 Nullable(Float64) Regional Energy Price for scenario 12 ✓
RRPEEP13 Nullable(Float64) Regional Energy Price for scenario 13 ✓
RRPEEP14 Nullable(Float64) Regional Energy Price for scenario 14 ✓
RRPEEP15 Nullable(Float64) Regional Energy Price for scenario 15 ✓
RRPEEP16 Nullable(Float64) Regional Energy Price for scenario 16 ✓
RRPEEP17 Nullable(Float64) Regional Energy Price for scenario 17 ✓
RRPEEP18 Nullable(Float64) Regional Energy Price for scenario 18 ✓
RRPEEP19 Nullable(Float64) Regional Energy Price for scenario 19 ✓
RRPEEP2 Nullable(Float64) Regional Energy Price for scenario 2 ✓
RRPEEP20 Nullable(Float64) Regional Energy Price for scenario 20 ✓
RRPEEP21 Nullable(Float64) Regional Energy Price for scenario 21 ✓
RRPEEP22 Nullable(Float64) Regional Energy Price for scenario 22 ✓
RRPEEP23 Nullable(Float64) Regional Energy Price for scenario 23 ✓
RRPEEP24 Nullable(Float64) Regional Energy Price for scenario 24 ✓
RRPEEP25 Nullable(Float64) Regional Energy Price for scenario 25 ✓
RRPEEP26 Nullable(Float64) Regional Energy Price for scenario 26 ✓
RRPEEP27 Nullable(Float64) Regional Energy Price for scenario 27 ✓
RRPEEP28 Nullable(Float64) Regional Energy Price for scenario 28 ✓
RRPEEP29 Nullable(Float64) Regional Energy Price for scenario 29 ✓
RRPEEP3 Nullable(Float64) Regional Energy Price for scenario 3 ✓
RRPEEP30 Nullable(Float64) Regional Energy Price for scenario 30 ✓
RRPEEP31 Nullable(Float64) Regional Energy Price for scenario 31 ✓
RRPEEP32 Nullable(Float64) Regional Energy Price for scenario 32 ✓
RRPEEP33 Nullable(Float64) Regional Energy Price for scenario 33 ✓
RRPEEP34 Nullable(Float64) Regional Energy Price for scenario 34 ✓
RRPEEP35 Nullable(Float64) Regional Energy Price for scenario 35 ✓
RRPEEP36 Nullable(Float64) Regional Energy Price for scenario 36 ✓
RRPEEP37 Nullable(Float64) Regional Energy Price for scenario 37 ✓
RRPEEP38 Nullable(Float64) Regional Energy Price for scenario 38 ✓
RRPEEP39 Nullable(Float64) Regional Energy Price for scenario 39 ✓
RRPEEP4 Nullable(Float64) Regional Energy Price for scenario 4 ✓
RRPEEP40 Nullable(Float64) Regional Energy Price for scenario 40 ✓
RRPEEP41 Nullable(Float64) Regional Energy Price for scenario 41 ✓
RRPEEP42 Nullable(Float64) Regional Energy Price for scenario 42 ✓
RRPEEP43 Nullable(Float64) Regional Energy Price for scenario 43 ✓
RRPEEP5 Nullable(Float64) Regional Energy Price for scenario 5 ✓
RRPEEP6 Nullable(Float64) Regional Energy Price for scenario 6 ✓
RRPEEP7 Nullable(Float64) Regional Energy Price for scenario 7 ✓
RRPEEP8 Nullable(Float64) Regional Energy Price for scenario 8 ✓
RRPEEP9 Nullable(Float64) Regional Energy Price for scenario 9 ✓
RUNNO Nullable(Float64) LP Solver Predispatch run no, typically 1. It increments if the case is re-run. ✓
processed_at DateTime64(3) ✓
source_zip String ✓

Schema Versions

Version Rows Size
6bcc0d73 5,509,685 790.09 MiB

Last updated: 2025-12-10 08:00:07