Skip to content

STPASA_REGIONSOLUTION

STPASA_REGIONSOLUTION shows the results of the regional capacity, maximum surplus reserve and maximum spare capacity evaluations for each period of the study. Note that the RELIABILITY_LRC and OUTAGE_LRC Run Types are no longer reported from 31 July 2025.

Package

STPASA_SOLUTION

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 nominal start time 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 RELIABILITY_LRC, OUTAGE_LRC and LOR. Note that the STPASA RELIABILITY_LRC and OUTAGE_LRC Run Types are 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 The LOR Condition determined from the Maximum Spare Capacity value: 0 - no condition, 1 - LOR1 condition, 2 - LOR2 condition, 3 - LOR3 condition
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 RELIABILITY_LRC and OUTAGE_LRC runs, UIGF is the POE90 forecast. For the LOR Run, UIGF is the POE50 forecast. Note that the RELIABILITY_LRC and OUTAGE_LRC Run Types are 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 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.
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 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_UIGF numeric(12, 2) numeric(12, 2) 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
SS_SOLAR_CAPACITY numeric(12, 2) numeric(12, 2) 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_WIND_CAPACITY numeric(12, 2) numeric(12, 2) 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_SOLAR_CLEARED numeric(12, 2) numeric(12, 2) Constrained generation forecast (MW) 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.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 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.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)
REGIONSOLUTION_PK clustered, unique, primary key RUN_DATETIME, RUNTYPE, INTERVAL_DATETIME, REGIONID
STPASA_REGIONSOLUTION_LCX nonclustered LASTCHANGED

GR-MMS data model indexes

Index name Index type Index columns (in order)
PK_STPASA_REGIONSOLUTION clustered, unique, primary key RUN_DATETIME, RUNTYPE, INTERVAL_DATETIME, REGIONID

Historical-MMS data model indexes

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