dispatchregionsum9

AEMO Description

DISPATCHREGIONSUM sets out the 5-minute solution for each di

Note that the provided table descriptions are truncated by AEMO.


Total Schema Versions	1
Combined Rows	234,940
Combined Size	37.42 MiB
MMS Table	`dispatchregionsum`
Unified View	`nemwebviews.dispatch__regionsum__9`

Schema Evolution

Column	Type	Description	0c065ef6
`AGGEGATEDISPATCHERROR`	`Nullable(Float64)`	Calculated dispatch error	✓
`AGGREGATEDISPATCHERROR`	`Nullable(Float64)`	Calculated dispatch error	✓
`AVAILABLEGENERATION`	`Nullable(Float64)`	Aggregate generation bid available in region	✓
`AVAILABLELOAD`	`Nullable(Float64)`	Aggregate load bid available in region	✓
`BDU_CLEAREDMW_GEN`	`Nullable(Float64)`	Regional aggregated cleared MW where the DUID type is BDU. Net of export (Generation)	✓
`BDU_CLEAREDMW_LOAD`	`Nullable(Float64)`	Regional aggregated cleared MW where the DUID type is BDU. Net of import (Load)	✓
`BDU_ENERGY_STORAGE`	`Nullable(Float64)`	Regional aggregated energy storage where the DUID type is BDU (MWh)	✓
`BDU_INITIAL_ENERGY_STORAGE`	`Nullable(Float64)`	Energy Storage for BDU at the start of the interval(MWh) - Region Aggregated	✓
`BDU_MAX_AVAIL`	`Nullable(Float64)`	Total available generation side BDU summated for region (MW)	✓
`BDU_MIN_AVAIL`	`Nullable(Float64)`	Total available load side BDU summated for region (MW)	✓
`CLEAREDSUPPLY`	`Nullable(Float64)`	Sum of cleared generation and import for region	✓
`DEMANDFORECAST`	`Nullable(Float64)`	5 minute forecast adjust	✓
`DEMAND_AND_NONSCHEDGEN`	`Nullable(Float64)`	Sum of Cleared Scheduled generation, imported generation (at the region boundary) and allowances made for non-scheduled generation (MW).	✓
`DISPATCHABLEGENERATION`	`Nullable(Float64)`	Dispatched Generation	✓
`DISPATCHABLELOAD`	`Nullable(Float64)`	Dispatched Load (add to total demand to get inherent region demand).	✓
`DISPATCHINTERVAL`	`Nullable(Float64)`	Dispatch period identifier, from 001 to 288 in format YYYYMMDDPPP.	✓
`EXCESSGENERATION`	`Nullable(Float64)`	MW quantity of excess	✓
`INITIALSUPPLY`	`Nullable(Float64)`	Sum of initial generation and import for region	✓
`INTERVENTION`	`Nullable(Float64)`	Manual Intervention flag	✓
`LASTCHANGED`	`Nullable(DateTime64(3))`	Last date and time record changed	✓
`LORSURPLUS`	`Nullable(Float64)`	Not in use after 17 Feb 2006. Total short term generation capacity reserve used in assessing lack of reserve condition	✓
`LOWER1SECACTUALAVAILABILITY`	`Nullable(Float64)`	Trapezium adjusted Lower1Sec availability (summated from UnitSolution)	✓
`LOWER1SECLOCALDISPATCH`	`Nullable(Float64)`	Total Lower1Sec Dispatched in Region - RegionSolution element L1Dispatch attribute	✓
`LOWER5MINACTUALAVAILABILITY`	`Nullable(Float64)`	trapezium adjusted lower 5min availability	✓
`LOWER5MINDISPATCH`	`Nullable(Float64)`	Not used since Dec 2003. Lower 5 min MW dispatch	✓
`LOWER5MINIMPORT`	`Nullable(Float64)`	Not used since Dec 2003. Lower 5 min MW imported	✓
`LOWER5MINLOCALDISPATCH`	`Nullable(Float64)`	Lower 5 min local dispatch	✓
`LOWER5MINLOCALPRICE`	`Nullable(Float64)`	Not used since Dec 2003. Local price of lower 5 min	✓
`LOWER5MINLOCALREQ`	`Nullable(Float64)`	Not used since Dec 2003. Lower 5 min local requirement	✓
`LOWER5MINLOCALVIOLATION`	`Nullable(Float64)`	Not used since Dec 2003. Violation (MW) of Lower 5 min local requirement	✓
`LOWER5MINPRICE`	`Nullable(Float64)`	Not used since Dec 2003. Regional price of lower 5 min	✓
`LOWER5MINREQ`	`Nullable(Float64)`	Not used since Dec 2003. Lower 5 min total requirement	✓
`LOWER5MINSUPPLYPRICE`	`Nullable(Float64)`	Not used since Dec 2003. Supply price of lower 5 min	✓
`LOWER5MINVIOLATION`	`Nullable(Float64)`	Not used since Dec 2003. Violation (MW) of Lower 5 min requirement	✓
`LOWER60SECACTUALAVAILABILITY`	`Nullable(Float64)`	trapezium adjusted lower 60sec availability	✓
`LOWER60SECDISPATCH`	`Nullable(Float64)`	Not used since Dec 2003. Lower 60 sec MW dispatch	✓
`LOWER60SECIMPORT`	`Nullable(Float64)`	Not used since Dec 2003. Lower 60 sec MW imported	✓
`LOWER60SECLOCALDISPATCH`	`Nullable(Float64)`	Lower 60 sec local dispatch	✓
`LOWER60SECLOCALPRICE`	`Nullable(Float64)`	Not used since Dec 2003. Local price of lower 60 sec	✓
`LOWER60SECLOCALREQ`	`Nullable(Float64)`	Not used since Dec 2003. Lower 60 sec local requirement	✓
`LOWER60SECLOCALVIOLATION`	`Nullable(Float64)`	Not used since Dec 2003. Violation (MW) of Lower 60 sec local requirement	✓
`LOWER60SECPRICE`	`Nullable(Float64)`	Not used since Dec 2003. Regional price of lower 60 sec	✓
`LOWER60SECREQ`	`Nullable(Float64)`	Not used since Dec 2003. Lower 60 sec total requirement	✓
`LOWER60SECSUPPLYPRICE`	`Nullable(Float64)`	Not used since Dec 2003. Supply price of lower 60 sec	✓
`LOWER60SECVIOLATION`	`Nullable(Float64)`	Not used since Dec 2003. Violation (MW) of Lower 60 seconds requirement	✓
`LOWER6SECACTUALAVAILABILITY`	`Nullable(Float64)`	trapezium adjusted lower 6sec availability	✓
`LOWER6SECDISPATCH`	`Nullable(Float64)`	Not used since Dec 2003. Lower 6 sec MW dispatch	✓
`LOWER6SECIMPORT`	`Nullable(Float64)`	Not used since Dec 2003. Lower 6 sec MW imported	✓
`LOWER6SECLOCALDISPATCH`	`Nullable(Float64)`	Lower 6 sec local dispatch	✓
`LOWER6SECLOCALPRICE`	`Nullable(Float64)`	Not used since Dec 2003. Local price of lower 6 sec	✓
`LOWER6SECLOCALREQ`	`Nullable(Float64)`	Not used since Dec 2003. Lower 6 sec local requirement	✓
`LOWER6SECLOCALVIOLATION`	`Nullable(Float64)`	Not used since Dec 2003. Violation (MW) of Lower 6 sec local requirement	✓
`LOWER6SECPRICE`	`Nullable(Float64)`	Not used since Dec 2003. Regional price of lower 6 sec	✓
`LOWER6SECREQ`	`Nullable(Float64)`	Not used since Dec 2003. Lower 6 sec total requirement	✓
`LOWER6SECSUPPLYPRICE`	`Nullable(Float64)`	Not used since Dec 2003. Supply price of lower 6 sec	✓
`LOWER6SECVIOLATION`	`Nullable(Float64)`	Not used since Dec 2003. Violation (MW) of Lower 6 seconds requirement	✓
`LOWERREGACTUALAVAILABILITY`	`Nullable(Float64)`	trapezium adjusted lower reg availability	✓
`LOWERREGIMPORT`	`Nullable(Float64)`	Not used since Dec 2003. Lower Regulation MW imported	✓
`LOWERREGLOCALDISPATCH`	`Nullable(Float64)`	Lower Regulation local dispatch	✓
`LOWERREGLOCALREQ`	`Nullable(Float64)`	Not used since Dec 2003. Lower Regulation local requirement	✓
`LOWERREGLOCALVIOLATION`	`Nullable(Float64)`	Not used since Dec 2003. Violation (MW) of Lower Reg local requirement	✓
`LOWERREGREQ`	`Nullable(Float64)`	Not used since Dec 2003. Lower Regulation total requirement	✓
`LOWERREGVIOLATION`	`Nullable(Float64)`	Not used since Dec 2003. Violation (MW) of Lower Reg requirement	✓
`LRCSURPLUS`	`Nullable(Float64)`	Not in use after 17 Feb 2006. Total short term generation capacity reserve above the stated low reserve condition requirement	✓
`NETINTERCHANGE`	`Nullable(Float64)`	Net interconnector flow from the regional reference node	✓
`RAISE1SECACTUALAVAILABILITY`	`Nullable(Float64)`	Trapezium adjusted Raise1Sec availability (summated from UnitSolution)	✓
`RAISE1SECLOCALDISPATCH`	`Nullable(Float64)`	Total Raise1Sec Dispatched in Region - RegionSolution element R1Dispatch attribute	✓
`RAISE5MINACTUALAVAILABILITY`	`Nullable(Float64)`	trapezium adjusted raise 5min availability	✓
`RAISE5MINDISPATCH`	`Nullable(Float64)`	Not used since Dec 2003. Raise 5 min MW dispatch	✓
`RAISE5MINIMPORT`	`Nullable(Float64)`	Not used since Dec 2003. Raise 5 min MW imported	✓
`RAISE5MINLOCALDISPATCH`	`Nullable(Float64)`	Raise 5 min local dispatch	✓
`RAISE5MINLOCALPRICE`	`Nullable(Float64)`	Not used since Dec 2003. Raise price of lower 5 min	✓
`RAISE5MINLOCALREQ`	`Nullable(Float64)`	Not used since Dec 2003. Raise 5 min local requirement	✓
`RAISE5MINLOCALVIOLATION`	`Nullable(Float64)`	Not used since Dec 2003. Violation (MW) of Raise 5 min local requirement	✓
`RAISE5MINPRICE`	`Nullable(Float64)`	Not used since Dec 2003. Regional price of raise 5 min	✓
`RAISE5MINREQ`	`Nullable(Float64)`	Not used since Dec 2003. Raise 5 min total requirement	✓
`RAISE5MINSUPPLYPRICE`	`Nullable(Float64)`	Not used since Dec 2003. Supply price of raise 5 min	✓
`RAISE5MINVIOLATION`	`Nullable(Float64)`	Not used since Dec 2003. Violation (MW) of Raise 5 min requirement	✓
`RAISE60SECACTUALAVAILABILITY`	`Nullable(Float64)`	trapezium adjusted raise 60sec availability	✓
`RAISE60SECDISPATCH`	`Nullable(Float64)`	Not used since Dec 2003. Raise 60 sec MW dispatch	✓
`RAISE60SECIMPORT`	`Nullable(Float64)`	Not used since Dec 2003. Raise 60 sec MW imported	✓
`RAISE60SECLOCALDISPATCH`	`Nullable(Float64)`	Raise 60 sec local dispatch	✓
`RAISE60SECLOCALPRICE`	`Nullable(Float64)`	Not used since Dec 2003. Local price of raise 60 sec	✓
`RAISE60SECLOCALREQ`	`Nullable(Float64)`	Not used since Dec 2003. Raise 60 sec local requirement	✓
`RAISE60SECLOCALVIOLATION`	`Nullable(Float64)`	Not used since Dec 2003. Violation (MW) of Raise 60 sec local requirement	✓
`RAISE60SECPRICE`	`Nullable(Float64)`	Not used since Dec 2003. Regional price of raise 60 sec	✓
`RAISE60SECREQ`	`Nullable(Float64)`	Not used since Dec 2003. Raise 60 sec total requirement	✓
`RAISE60SECSUPPLYPRICE`	`Nullable(Float64)`	Not used since Dec 2003. Supply price of raise 60 sec	✓
`RAISE60SECVIOLATION`	`Nullable(Float64)`	Not used since Dec 2003. Violation (MW) of Raise 60 seconds requirement	✓
`RAISE6SECACTUALAVAILABILITY`	`Nullable(Float64)`	trapezium adjusted raise 6sec availability	✓
`RAISE6SECDISPATCH`	`Nullable(Float64)`	Not used since Dec 2003. Raise 6 sec MW dispatch	✓
`RAISE6SECIMPORT`	`Nullable(Float64)`	Not used since Dec 2003. Raise 6 sec MW imported	✓
`RAISE6SECLOCALDISPATCH`	`Nullable(Float64)`	Raise 6 sec local dispatch	✓
`RAISE6SECLOCALPRICE`	`Nullable(Float64)`	Not used since Dec 2003. Local price of raise 6 sec	✓
`RAISE6SECLOCALREQ`	`Nullable(Float64)`	Not used since Dec 2003. Raise 6 sec local requirement	✓
`RAISE6SECLOCALVIOLATION`	`Nullable(Float64)`	Not used since Dec 2003. Violation (MW) of Raise 6 sec local requirement	✓
`RAISE6SECPRICE`	`Nullable(Float64)`	Not used since Dec 2003. Regional price of raise 6 sec	✓
`RAISE6SECREQ`	`Nullable(Float64)`	Not used since Dec 2003. Raise 6 sec total requirement	✓
`RAISE6SECSUPPLYPRICE`	`Nullable(Float64)`	Not used since Dec 2003. Supply price of raise 6 sec	✓
`RAISE6SECVIOLATION`	`Nullable(Float64)`	Not used since Dec 2003. Violation (MW) of Raise 6 seconds requirement	✓
`RAISEREGACTUALAVAILABILITY`	`Nullable(Float64)`	trapezium adjusted raise reg availability	✓
`RAISEREGIMPORT`	`Nullable(Float64)`	Not used since Dec 2003. Raise Regulation MW imported	✓
`RAISEREGLOCALDISPATCH`	`Nullable(Float64)`	Raise Regulation local dispatch	✓
`RAISEREGLOCALREQ`	`Nullable(Float64)`	Not used since Dec 2003. Raise Regulation local requirement	✓
`RAISEREGLOCALVIOLATION`	`Nullable(Float64)`	Not used since Dec 2003. Violation (MW) of Raise Reg local requirement	✓
`RAISEREGREQ`	`Nullable(Float64)`	Not used since Dec 2003. Raise Regulation total requirement	✓
`RAISEREGVIOLATION`	`Nullable(Float64)`	Not used since Dec 2003. Violation (MW) of Raise Reg requirement	✓
`REGIONID`	`LowCardinality(String)`	Region Identifier	✓
`RUNNO`	`Nullable(Float64)`	Dispatch run no; always 1	✓
`SEMISCHEDULE_CLEAREDMW`	`Nullable(Float64)`	Regional aggregated Semi-Schedule generator Cleared MW	✓
`SEMISCHEDULE_COMPLIANCEMW`	`Nullable(Float64)`	Regional aggregated Semi-Schedule generator Cleared MW where Semi-Dispatch cap is enforced	✓
`SETTLEMENTDATE`	`Nullable(DateTime64(3))`	Market date and time starting at 04:05	✓
`SS_SOLAR_AVAILABILITY`	`Nullable(Float64)`	For Semi-Scheduled units. Aggregate Energy Availability from Solar units in that region	✓
`SS_SOLAR_CLEAREDMW`	`Nullable(Float64)`	Regional aggregated Semi-Schedule generator Cleared MW where the primary fuel source is solar	✓
`SS_SOLAR_COMPLIANCEMW`	`Nullable(Float64)`	Regional aggregated Semi-Schedule generator Cleared MW where Semi-Dispatch cap is enforced and the primary fuel source is solar	✓
`SS_SOLAR_UIGF`	`Nullable(Float64)`	Regional aggregated Unconstrained Intermittent Generation Forecast of Semi-scheduled generation (MW) where the primary fuel source is solar	✓
`SS_WIND_AVAILABILITY`	`Nullable(Float64)`	For Semi-Scheduled units. Aggregate Energy Availability from Wind units in that region	✓
`SS_WIND_CLEAREDMW`	`Nullable(Float64)`	Regional aggregated Semi-Schedule generator Cleared MW where the primary fuel source is wind	✓
`SS_WIND_COMPLIANCEMW`	`Nullable(Float64)`	Regional aggregated Semi-Schedule generator Cleared MW where Semi-Dispatch cap is enforced and the primary fuel source is wind	✓
`SS_WIND_UIGF`	`Nullable(Float64)`	Regional aggregated Unconstrained Intermittent Generation Forecast of Semi-scheduled generation (MW) where the primary fuel source is wind	✓
`TOTALDEMAND`	`Nullable(Float64)`	Demand (less loads)	✓
`TOTALINTERMITTENTGENERATION`	`Nullable(Float64)`	Allowance made for non-scheduled generation in the demand forecast (MW).	✓
`UIGF`	`Nullable(Float64)`	Regional aggregated Unconstrained Intermittent Generation Forecast of Semi-scheduled generation (MW).	✓
`WDR_AVAILABLE`	`Nullable(Float64)`	Regional aggregated available MW for Wholesale Demand Response (WDR) units	✓
`WDR_DISPATCHED`	`Nullable(Float64)`	Regional aggregated dispatched MW for Wholesale Demand Response (WDR) units	✓
`WDR_INITIALMW`	`Nullable(Float64)`	Regional aggregated MW value at start of interval for Wholesale Demand Response (WDR) units	✓
`processed_at`	`DateTime64(3)`		✓
`source_zip`	`String`		✓

Schema Versions

Version	Rows	Size
`0c065ef6`	234,940	37.42 MiB

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

regionsum v8 unit_scada

dispatch__regionsum__9

AEMO Description

Schema Evolution

Schema Versions

dispatchregionsum9