mtpasa__regionsummary__1
AEMO Description
Region Results summary over aggregation periods.
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 1 |
| Combined Rows | 17,540 |
| Combined Size | 315.12 KiB |
| MMS Table | mtpasa_regionsummary |
| Unified View | nemwebviews.mtpasa__regionsummary__1 |
Schema Evolution
| Column | Type | Description | f78623b4 |
|---|---|---|---|
AGGREGATION_PERIOD |
LowCardinality(String) |
Period data is aggregated over. Values are YEAR, MONTH | ✓ |
DEMAND_POE_TYPE |
LowCardinality(String) |
Demand POE type used. Value are POE10, POE50 | ✓ |
LASTCHANGED |
Nullable(DateTime64(3)) |
Last date and time record changed | ✓ |
LRC |
Nullable(Float64) |
LRC Condition reported (Value=1) if USE_WEIGHTED_AVG >= 0.002% otherwise (Value=0) | ✓ |
NATIVEDEMAND |
Nullable(Float64) |
Native demand calculated from Operational As Generated trace supplied by Energy Forecasting | ✓ |
NUMBEROFITERATIONS |
Nullable(Float64) |
Total number of iterations and reference years performed | ✓ |
PERIOD_ENDING |
Nullable(DateTime64(3)) |
Datetime of day at end of period (i.e. last day of month or year reported) | ✓ |
REGIONID |
LowCardinality(String) |
The unique region identifier | ✓ |
RUNTYPE |
LowCardinality(String) |
Type of run. Always RELIABILITY | ✓ |
RUN_DATETIME |
Nullable(DateTime64(3)) |
Date processing of the run begins. | ✓ |
RUN_NO |
Nullable(Float64) |
Unique run id. | ✓ |
USE_AVERAGE |
Nullable(Float64) |
Average period unserved energy across iterations and reference years (MWh) | ✓ |
USE_EVENT_LOWERQUARTILE |
Nullable(Float64) |
Lower quartile unserved energy event size across all half hourly intervals and iterations and reference years that have unserved energy>0 (MW) | ✓ |
USE_EVENT_MAX |
Nullable(Float64) |
Maximum unserved energy event size across all half hourly intervals and iterations and reference years that have unserved energy>0 (MW) | ✓ |
USE_EVENT_MEDIAN |
Nullable(Float64) |
Median unserved energy event size across all half hourly intervals and iterations and reference years that have unserved energy>0 (MW) | ✓ |
USE_EVENT_MIN |
Nullable(Float64) |
Minimum unserved energy event size across all half hourly intervals and iterations and reference years that have unserved energy>0 (MW) | ✓ |
USE_EVENT_UPPERQUARTILE |
Nullable(Float64) |
Upper quartile unserved energy event size across all half hourly intervals and iterations and reference years that have unserved energy>0 (MW) | ✓ |
USE_NUMBEROFITERATIONS |
Nullable(Float64) |
Number of iterations and reference years showing unserved energy | ✓ |
USE_PERCENTILE10 |
Nullable(Float64) |
Unserved energy period amount at the 10th percentile of iterations and reference years (MWh) | ✓ |
USE_PERCENTILE100 |
Nullable(Float64) |
Unserved energy period amount at the 100th percentile of iterations and reference years (MWh) | ✓ |
USE_PERCENTILE20 |
Nullable(Float64) |
Unserved energy period amount at the 20th percentile of iterations and reference years (MWh) | ✓ |
USE_PERCENTILE30 |
Nullable(Float64) |
Unserved energy period amount at the 30th percentile of iterations and reference years (MWh) | ✓ |
USE_PERCENTILE40 |
Nullable(Float64) |
Unserved energy period amount at the 40th percentile of iterations and reference years (MWh) | ✓ |
USE_PERCENTILE50 |
Nullable(Float64) |
Unserved energy period amount at the 50th percentile of iterations and reference years (MWh) | ✓ |
USE_PERCENTILE60 |
Nullable(Float64) |
Unserved energy period amount at the 60th percentile of iterations and reference years (MWh) | ✓ |
USE_PERCENTILE70 |
Nullable(Float64) |
Unserved energy period amount at the 70th percentile of iterations and reference years (MWh) | ✓ |
USE_PERCENTILE80 |
Nullable(Float64) |
Unserved energy period amount at the 80th percentile of iterations and reference years (MWh) | ✓ |
USE_PERCENTILE90 |
Nullable(Float64) |
Unserved energy period amount at the 90th percentile of iterations and reference years (MWh) | ✓ |
USE_WEIGHTED_AVG |
Nullable(Float64) |
Weighted average USE per region = (USE_AVERAGE_POE10/NATIVE_DEMAND_POE_10WEIGHT_POE_10 + USE_AVERAGE_POE50/NATIVE_DEMAND_POE_50WEIGHT_POE_50)*100 | ✓ |
WEIGHT |
Nullable(Float64) |
Fixed Values of 0.696 for 50 POE and 0.304 for 10 POE. | ✓ |
processed_at |
DateTime64(3) |
✓ | |
source_zip |
String |
✓ |
Schema Versions
| Version | Rows | Size |
|---|---|---|
f78623b4 |
17,540 | 315.12 KiB |
Last updated: 2025-12-10 08:00:06