dregion____2

AEMO Description

REGION sets out valid region IDs.

Note that the provided table descriptions are truncated by AEMO.


Total Schema Versions	2
Combined Rows	1,150,615
Combined Size	77.75 MiB
MMS Table	`region`
Unified View	`nemwebviews.dregion____2`

Schema Evolution

Column	Type	Description	7876f6a6	7f0a7ee7
`AGGREGATEDISPATCHERROR`	`Nullable(Float64)`		✓	✓
`APCFLAG`	`Nullable(Float64)`		✓	✓
`AVAILABLEGENERATION`	`Nullable(Float64)`		✓	✓
`AVAILABLELOAD`	`Nullable(Float64)`		✓	✓
`CLEAREDSUPPLY`	`Nullable(Float64)`		✓	✓
`DEMANDFORECAST`	`Nullable(Float64)`		✓	✓
`DISPATCHABLEGENERATION`	`Nullable(Float64)`		✓	✓
`DISPATCHABLELOAD`	`Nullable(Float64)`		✓	✓
`EEP`	`Nullable(Float64)`		✓	✓
`EXCESSGENERATION`	`Nullable(Float64)`		✓	✓
`INITIALSUPPLY`	`Nullable(Float64)`		✓	✓
`INTERVENTION`	`Nullable(Float64)`		✓	✓
`LOWER1SECAPCFLAG`	`Nullable(Float64)`		✓	-
`LOWER1SECLOCALDISPATCH`	`Nullable(Float64)`		✓	-
`LOWER1SECROP`	`Nullable(Float64)`		✓	-
`LOWER1SECRRP`	`Nullable(Float64)`		✓	-
`LOWER5MINAPCFLAG`	`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)`		✓	✓
`LOWER5MINROP`	`Nullable(Float64)`		✓	✓
`LOWER5MINRRP`	`Nullable(Float64)`		✓	✓
`LOWER5MINSUPPLYPRICE`	`Nullable(Float64)`		✓	✓
`LOWER5MINVIOLATION`	`Nullable(Float64)`		✓	✓
`LOWER60SECAPCFLAG`	`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)`		✓	✓
`LOWER60SECROP`	`Nullable(Float64)`		✓	✓
`LOWER60SECRRP`	`Nullable(Float64)`		✓	✓
`LOWER60SECSUPPLYPRICE`	`Nullable(Float64)`		✓	✓
`LOWER60SECVIOLATION`	`Nullable(Float64)`		✓	✓
`LOWER6SECAPCFLAG`	`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)`		✓	✓
`LOWER6SECROP`	`Nullable(Float64)`		✓	✓
`LOWER6SECRRP`	`Nullable(Float64)`		✓	✓
`LOWER6SECSUPPLYPRICE`	`Nullable(Float64)`		✓	✓
`LOWER6SECVIOLATION`	`Nullable(Float64)`		✓	✓
`LOWERREGAPCFLAG`	`Nullable(Float64)`		✓	✓
`LOWERREGIMPORT`	`Nullable(Float64)`		✓	✓
`LOWERREGLOCALDISPATCH`	`Nullable(Float64)`		✓	✓
`LOWERREGLOCALREQ`	`Nullable(Float64)`		✓	✓
`LOWERREGLOCALVIOLATION`	`Nullable(Float64)`		✓	✓
`LOWERREGREQ`	`Nullable(Float64)`		✓	✓
`LOWERREGROP`	`Nullable(Float64)`		✓	✓
`LOWERREGRRP`	`Nullable(Float64)`		✓	✓
`LOWERREGVIOLATION`	`Nullable(Float64)`		✓	✓
`MARKETSUSPENDEDFLAG`	`Nullable(Float64)`		✓	✓
`NETINTERCHANGE`	`Nullable(Float64)`		✓	✓
`RAISE1SECAPCFLAG`	`Nullable(Float64)`		✓	-
`RAISE1SECLOCALDISPATCH`	`Nullable(Float64)`		✓	-
`RAISE1SECROP`	`Nullable(Float64)`		✓	-
`RAISE1SECRRP`	`Nullable(Float64)`		✓	-
`RAISE5MINAPCFLAG`	`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)`		✓	✓
`RAISE5MINROP`	`Nullable(Float64)`		✓	✓
`RAISE5MINRRP`	`Nullable(Float64)`		✓	✓
`RAISE5MINSUPPLYPRICE`	`Nullable(Float64)`		✓	✓
`RAISE5MINVIOLATION`	`Nullable(Float64)`		✓	✓
`RAISE60SECAPCFLAG`	`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)`		✓	✓
`RAISE60SECROP`	`Nullable(Float64)`		✓	✓
`RAISE60SECRRP`	`Nullable(Float64)`		✓	✓
`RAISE60SECSUPPLYPRICE`	`Nullable(Float64)`		✓	✓
`RAISE60SECVIOLATION`	`Nullable(Float64)`		✓	✓
`RAISE6SECAPCFLAG`	`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)`		✓	✓
`RAISE6SECROP`	`Nullable(Float64)`		✓	✓
`RAISE6SECRRP`	`Nullable(Float64)`		✓	✓
`RAISE6SECSUPPLYPRICE`	`Nullable(Float64)`		✓	✓
`RAISE6SECVIOLATION`	`Nullable(Float64)`		✓	✓
`RAISEREGAPCFLAG`	`Nullable(Float64)`		✓	✓
`RAISEREGIMPORT`	`Nullable(Float64)`		✓	✓
`RAISEREGLOCALDISPATCH`	`Nullable(Float64)`		✓	✓
`RAISEREGLOCALREQ`	`Nullable(Float64)`		✓	✓
`RAISEREGLOCALVIOLATION`	`Nullable(Float64)`		✓	✓
`RAISEREGREQ`	`Nullable(Float64)`		✓	✓
`RAISEREGROP`	`Nullable(Float64)`		✓	✓
`RAISEREGRRP`	`Nullable(Float64)`		✓	✓
`RAISEREGVIOLATION`	`Nullable(Float64)`		✓	✓
`REGIONID`	`LowCardinality(String)`	Differentiates this region from all other regions	✓	✓
`ROP`	`Nullable(Float64)`		✓	✓
`RRP`	`Nullable(Float64)`		✓	✓
`RUNNO`	`Nullable(Float64)`		✓	✓
`SETTLEMENTDATE`	`Nullable(DateTime64(3))`		✓	✓
`TOTALDEMAND`	`Nullable(Float64)`		✓	✓
`processed_at`	`DateTime64(3)`		✓	✓
`source_zip`	`String`		✓	✓

Schema Versions

Version	Rows	Size
`7876f6a6`	524,155	36.63 MiB
`7f0a7ee7`	626,460	41.12 MiB

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