STPASA_FNM_ZONESUMMARY
STPASA_FNM_ZONESUMMARY shows the summary of STPASA outcome for each zone.
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 first half hour ended interval of the run |
| 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 indicates the most severe condition: LORCONDITION = 3 if deficit in BASE run; else LORCONDITION = 2 if deficit in RELIABILITY run; else 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 the Regional Reference Node DEFICITCONDITION indicates the most severe condition: DEFICITCONDITION = 3 if deficit in BASE run; else DEFICITCONDITION = 2 if deficit in RELIABILITY run; else DEFICITCONDITION = 1 if deficit in WARNING run |
| DEMAND50 |
numeric(12, 2) |
numeric(12, 2) |
50% Probability of Exceedance demand forecast (MW) |
| DEMAND50_UNSCHED_GEN |
numeric(12, 2) |
numeric(12, 2) |
50% Probability of Exceedance demand forecast plus Aggregate Generation Forecast of all non-scheduled and exempt generation (MW) |
| SCHED_SS_GEN_CAPACITYAVAIL |
numeric(12, 2) |
numeric(12, 2) |
Aggregate Bid MaxAvail of all scheduled generating units, scheduled bidirectional units (Gen side) and semi-scheduled generating units, with latter capped at UIGF (MW) |
| UNSCHED_GEN_CAPACITYAVAIL |
numeric(12, 2) |
numeric(12, 2) |
Aggregate Generation Forecast of all non-scheduled and exempt generation (MW) |
| SCHED_SS_GEN_PASAAVAIL |
numeric(12, 2) |
numeric(12, 2) |
Aggregate Bid PASAAvailability of all scheduled generating units and scheduled bidirectional units (Gen side) with a Bid Recall Period less than (Interval_DateTime minus Run_DateTime) plus UIGF for all semi-scheduled generating units (MW) |
| SCHED_LOAD_CAPACITYAVAIL |
numeric(12, 2) |
numeric(12, 2) |
Aggregate Bid MaxAvail of all scheduled loads (MW) |
| SS_UIGF |
numeric(12, 2) |
numeric(12, 2) |
Aggregate 50% Probability of Exceedance Unconstrained Intermittent Generation Forecast (UIGF) of all semi-scheduled generating units (MW) |
| SS_SOLAR_UIGF |
numeric(12, 2) |
numeric(12, 2) |
Aggregate 50% Probability of Exceedance Unconstrained Intermittent Generation Forecast (UIGF) of all solar semi-scheduled generating units (MW) |
| SS_WIND_UIGF |
numeric(12, 2) |
numeric(12, 2) |
Aggregate 50% Probability of Exceedance Unconstrained Intermittent Generation Forecast (UIGF) of all wind semi-scheduled generating units (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) |
| STPASA_FNM_ZONESUMMARY_PK |
clustered, unique, primary key |
RUN_DATETIME, INTERVAL_DATETIME, ZONEID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| STPASA_FNM_ZONESUMMARY_PK |
clustered, unique, primary key |
RUN_DATETIME, INTERVAL_DATETIME, ZONEID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| STPASA_FNM_ZONESUMMARY_PK |
clustered, unique, primary key |
RUN_DATETIME, INTERVAL_DATETIME, ZONEID |