Skip to content

PDPASA_FNM_ZONESOLUTION

PDPASA_FNM_ZONESOLUTION shows zone 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
ZONEID varchar(30) 🔑 varchar(30) 🔑 Zone identifier
REGIONID varchar(20) varchar(20) Region identifier of the Region containing this Zone
LORCONDITION numeric(1, 0) tinyint Lack of Reserve Condition (LORCONDITION) > 0 if a supply deficit exists and this Zone contains the 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 exists and this Zone does not contain the 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 (increase) to most probable Demand Forecast (MW)
SCHED_GEN_UNCERTAINTY_MARGIN numeric(12, 2) numeric(12, 2) Aggregate Uncertainty Margin adjustment (decrease) to Scheduled Generation Bid Max Avail (MW)
VRE_GEN_UNCERTAINTY_MARGIN numeric(12, 2) numeric(12, 2) Aggregate Uncertainty Margin adjustment (decrease) 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 at loads = Max(0, Initial Demand minus Cleared Demand) where Cleared Demand = (Cleared Generation minus Cleared Losses minus Cleared Net Interchange) (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_ZONESOLUTION_PK clustered, unique, primary key RUN_DATETIME, RUNTYPE, INTERVAL_DATETIME, ZONEID

GR-MMS data model indexes

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

Historical-MMS data model indexes

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