predispatch__region_solution

AEMO Description

REGION sets out valid region IDs.

Note that the provided table descriptions are truncated by AEMO.


Total Schema Versions	2
Combined Rows	8,452,635
Combined Size	1018.63 MiB
MMS Table	`region`
Unified View	`nemwebviews.predispatch__region_solution`

Schema Evolution

Column	Type	Description	72de8ea1	eefb66a4
`AVAILABLEGENERATION`	`Nullable(Float64)`		✓	✓
`AVAILABLELOAD`	`Nullable(Float64)`		✓	✓
`BDU_CLEAREDMW_GEN`	`Nullable(Float64)`		✓	✓
`BDU_CLEAREDMW_LOAD`	`Nullable(Float64)`		✓	✓
`BDU_ENERGY_STORAGE`	`Nullable(Float64)`		✓	✓
`BDU_INITIAL_ENERGY_STORAGE`	`Nullable(Float64)`		✓	-
`BDU_MAX_AVAIL`	`Nullable(Float64)`		✓	✓
`BDU_MIN_AVAIL`	`Nullable(Float64)`		✓	✓
`CLEAREDSUPPLY`	`Nullable(Float64)`		✓	✓
`DATETIME`	`Nullable(DateTime64(3))`		✓	✓
`DECAVAILABILITY`	`Nullable(Float64)`		✓	✓
`DECGEN_INITIAL_ENERGY_STORAGE`	`Nullable(Float64)`		✓	-
`DEMANDFORECAST`	`Nullable(Float64)`		✓	✓
`DEMAND_AND_NONSCHEDGEN`	`Nullable(Float64)`		✓	✓
`DISPATCHABLEGENERATION`	`Nullable(Float64)`		✓	✓
`DISPATCHABLELOAD`	`Nullable(Float64)`		✓	✓
`EXCESSGENERATION`	`Nullable(Float64)`		✓	✓
`INITIALSUPPLY`	`Nullable(Float64)`		✓	✓
`INTERVENTION`	`Nullable(Float64)`		✓	✓
`LASTCHANGED`	`Nullable(DateTime64(3))`	Last date and time record changed	✓	✓
`LORSURPLUS`	`Nullable(Float64)`		✓	✓
`LOWER1SECACTUALAVAILABILITY`	`Nullable(Float64)`		✓	✓
`LOWER1SECLOCALDISPATCH`	`Nullable(Float64)`		✓	✓
`LOWER5MINACTUALAVAILABILITY`	`Nullable(Float64)`		✓	✓
`LOWER5MINDISPATCH`	`Nullable(Float64)`		✓	✓
`LOWER5MINIMPORT`	`Nullable(Float64)`		✓	✓
`LOWER5MINLOCALDISPATCH`	`Nullable(Float64)`		✓	✓
`LOWER5MINLOCALPRICE`	`Nullable(Float64)`		✓	✓
`LOWER5MINLOCALREQ`	`Nullable(Float64)`		✓	✓
`LOWER5MINLOCALVIOLATION`	`Nullable(Float64)`		✓	✓
`LOWER5MINPRICE`	`Nullable(Float64)`		✓	✓
`LOWER5MINREQ`	`Nullable(Float64)`		✓	✓
`LOWER5MINSUPPLYPRICE`	`Nullable(Float64)`		✓	✓
`LOWER5MINVIOLATION`	`Nullable(Float64)`		✓	✓
`LOWER60SECACTUALAVAILABILITY`	`Nullable(Float64)`		✓	✓
`LOWER60SECDISPATCH`	`Nullable(Float64)`		✓	✓
`LOWER60SECIMPORT`	`Nullable(Float64)`		✓	✓
`LOWER60SECLOCALDISPATCH`	`Nullable(Float64)`		✓	✓
`LOWER60SECLOCALPRICE`	`Nullable(Float64)`		✓	✓
`LOWER60SECLOCALREQ`	`Nullable(Float64)`		✓	✓
`LOWER60SECLOCALVIOLATION`	`Nullable(Float64)`		✓	✓
`LOWER60SECPRICE`	`Nullable(Float64)`		✓	✓
`LOWER60SECREQ`	`Nullable(Float64)`		✓	✓
`LOWER60SECSUPPLYPRICE`	`Nullable(Float64)`		✓	✓
`LOWER60SECVIOLATION`	`Nullable(Float64)`		✓	✓
`LOWER6SECACTUALAVAILABILITY`	`Nullable(Float64)`		✓	✓
`LOWER6SECDISPATCH`	`Nullable(Float64)`		✓	✓
`LOWER6SECIMPORT`	`Nullable(Float64)`		✓	✓
`LOWER6SECLOCALDISPATCH`	`Nullable(Float64)`		✓	✓
`LOWER6SECLOCALPRICE`	`Nullable(Float64)`		✓	✓
`LOWER6SECLOCALREQ`	`Nullable(Float64)`		✓	✓
`LOWER6SECLOCALVIOLATION`	`Nullable(Float64)`		✓	✓
`LOWER6SECPRICE`	`Nullable(Float64)`		✓	✓
`LOWER6SECREQ`	`Nullable(Float64)`		✓	✓
`LOWER6SECSUPPLYPRICE`	`Nullable(Float64)`		✓	✓
`LOWER6SECVIOLATION`	`Nullable(Float64)`		✓	✓
`LOWERREGACTUALAVAILABILITY`	`Nullable(Float64)`		✓	✓
`LOWERREGIMPORT`	`Nullable(Float64)`		✓	✓
`LOWERREGLOCALDISPATCH`	`Nullable(Float64)`		✓	✓
`LOWERREGLOCALREQ`	`Nullable(Float64)`		✓	✓
`LOWERREGLOCALVIOLATION`	`Nullable(Float64)`		✓	✓
`LOWERREGREQ`	`Nullable(Float64)`		✓	✓
`LOWERREGVIOLATION`	`Nullable(Float64)`		✓	✓
`LRCSURPLUS`	`Nullable(Float64)`		✓	✓
`NETINTERCHANGE`	`Nullable(Float64)`		✓	✓
`PERIODID`	`Nullable(Float64)`		✓	✓
`PREDISPATCHSEQNO`	`Nullable(Float64)`		✓	✓
`RAISE1SECACTUALAVAILABILITY`	`Nullable(Float64)`		✓	✓
`RAISE1SECLOCALDISPATCH`	`Nullable(Float64)`		✓	✓
`RAISE5MINACTUALAVAILABILITY`	`Nullable(Float64)`		✓	✓
`RAISE5MINDISPATCH`	`Nullable(Float64)`		✓	✓
`RAISE5MINIMPORT`	`Nullable(Float64)`		✓	✓
`RAISE5MINLOCALDISPATCH`	`Nullable(Float64)`		✓	✓
`RAISE5MINLOCALPRICE`	`Nullable(Float64)`		✓	✓
`RAISE5MINLOCALREQ`	`Nullable(Float64)`		✓	✓
`RAISE5MINLOCALVIOLATION`	`Nullable(Float64)`		✓	✓
`RAISE5MINPRICE`	`Nullable(Float64)`		✓	✓
`RAISE5MINREQ`	`Nullable(Float64)`		✓	✓
`RAISE5MINSUPPLYPRICE`	`Nullable(Float64)`		✓	✓
`RAISE5MINVIOLATION`	`Nullable(Float64)`		✓	✓
`RAISE60SECACTUALAVAILABILITY`	`Nullable(Float64)`		✓	✓
`RAISE60SECDISPATCH`	`Nullable(Float64)`		✓	✓
`RAISE60SECIMPORT`	`Nullable(Float64)`		✓	✓
`RAISE60SECLOCALDISPATCH`	`Nullable(Float64)`		✓	✓
`RAISE60SECLOCALPRICE`	`Nullable(Float64)`		✓	✓
`RAISE60SECLOCALREQ`	`Nullable(Float64)`		✓	✓
`RAISE60SECLOCALVIOLATION`	`Nullable(Float64)`		✓	✓
`RAISE60SECPRICE`	`Nullable(Float64)`		✓	✓
`RAISE60SECREQ`	`Nullable(Float64)`		✓	✓
`RAISE60SECSUPPLYPRICE`	`Nullable(Float64)`		✓	✓
`RAISE60SECVIOLATION`	`Nullable(Float64)`		✓	✓
`RAISE6SECACTUALAVAILABILITY`	`Nullable(Float64)`		✓	✓
`RAISE6SECDISPATCH`	`Nullable(Float64)`		✓	✓
`RAISE6SECIMPORT`	`Nullable(Float64)`		✓	✓
`RAISE6SECLOCALDISPATCH`	`Nullable(Float64)`		✓	✓
`RAISE6SECLOCALPRICE`	`Nullable(Float64)`		✓	✓
`RAISE6SECLOCALREQ`	`Nullable(Float64)`		✓	✓
`RAISE6SECLOCALVIOLATION`	`Nullable(Float64)`		✓	✓
`RAISE6SECPRICE`	`Nullable(Float64)`		✓	✓
`RAISE6SECREQ`	`Nullable(Float64)`		✓	✓
`RAISE6SECSUPPLYPRICE`	`Nullable(Float64)`		✓	✓
`RAISE6SECVIOLATION`	`Nullable(Float64)`		✓	✓
`RAISEREGACTUALAVAILABILITY`	`Nullable(Float64)`		✓	✓
`RAISEREGIMPORT`	`Nullable(Float64)`		✓	✓
`RAISEREGLOCALDISPATCH`	`Nullable(Float64)`		✓	✓
`RAISEREGLOCALREQ`	`Nullable(Float64)`		✓	✓
`RAISEREGLOCALVIOLATION`	`Nullable(Float64)`		✓	✓
`RAISEREGREQ`	`Nullable(Float64)`		✓	✓
`RAISEREGVIOLATION`	`Nullable(Float64)`		✓	✓
`REGIONID`	`LowCardinality(String)`	Differentiates this region from all other regions	✓	✓
`RUNNO`	`Nullable(Float64)`		✓	✓
`SEMISCHEDULE_CLEAREDMW`	`Nullable(Float64)`		✓	✓
`SEMISCHEDULE_COMPLIANCEMW`	`Nullable(Float64)`		✓	✓
`SS_SOLAR_AVAILABILITY`	`Nullable(Float64)`		✓	✓
`SS_SOLAR_CLEAREDMW`	`Nullable(Float64)`		✓	✓
`SS_SOLAR_COMPLIANCEMW`	`Nullable(Float64)`		✓	✓
`SS_SOLAR_UIGF`	`Nullable(Float64)`		✓	✓
`SS_WIND_AVAILABILITY`	`Nullable(Float64)`		✓	✓
`SS_WIND_CLEAREDMW`	`Nullable(Float64)`		✓	✓
`SS_WIND_COMPLIANCEMW`	`Nullable(Float64)`		✓	✓
`SS_WIND_UIGF`	`Nullable(Float64)`		✓	✓
`TOTALDEMAND`	`Nullable(Float64)`		✓	✓
`TOTALINTERMITTENTGENERATION`	`Nullable(Float64)`		✓	✓
`UIGF`	`Nullable(Float64)`		✓	✓
`WDR_AVAILABLE`	`Nullable(Float64)`		✓	✓
`WDR_DISPATCHED`	`Nullable(Float64)`		✓	✓
`WDR_INITIALMW`	`Nullable(Float64)`		✓	✓
`processed_at`	`DateTime64(3)`		✓	✓
`source_zip`	`String`		✓	✓

Schema Versions

Version	Rows	Size
`72de8ea1`	5,075,295	634.82 MiB
`eefb66a4`	3,377,340	383.81 MiB

Last updated: 2026-07-16 05:00:10

region_prices v2 region_solution v8