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