mtpasa__regionresult__2
AEMO Description
Region results for interval of max demand per day.
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 1 |
| Combined Rows | 237,415 |
| Combined Size | 9.60 MiB |
| MMS Table | mtpasa_regionresult |
| Unified View | nemwebviews.mtpasa__regionresult__2 |
Schema Evolution
| Column | Type | Description | e94d876a |
|---|---|---|---|
AGGREGATEINSTALLEDCAPACITY |
Nullable(Float64) |
The total installed capacity of all generation (MW) | ✓ |
DAY |
Nullable(DateTime64(3)) |
Day this result is for | ✓ |
DEMAND |
Nullable(Float64) |
Demand value from selected half hourly interval (MW) | ✓ |
DEMANDSIDEPARTICIPATION10 |
Nullable(Float64) |
The 10th percentile for demand side participation, across iterations and reference years (MW) | ✓ |
DEMANDSIDEPARTICIPATION50 |
Nullable(Float64) |
The 50th percentile for demand side participation, across iterations and reference years (MW) | ✓ |
DEMANDSIDEPARTICIPATION90 |
Nullable(Float64) |
The 90th percentile for demand side participation, across iterations and reference years (MW) | ✓ |
DEMAND_POE_TYPE |
LowCardinality(String) |
Demand POE type used. Value is POE10 | ✓ |
LASTCHANGED |
Nullable(DateTime64(3)) |
Last date and time record changed | ✓ |
NUMBEROFITERATIONS |
Nullable(Float64) |
Total number of iterations and reference years performed | ✓ |
PERIODID |
Nullable(Float64) |
Half hourly period reported, selected as period of maximum NEM scheduled demand (calculated as maximum of scheduled demands, averaged across iterations and reference years) | ✓ |
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. | ✓ |
TOTALAVAILABLEGEN10 |
Nullable(Float64) |
The 10% percentile for available capacity, across iterations and reference years (MW). | ✓ |
TOTALAVAILABLEGEN50 |
Nullable(Float64) |
The 50% percentile for available capacity, across iterations and reference years (MW). | ✓ |
TOTALAVAILABLEGEN90 |
Nullable(Float64) |
The 90% percentile for available capacity, across iterations and reference years (MW). | ✓ |
TOTALAVAILABLEGENMAX |
Nullable(Float64) |
Maximum available capacity, across iterations and reference years (MW). | ✓ |
TOTALAVAILABLEGENMIN |
Nullable(Float64) |
Minimum available capacity, across iterations and reference years (MW). | ✓ |
TOTALINTERMITTENTGEN10 |
Nullable(Float64) |
The 10th percentile for intermittent generation, across iterations and reference years (MW) | ✓ |
TOTALINTERMITTENTGEN50 |
Nullable(Float64) |
The 50th percentile for intermittent generation, across iterations and reference years (MW) | ✓ |
TOTALINTERMITTENTGEN90 |
Nullable(Float64) |
The 90th percentile for intermittent generation, across iterations and reference years (MW) | ✓ |
TOTALSCHEDULEDGEN10 |
Nullable(Float64) |
The 10th percentile for scheduled generation across iterations and reference years (MW) | ✓ |
TOTALSCHEDULEDGEN50 |
Nullable(Float64) |
The 50th percentile for scheduled generation across iterations and reference years (MW) | ✓ |
TOTALSCHEDULEDGEN90 |
Nullable(Float64) |
The 90th percentile for scheduled generation across iterations and reference years (MW) | ✓ |
TOTALSEMISCHEDULEGEN10 |
Nullable(Float64) |
The 10% percentile for semi-scheduled generation across iterations and reference years (MW) | ✓ |
TOTALSEMISCHEDULEGEN50 |
Nullable(Float64) |
The 50% percentile for semi-scheduled generation across iterations and reference years (MW) | ✓ |
TOTALSEMISCHEDULEGEN90 |
Nullable(Float64) |
The 90% percentile for semi-scheduled generation across iterations and reference years (MW) | ✓ |
USE_AVERAGE |
Nullable(Float64) |
Average unserved energy, across iterations and reference years (MW) | ✓ |
USE_EVENT_AVERAGE |
Nullable(Float64) |
Average unserved energy event size, across iterations and reference years (MW) | ✓ |
USE_LOWERQUARTILE |
Nullable(Float64) |
Lower quartile unserved energy, across iterations and reference years (MW) | ✓ |
USE_MAX |
Nullable(Float64) |
Maximum unserved energy, across iterations and reference years (MW) | ✓ |
USE_MEDIAN |
Nullable(Float64) |
Median unserved energy, across iterations and reference years (MW) | ✓ |
USE_MIN |
Nullable(Float64) |
Minimum unserved energy, across iterations and reference years (MW) | ✓ |
USE_NUMBEROFITERATIONS |
Nullable(Float64) |
Number of iterations and reference years with unserved energy>0 | ✓ |
USE_UPPERQUARTILE |
Nullable(Float64) |
Upper quartile unserved energy, across iterations and reference years (MW) | ✓ |
processed_at |
DateTime64(3) |
✓ | |
source_zip |
String |
✓ |
Schema Versions
| Version | Rows | Size |
|---|---|---|
e94d876a |
237,415 | 9.60 MiB |
Last updated: 2025-12-10 08:00:06