Skip to content

PDPASA_REGIONSOLUTION

The PDPASA region solution data. Note that the OUTAGE_LRC Run Type is no longer reported from 31 July 2025.

Package

PDPASA

Visibility

Public

Table schema

Column Official MMS Datatype GR-MMS Datatype Comment
RUN_DATETIME datetime(3) 🔑 datetime2(0) 🔑 Unique Timestamp Identifier for this run, identified by the first half hour ended interval of the run.
INTERVAL_DATETIME datetime(3) 🔑 datetime2(0) 🔑 End date time of the interval
REGIONID varchar(10) 🔑 varchar(10) 🔑 Region identifier
RUNTYPE varchar(20) 🔑 varchar(20) 🔑 Type of run. Values are 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.
DEMAND10 numeric(12, 2) numeric(12, 2) 10% Probability of Exceedance demand forecast
DEMAND50 numeric(12, 2) numeric(12, 2) 50% Probability of Exceedance demand forecast
DEMAND90 numeric(12, 2) numeric(12, 2) 90% Probability of Exceedance demand forecast
RESERVEREQ numeric(12, 2) numeric(12, 2) Reserve Requirement (MW). This field is not populated after 30 July 2025.
CAPACITYREQ numeric(12, 2) numeric(12, 2) Demand + Reserve requirements (MW). This field is not populated after 30 July 2025.
ENERGYREQDEMAND50 numeric(12, 2) numeric(12, 2) Sum of: (Region Demand50)/Period (sum by trading day, entered in first period of trading day, GWh).
UNCONSTRAINEDCAPACITY numeric(12, 0) int Aggregate generation + WDR capacity from Non-Energy Constrained plant subjected to restrictions due to network constraints.
CONSTRAINEDCAPACITY numeric(12, 0) int Aggregate generation + WDR capacity from Energy Constrained plant subjected to restrictions due to network constraints.
NETINTERCHANGEUNDERSCARCITY numeric(12, 2) numeric(12, 2) Net export (MW) out of this region in the LOR evaluation. Export if > 0, Import if < 0. This value is the same as LORNETINTERCHANGEUNDERSCARCITY.
SURPLUSCAPACITY numeric(12, 2) numeric(12, 2) Regional surplus capacity (MW), +/- values indicate surplus/deficit capacity respectively. This value reflects Regional LOR reserve.
SURPLUSRESERVE numeric(12, 2) numeric(12, 2) Regional surplus reserve (MW). This value also reflects Regional LOR reserve. Note: For LOR runs, RESERVEREQ requirement input is not used.
RESERVECONDITION numeric(1, 0) tinyint Regional reserve condition from LRC run. This field is not populated after 30 July 2025.
MAXSURPLUSRESERVE numeric(12, 2) numeric(12, 2) Maximum Surplus Reserve (MW) evaluated for this region from LRC runs. This field is no longer populated.
MAXSPARECAPACITY numeric(12, 2) numeric(12, 2) Maximum Spare Capacity (MW) evaluated for this region. Calculated for each region in turn. This value reflects Regional LOR reserve.
LORCONDITION numeric(1, 0) tinyint Lack of Reserve Condition (LOR) flag for this region and interval (3 = LOR3, 2 = LOR2, 1 = LOR1, 0 = No LOR)
AGGREGATECAPACITYAVAILABLE numeric(12, 2) numeric(12, 2) 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
AGGREGATESCHEDULEDLOAD numeric(12, 2) numeric(12, 2) Sum of MAXAVAIL quantities bid by of all Scheduled Loads in a given Region for a given PERIODID.
LASTCHANGED datetime(3) datetime2(0) Date time this record was created.
AGGREGATEPASAAVAILABILITY numeric(12, 0) int Sum of PASAAVAILABILITY for all scheduled generating units and scheduled bidirectional units (Gen side) with a Recall_Period <= 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.
ENERGYREQDEMAND10 numeric(12, 2) numeric(12, 2) Energy (GWh) required for this energy block based on the 10% probability of exceedance demand. Listed in the first interval of the energy block
CALCULATEDLOR1LEVEL numeric(16, 6) numeric(16, 6) Region Reserve Level for LOR1 used. Can be static value or calculated value if an interconnector is a credible contingency
CALCULATEDLOR2LEVEL numeric(16, 6) numeric(16, 6) Region Reserve Level for LOR2 used. Can be static value or calculated value if an interconnector is a credible contingency
MSRNETINTERCHANGEUNDERSCARCITY numeric(12, 2) numeric(12, 2) Net interconnector flow from the region for this interval from the MSR assessment. This field is no longer populated.
LORNETINTERCHANGEUNDERSCARCITY numeric(12, 2) numeric(12, 2) Net interconnector flow from the region for this interval from the LOR assessment
TOTALINTERMITTENTGENERATION numeric(15, 5) numeric(15, 5) Allowance made for non-scheduled generation in the demand forecast (MW).
DEMAND_AND_NONSCHEDGEN numeric(15, 5) numeric(15, 5) Sum of Cleared Scheduled generation, imported generation (at the region boundary) and allowances made for non-scheduled generation (MW).
UIGF numeric(12, 2) numeric(12, 2) Regional aggregated Unconstrained Intermittent Generation Forecast of Semi-scheduled generation (MW).
SEMISCHEDULEDCAPACITY numeric(12, 2) numeric(12, 2) Constrained generation forecast (MW) for semi-scheduled units for the region. For OUTAGE_LRC run and LOR run, semi-scheduled generation is constrained by both System Normal and Outage constraints. All run types (OUTAGE_LRC, LOR) incorporate MAXAVAIL limits.
LOR_SEMISCHEDULEDCAPACITY numeric(12, 2) numeric(12, 2) 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.
LCR numeric(16, 6) numeric(16, 6) Largest Credible Risk. MW value for highest credible contingency
LCR2 numeric(16, 6) numeric(16, 6) Two Largest Credible Risks. MW value for highest two credible contingencies.
FUM numeric(16, 6) numeric(16, 6) Forecasting Uncertainty Measure. MW value of reserve calculated as defined in the Reserve Level Declaration Guidelines
SS_SOLAR_UIGF numeric(12, 2) numeric(12, 2) Unconstrained Intermittent Generation Forecast for solar for the region. For OUTAGE_LRC run, this is the POE90 forecast (determined by LRCUIGFOption in CaseSolution). For LOR run, this is the POE50 forecast.
SS_WIND_UIGF numeric(12, 2) numeric(12, 2) Unconstrained Intermittent Generation Forecast for wind for the region. For OUTAGE_LRC run, this is the POE90 forecast (determined by LRCUIGFOption in CaseSolution). For LOR run, this is the POE50 forecast.
SS_SOLAR_CAPACITY numeric(12, 2) numeric(12, 2) Constrained generation forecast for solar for the region. For OUTAGE_LRC run and LOR run. solar generation is constrained by both System Normal and Outage constraints. All run types (OUTAGE_LRC, LOR) incorporate MAXAVAIL limits.
SS_WIND_CAPACITY numeric(12, 2) numeric(12, 2) Constrained generation forecast for wind for the region. For OUTAGE_LRC run and LOR run, wind generation is constrained by both System Normal and Outage constraints. All run types (OUTAGE_LRC, LOR) incorporate MAXAVAIL limits.
SS_SOLAR_CLEARED numeric(12, 2) numeric(12, 2) Constrained generation forecast (MW) for solar for the region. For OUTAGE_LRC run and LOR run, solar generation is constrained by both System Normal and Outage constraints. All run types (OUTAGE_LRC, LOR) incorporate MAXAVAIL limits. This value is the same as SS_SOLAR_CAPACITY.
SS_WIND_CLEARED numeric(12, 2) numeric(12, 2) Constrained generation forecast (MW) for wind for the region. For OUTAGE_LRC run and LOR run, wind generation is constrained by both System Normal and Outage constraints. All run types (OUTAGE_LRC, LOR) incorporate MAXAVAIL limits. This value is the same as SS_WIND_CAPACITY.
WDR_AVAILABLE numeric(12, 2) numeric(12, 2) Regional aggregated Wholesale Demand Response (WDR) availability in MW.
WDR_CAPACITY numeric(12, 2) numeric(12, 2) Regional aggregated Wholesale Demand Response (WDR) capacity in MW.
WDR_PASAAVAILABLE numeric(12, 2) numeric(12, 2) Regional aggregated Wholesale Demand Response (WDR) PASA availability in MW.

Official MMS data model indexes

Index name Index type Index columns (in order)
PDPASA_REGIONSOLUTION_LCX nonclustered LASTCHANGED
PDPASA_REGIONSOLUTION_PK clustered, unique, primary key RUN_DATETIME, RUNTYPE, INTERVAL_DATETIME, REGIONID

GR-MMS data model indexes

Index name Index type Index columns (in order)
IX_PDPASA_REGIONSOLUTION_LASTCHANGED nonclustered LASTCHANGED
PK_PDPASA_REGIONSOLUTION clustered, unique, primary key RUN_DATETIME, RUNTYPE, INTERVAL_DATETIME, REGIONID

Historical-MMS data model indexes

Index name Index type Index columns (in order)
PDPASA_REGIONSOLUTION_CCI clustered, columnstore n/a
PK_PDPASA_REGIONSOLUTION nonclustered, unique, primary key RUN_DATETIME, RUNTYPE, INTERVAL_DATETIME, REGIONID