Skip to content

PDPASA_FNM_REGIONSOLUTION

PDPASA_FNM_REGIONSOLUTION shows region demand, cleared values of resources, spare capacity, losses for each run type and intervals.

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
RUNTYPE varchar(20) 🔑 varchar(20) 🔑 Run Type (BASE, RELIABILITY, WARNING)
INTERVAL_DATETIME datetime(3) 🔑 datetime2(0) 🔑 End date time of the interval
REGIONID varchar(20) 🔑 varchar(20) 🔑 Region Identifier
LORCONDITION numeric(1, 0) tinyint Lack of Reserve Condition (LORCONDITION) > 0 if a supply deficit exists in the Zone for this Region that contains its Regional Reference Node LORCONDITION = 3 if deficit in BASE run LORCONDITION = 2 if deficit in RELIABILITY run LORCONDITION = 1 if deficit in WARNING run
DEFICITCONDITION numeric(1, 0) tinyint Deficit Condition (DEFICITCONDITION) > 0 if a supply deficit only exists in a Zone for this Region that does not contain its Regional Reference Node DEFICITCONDITION = 3 if deficit in BASE run DEFICITCONDITION = 2 if deficit in RELIABILITY run DEFICITCONDITION = 1 if deficit in WARNING run
INITIALDEMAND numeric(12, 2) numeric(12, 2) Most probable Demand Forecast adjusted by Demand Uncertainty Margin (MW)
DEMAND_UNCERTAINTY_MARGIN numeric(12, 2) numeric(12, 2) Aggregate Uncertainty Margin adjustment to most probable Demand Forecast (MW)
SCHED_GEN_UNCERTAINTY_MARGIN numeric(12, 2) numeric(12, 2) Aggregate Uncertainty Margin adjustment to Scheduled Generation Bid Max Avail (MW)
VRE_GEN_UNCERTAINTY_MARGIN numeric(12, 2) numeric(12, 2) Aggregate Uncertainty Margin adjustment to most probable VRE Forecast (MW)
SCHED_GEN_AUX_LOAD numeric(12, 2) numeric(12, 2) Aggregate Auxiliary Load adjustment to uncertainty-adjusted Bid MaxAvail of all scheduled generating units (MW)
ENERGYUNCONSTRAINED_CLEARED numeric(12, 2) numeric(12, 2) Cleared Generation from non energy-constrained resources - that is, excluding bidirectional units and generating units subject to daily energy limits (MW)
ENERGYCONSTRAINED_CLEARED numeric(12, 2) numeric(12, 2) Cleared Generation from energy-constrained resources - that is, from bidirectional units and generating units subject to daily energy limits (MW)
BDU_CLEARED numeric(12, 2) numeric(12, 2) Cleared Generation (positive) or Consumption (negative) from bidirectional units (MW)
SS_CLEARED numeric(12, 2) numeric(12, 2) Cleared Generation from semi-scheduled generating units (MW)
SS_SOLAR_CLEARED numeric(12, 2) numeric(12, 2) Cleared Generation from semi-scheduled solar generating units (MW)
SS_WIND_CLEARED numeric(12, 2) numeric(12, 2) Cleared Generation from semi-scheduled wind generating units (MW)
SPARECAPACITY numeric(12, 2) numeric(12, 2) Spare Generation Capacity = max(0, Available Generation minus [Cleared Generation minus Cleared Net Interchange]) (MW)
CLEAREDSUPPLY numeric(12, 2) numeric(12, 2) Cleared Generation (MW)
CLEAREDLOSSES numeric(12, 2) numeric(12, 2) Cleared Grid Losses (MW)
CLEAREDNETINTERCHANGE numeric(12, 2) numeric(12, 2) Cleared Net Export (positive) or Net Import (negative) (MW)
CLEAREDDEMAND numeric(12, 2) numeric(12, 2) Cleared Demand (MW)
SUPPLYDEFICIT numeric(12, 2) numeric(12, 2) Supply Deficit (MW) across at all loads in the Region = Max(0, Initial Demand minus Cleared Demand) where Cleared Demand = (Cleared Generation minus Cleared Losses minus Cleared Net Interchange). Supply Deficit = Supply Deficit_RRN + Supply Deficit_NonRRN
SUPPLYDEFICIT_RRN numeric(12, 2) numeric(12, 2) Supply Deficit across all loads in the Zone that contains the Regional Reference Node (MW)
SUPPLYDEFICIT_NONRRN numeric(12, 2) numeric(12, 2) Supply Deficit across all loads in the Zone(s) that do not contain the Regional Reference Node (MW)
LASTCHANGED datetime(3) datetime2(0) Date time this record was created

Official MMS data model indexes

Index name Index type Index columns (in order)
PDPASA_FNM_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)
PDPASA_FNM_REGIONSOLUTION_PK clustered, unique, primary key RUN_DATETIME, RUNTYPE, INTERVAL_DATETIME, REGIONID

Historical-MMS data model indexes

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