pdpasa__regionsolution__7
AEMO Description
The PDPASA region solution data
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 1 |
| Combined Rows | 9,231,460 |
| Combined Size | 529.31 MiB |
| MMS Table | pdpasa_regionsolution |
| Unified View | nemwebviews.pdpasa__regionsolution__7 |
Schema Evolution
| Column | Type | Description | 79f03232 |
|---|---|---|---|
AGGREGATECAPACITYAVAILABLE |
Nullable(Float64) |
Sum of MAXAVAIL quantities offered by all Scheduled units and Availability of all semi-scheduled units limited by MAXAVAIL in a given Region for a given PERIODID | ✓ |
AGGREGATEPASAAVAILABILITY |
Nullable(Float64) |
Sum of PASAAVAILABILITY for all scheduled generating units and scheduled bidirectional units (Gen side) with a Recall_Period of null or <= 24 hours plus the sum of Unconstrained Intermittent Generation Forecasts (UIGF) for all semi-scheduled generating units. For the OUTAGE_LRC run, UIGF is the POE90 forecast. For the LOR Run, UIGF is the POE50 forecast. Note that the OUTAGE_LRC Run Type is discontinued from 31 July 2025. | ✓ |
AGGREGATESCHEDULEDLOAD |
Nullable(Float64) |
Sum of MAXAVAIL quantities bid by of all Scheduled Loads in a given Region for a given PERIODID. | ✓ |
CALCULATEDLOR1LEVEL |
Nullable(Float64) |
Region Reserve Level for LOR1 used. Can be static value or calculated value if an interconnector is a credible contingency | ✓ |
CALCULATEDLOR2LEVEL |
Nullable(Float64) |
Region Reserve Level for LOR2 used. Can be static value or calculated value if an interconnector is a credible contingency | ✓ |
CAPACITYREQ |
Nullable(Float64) |
Capacity required to meet the demand and reserve levels in the capacity adequacy assessment. | ✓ |
CONSTRAINEDCAPACITY |
Nullable(Float64) |
Aggregate generator capability from Energy Constrained plant including restrictions due to network constraints | ✓ |
DEMAND10 |
Nullable(Float64) |
10% Probability of Exceedance demand forecast | ✓ |
DEMAND50 |
Nullable(Float64) |
50% Probability of Exceedance demand forecast | ✓ |
DEMAND90 |
Nullable(Float64) |
90% Probability of Exceedance demand forecast | ✓ |
DEMAND_AND_NONSCHEDGEN |
Nullable(Float64) |
Sum of Cleared Scheduled generation, imported generation (at the region boundary) and allowances made for non-scheduled generation (MW). | ✓ |
ENERGYREQDEMAND10 |
Nullable(Float64) |
Energy (GWh) required for this energy block based on the 10% probability of exceedance demand. Listed in the first interval of the energy block | ✓ |
ENERGYREQDEMAND50 |
Nullable(Float64) |
Energy (GWh) required for this energy block based on the 50% probability of exceedance demand. Listed in the first interval of the energy block. | ✓ |
FUM |
Nullable(Float64) |
Forecasting Uncertainty Measure. MW value of reserve calculated as defined in the Reserve Level Declaration Guidelines | ✓ |
INTERVAL_DATETIME |
Nullable(DateTime64(3)) |
End date time of the interval | ✓ |
LASTCHANGED |
Nullable(DateTime64(3)) |
Date time the record was created or modified changed | ✓ |
LCR |
Nullable(Float64) |
Largest Credible Risk. MW value for highest credible contingency | ✓ |
LCR2 |
Nullable(Float64) |
Two Largest Creditable Risks. MW value for highest two credible contingencies. | ✓ |
LORCONDITION |
Nullable(Float64) |
Lack of Reserve Condition (LOR) flag for this region and interval (3 = LOR3, 2 = LOR2, 1 = LOR1, 0 = No LOR) | ✓ |
LORNETINTERCHANGEUNDERSCARCITY |
Nullable(Float64) |
Net interconnector flow from the region for this interval from the LOR assessment | ✓ |
LOR_SEMISCHEDULEDCAPACITY |
Nullable(Float64) |
Constrained generation forecast for semi-scheduled units for the region for the LOR run. Semi-scheduled generation is constrained by both System Normal and Outage constraints, and incorporate MAXAVAIL limits. | ✓ |
MAXSPARECAPACITY |
Nullable(Float64) |
Maximum spare capacity (MW) above the demand able to be sourced to this region while meeting demands in other regions. | ✓ |
MAXSURPLUSRESERVE |
Nullable(Float64) |
Maximum surplus reserve (MW) above the demand + reserve requirement able to be sourced to this region while meeting demand + reserve requirements in other regions. | ✓ |
MSRNETINTERCHANGEUNDERSCARCITY |
Nullable(Float64) |
Net interconnector flow from the region for this interval from the MSR assessment | ✓ |
NETINTERCHANGEUNDERSCARCITY |
Nullable(Float64) |
Net interconnector flow from the region for this interval from the capacity adequacy (LRC) assessment. | ✓ |
REGIONID |
LowCardinality(String) |
Region identifier | ✓ |
RESERVECONDITION |
Nullable(Float64) |
Low Reserve Condition (LRC) flag for this region in this interval (1 - LRC, 0 - No LRC) | ✓ |
RESERVEREQ |
Nullable(Float64) |
Region reserve requirement (MW) | ✓ |
RUNTYPE |
LowCardinality(String) |
Type of run. Values are RELIABILITY_LRC, OUTAGE_LRC and LOR. Note that the PDPASA OUTAGE_LRC Run Type is discontinued from 31 July 2025, with only the LOR Run Type reported. | ✓ |
RUN_DATETIME |
Nullable(DateTime64(3)) |
Case identifier by the time the case was run | ✓ |
SEMISCHEDULEDCAPACITY |
Nullable(Float64) |
Constrained generation forecast for semi-scheduled units for the region. For RELIABILITY_LRC run semi-scheduled generation is constrained only by System Normal constraints. For OUTAGE_LRC run and LOR run semi-scheduled generation is constrained by both System Normal and Outage constraints. All three run types (RELIABILITY_LRC, OUTAGE_LRC, LOR) incorporate MAXAVAIL limits. | ✓ |
SS_SOLAR_CAPACITY |
Nullable(Float64) |
Constrained generation forecast for solar for the region. For RELIABILITY_LRC run solar generation is constrained only by System Normal constraints. For OUTAGE_LRC run and LOR run solar generation is constrained by both System Normal and Outage constraints. All three run types (RELIABILITY_LRC, OUTAGE_LRC, LOR) incorporate MAXAVAIL limits. | ✓ |
SS_SOLAR_CLEARED |
Nullable(Float64) |
Constrained generation forecast for solar for the region. For RELIABILITY_LRC run solar generation is constrained only by System Normal constraints. For OUTAGE_LRC run and LOR run solar generation is constrained by both System Normal and Outage constraints. All three run types (RELIABILITY_LRC, OUTAGE_LRC, LOR) incorporate MAXAVAIL limits. | ✓ |
SS_SOLAR_UIGF |
Nullable(Float64) |
Unconstrained Intermittent Generation Forecast for solar for the region. For RELIABILITY_LRC and OUTAGE_LRC run this is the POE90 forecast (determined by LRCUIGFOption in CaseSolution). For LOR run this is the POE50 forecast | ✓ |
SS_WIND_CAPACITY |
Nullable(Float64) |
Constrained generation forecast for wind for the region. For RELIABILITY_LRC run wind generation is constrained only by System Normal constraints. For OUTAGE_LRC run and LOR run wind generation is constrained by both System Normal and Outage constraints. All three run types (RELIABILITY_LRC, OUTAGE_LRC, LOR) incorporate MAXAVAIL limits. | ✓ |
SS_WIND_CLEARED |
Nullable(Float64) |
Constrained generation forecast for wind for the region. For RELIABILITY_LRC run wind generation is constrained only by System Normal constraints. For OUTAGE_LRC run and LOR run wind generation is constrained by both System Normal and Outage constraints. All three run types (RELIABILITY_LRC, OUTAGE_LRC, LOR) incorporate MAXAVAIL limits. | ✓ |
SS_WIND_UIGF |
Nullable(Float64) |
Unconstrained Intermittent Generation Forecast for wind for the region. For RELIABILITY_LRC and OUTAGE_LRC run this is the POE90 forecast (determined by LRCUIGFOption in CaseSolution). For LOR run this is the POE50 forecast | ✓ |
SURPLUSCAPACITY |
Nullable(Float64) |
Surplus capacity (MW) above the demand, scheduled load and net interchange in this region from the capacity adequacy (LRC) assessment. | ✓ |
SURPLUSRESERVE |
Nullable(Float64) |
Surplus reserve (MW) above the demand, scheduled load, net interchange and reserve requirement in this region from the capacity adequacy (LRC) assessment. | ✓ |
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). | ✓ |
UNCONSTRAINEDCAPACITY |
Nullable(Float64) |
Aggregate generator capability from Non Energy Constrained plant including restrictions due to network constraints from the capacity adequacy (LRC) assessment. | ✓ |
WDR_AVAILABLE |
Nullable(Float64) |
Regional aggregated Wholesale Demand Response (WDR) availability in MW. | ✓ |
WDR_CAPACITY |
Nullable(Float64) |
Regional aggregated Wholesale Demand Response (WDR) capacity in MW. | ✓ |
WDR_PASAAVAILABLE |
Nullable(Float64) |
Regional aggregated Wholesale Demand Response (WDR) PASA availability in MW. | ✓ |
processed_at |
DateTime64(3) |
✓ | |
source_zip |
String |
✓ |
Schema Versions
| Version | Rows | Size |
|---|---|---|
79f03232 |
9,231,460 | 529.31 MiB |
Last updated: 2025-12-10 08:00:07