p5minregionsolution10

AEMO Description

The five-minute predispatch (P5Min) is a MMS system providin

Note that the provided table descriptions are truncated by AEMO.


Total Schema Versions	1
Combined Rows	2,819,100
Combined Size	331.25 MiB
MMS Table	`p5min_regionsolution`
Unified View	`nemwebviews.p5min__regionsolution__10`

Schema Evolution

Column	Type	Description	0782c3a0
`AGGREGATEDISPATCHERROR`	`Nullable(Float64)`	Aggregate dispatch error applied	✓
`AVAILABLEGENERATION`	`Nullable(Float64)`	Regional Available generation	✓
`AVAILABLELOAD`	`Nullable(Float64)`	Regional Available Load	✓
`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)`	Predicted change in regional demand for this interval	✓
`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)`	Regional Generation Dispatched	✓
`DISPATCHABLELOAD`	`Nullable(Float64)`	Regional Load Dispatched	✓
`EXCESSGENERATION`	`Nullable(Float64)`	Total Energy Imbalance (MW)	✓
`INITIALSUPPLY`	`Nullable(Float64)`	Sum of initial generation and import for region	✓
`INTERVAL_DATETIME`	`Nullable(DateTime64(3))`	The unique identifier for the interval within this study	✓
`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 there is not intervention in the market, both pricing and physical runs correspond to INTERVENTION=0	✓
`LASTCHANGED`	`Nullable(DateTime64(3))`	Last date and time record changed	✓
`LOWER1SECLOCALDISPATCH`	`Nullable(Float64)`	Total Lower1Sec Dispatched in Region - RegionSolution element L1Dispatch attribute	✓
`LOWER1SECROP`	`Nullable(Float64)`	Lower1Sec Regional Original Price - uncapped/unfloored and unscaled	✓
`LOWER1SECRRP`	`Nullable(Float64)`	Regional Lower 1Sec Price - RegionSolution element L1Price attribute	✓
`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	✓
`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	✓
`LOWER5MINREQ`	`Nullable(Float64)`	Not used since Dec 2003. Lower 5 min total requirement	✓
`LOWER5MINROP`	`Nullable(Float64)`	Original regional price (Lower5Min)	✓
`LOWER5MINRRP`	`Nullable(Float64)`	Region Reference Price (Lower5Min)	✓
`LOWER5MINVIOLATION`	`Nullable(Float64)`	Not used since Dec 2003. Violation (MW) of Lower 5 min requirement	✓
`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	✓
`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	✓
`LOWER60SECREQ`	`Nullable(Float64)`	Not used since Dec 2003. Lower 60 sec total requirement	✓
`LOWER60SECROP`	`Nullable(Float64)`	Original regional price (Lower60Sec)	✓
`LOWER60SECRRP`	`Nullable(Float64)`	Region Reference Price (Lower60Sec)	✓
`LOWER60SECVIOLATION`	`Nullable(Float64)`	Not used since Dec 2003. Violation (MW) of Lower 60 seconds requirement	✓
`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	✓
`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	✓
`LOWER6SECREQ`	`Nullable(Float64)`	Not used since Dec 2003. Lower 6 sec total requirement	✓
`LOWER6SECROP`	`Nullable(Float64)`	Original regional price (Lower6Sec)	✓
`LOWER6SECRRP`	`Nullable(Float64)`	Region Reference Price (Lower6Sec)	✓
`LOWER6SECVIOLATION`	`Nullable(Float64)`	Not used since Dec 2003. Violation (MW) of Lower 6 seconds requirement	✓
`LOWERREGDISPATCH`	`Nullable(Float64)`	Not used since Dec 2003. Total Lower Regulation dispatch	✓
`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	✓
`LOWERREGROP`	`Nullable(Float64)`	Original regional price (LowerReg)	✓
`LOWERREGRRP`	`Nullable(Float64)`	Region Reference Price (LowerReg)	✓
`LOWERREGVIOLATION`	`Nullable(Float64)`	Not used since Dec 2003. Violation (MW) of Lower Reg requirement	✓
`NETINTERCHANGE`	`Nullable(Float64)`	Net interconnector Flows	✓
`RAISE1SECLOCALDISPATCH`	`Nullable(Float64)`	Total Raise1Sec Dispatched in Region - RegionSolution element R1Dispatch attribute	✓
`RAISE1SECROP`	`Nullable(Float64)`	Raise1Sec Regional Original Price - uncapped/unfloored and unscaled	✓
`RAISE1SECRRP`	`Nullable(Float64)`	Regional Raise 1Sec Price - R1Price attribute after capping/flooring	✓
`RAISE5MINDISPATCH`	`Nullable(Float64)`	Not used since Dec 2003. Total 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	✓
`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	✓
`RAISE5MINREQ`	`Nullable(Float64)`	Not used since Dec 2003. Raise 5 min total requirement	✓
`RAISE5MINROP`	`Nullable(Float64)`	Original regional price (Raise5Min)	✓
`RAISE5MINRRP`	`Nullable(Float64)`	Region Reference Price (Raise5Min)	✓
`RAISE5MINVIOLATION`	`Nullable(Float64)`	Not used since Dec 2003. Violation (MW) of Raise 5 min requirement	✓
`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 50 sec local dispatch	✓
`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	✓
`RAISE60SECREQ`	`Nullable(Float64)`	Not used since Dec 2003. Raise 60 sec total requirement	✓
`RAISE60SECROP`	`Nullable(Float64)`	Original regional price (Raise60Sec)	✓
`RAISE60SECRRP`	`Nullable(Float64)`	Region Reference Price (Raise60Sec)	✓
`RAISE60SECVIOLATION`	`Nullable(Float64)`	Not used since Dec 2003. Violation (MW) of Raise 60 seconds requirement	✓
`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	✓
`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	✓
`RAISE6SECREQ`	`Nullable(Float64)`	Not used since Dec 2003. Raise 6 sec total requirement	✓
`RAISE6SECROP`	`Nullable(Float64)`	Original regional price (Raise6Sec)	✓
`RAISE6SECRRP`	`Nullable(Float64)`	Region Reference Price (Raise6Sec)	✓
`RAISE6SECVIOLATION`	`Nullable(Float64)`	Not used since Dec 2003. Violation (MW) of Raise 6 seconds requirement	✓
`RAISEREGDISPATCH`	`Nullable(Float64)`	Not used since Dec 2003. Total Raise Regulation dispatch	✓
`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	✓
`RAISEREGROP`	`Nullable(Float64)`	Original regional price (RaiseReg)	✓
`RAISEREGRRP`	`Nullable(Float64)`	Region Reference Price (RaiseReg)	✓
`RAISEREGVIOLATION`	`Nullable(Float64)`	Not used since Dec 2003. Violation (MW) of Raise Reg requirement	✓
`REGIONID`	`LowCardinality(String)`	Region Identifier	✓
`ROP`	`Nullable(Float64)`	Region Override Price (Energy)	✓
`RRP`	`Nullable(Float64)`	Region Reference Price (Energy)	✓
`RUN_DATETIME`	`Nullable(DateTime64(3))`	Unique Timestamp Identifier for this study	✓
`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	✓
`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)`	Regional Demand - NB NOT net of Interconnector flows or 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
`0782c3a0`	2,819,100	331.25 MiB

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

regionsolution regionsolution v9

p5min__regionsolution__10

AEMO Description

Schema Evolution

Schema Versions

p5minregionsolution10