regionavailability v4

mtpasa__regionavailability__4

AEMO Description

Stores the Region-aggregate offered PASA Availability of sch

Note that the provided table descriptions are truncated by AEMO.

Total Schema Versions 1
Combined Rows 8,290,405
Combined Size 137.08 MiB
MMS Table mtpasa_regionavailability
Unified View nemwebviews.mtpasa__regionavailability__4

Schema Evolution

Column Type Description 1d5b2064
CARRYOVERCAPACITY Nullable(Float64) Split of the CARRYOVER component of aggregate capacity vs the currently reported capacity.
DAY Nullable(DateTime64(3)) Date on which the aggregation applies.
DEMAND10 Nullable(Float64) 10% probability demand (ex non-scheduled demand)
DEMAND10MAX Nullable(Float64) Maximum of the Operational Load as Generated (OPGEN) peaks that occur in all ref years for the P10 traces (MW).
DEMAND10MIN Nullable(Float64) Minimum of the Operational Load as Generated (OPGEN) peaks that occur in all ref years for the P10 traces (MW).
DEMAND50 Nullable(Float64) 50% probability demand (ex non-scheduled demand)
DEMAND50MAX Nullable(Float64) Maximum of the Operational Load as Generated (OPGEN) peaks that occur in all ref years for the P50 traces (MW).
DEMAND50MIN Nullable(Float64) Minimum of the Operational Load as Generated (OPGEN) peaks that occur in all ref years for the P50 traces (MW).
ENERGYCONSTRAINEDCAPACITY Nullable(Float64) Region energy constrained MW capacity
ENERGYREQDEMAND10 Nullable(Float64) Total weekly operational as generated consumption (POE 10)
ENERGYREQDEMAND50 Nullable(Float64) Total weekly operational as generated consumption (POE 50)
ENERGYUNCONSTRAINEDCAPACITY Nullable(Float64) Region energy unconstrained MW capacity
LASTCHANGED Nullable(DateTime64(3)) Last date and time record changed
LATEST_OFFER_DATETIME Nullable(DateTime64(3)) Date Time of the latest offer used in the aggregation for this region and date.
NONSCHEDULEDGENERATION Nullable(Float64) Allowance made for non-scheduled generation in the demand forecast (MW)
PASAAVAILABILITY_SCHEDULED Nullable(Float64) Aggregate of the offered PASA Availability for all Scheduled generators in this region.
PUBLISH_DATETIME Nullable(DateTime64(3)) Date Time the report was published.
REGIONID LowCardinality(String) NEM Region.
processed_at DateTime64(3)
source_zip String

Schema Versions

Version Rows Size
1d5b2064 8,290,405 137.08 MiB

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