STPASA_UNITSOLUTION (Historical table)
STPASA_UNITSOLUTION shows the unit results from the capacity evaluations for each period of the study.
Package
HISTORICAL_TABLES
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| RUN_DATETIME |
datetime(3)  |
datetime2(0) |
Unique Timestamp Identifier for this study |
| INTERVAL_DATETIME |
datetime(3) |
datetime2(0) |
The unique identifier for the interval within this study |
| DUID |
varchar(10) |
varchar(10) |
Dispatchable unit Identifier |
| RUNTYPE |
varchar(20) |
varchar(20) |
Type of run. Values are RELIABILITY_LRC and OUTAGE_LRC |
| CONNECTIONPOINTID |
varchar(10) |
varchar(10) |
Connection point identifier |
| EXPECTEDMAXCAPACITY |
numeric(12, 2) |
numeric(12, 2) |
Max MW capacity that can be obtained in case of capacity scarcity from units subject to network and energy constraints. |
| CAPACITYMARGINALVALUE |
numeric(12, 2) |
numeric(12, 2) |
Capacity adequacy assessment marginal value, 0 if not binding |
| CAPACITYVIOLATIONDEGREE |
numeric(12, 2) |
numeric(12, 2) |
Capacity adequacy assessment violation degree for unit capacity; 0 if not violating |
| CAPACITYAVAILABLE |
numeric(12, 2) |
numeric(12, 2) |
The available MW capacity for the period |
| ENERGYCONSTRAINED |
numeric(1, 0) |
tinyint |
0 if not energy constrained, 1 if energy constrained for this energy block |
| ENERGYAVAILABLE |
numeric(10, 0) |
smallint |
The energy limit (MWH) over this energy block for the energy constrained unit |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last changed date of this record |
| PASAAVAILABILITY |
numeric(12, 0) |
smallint |
The physical plant capability including any capability that can be made available within 24 hrs |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| STPASA_UNITSOLUTION_LCX |
nonclustered |
LASTCHANGED |
| UNITSOLUTION_PK |
clustered, unique, primary key |
RUN_DATETIME, RUNTYPE, INTERVAL_DATETIME, DUID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_STPASA_UNITSOLUTION_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_STPASA_UNITSOLUTION |
clustered, unique, primary key |
RUN_DATETIME, RUNTYPE, INTERVAL_DATETIME, DUID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| STPASA_UNITSOLUTION_LCX |
nonclustered |
LASTCHANGED |
| UNITSOLUTION_PK |
clustered, unique, primary key |
RUN_DATETIME, RUNTYPE, INTERVAL_DATETIME, DUID |