STPASA_SYSTEMSOLUTION (Historical table)
STPASA_SYSTEMSOLUTION is obsolete from 2005 End of Year Release. For solution information, see Region solution tables. STPASA_SYSTEMSOLUTION showed the results of the system capacity evaluations for each interval of the study.
Package
HISTORICAL_TABLES
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| INTERVAL_DATETIME |
datetime(3)  |
datetime2(0) |
The unique identifier for the interval within this study |
| RUN_DATETIME |
datetime(3) (not nullable) |
datetime2(0) (not nullable) |
Unique Timestamp Identifier for this study |
| SYSTEMDEMAND50 |
numeric(12, 2) |
numeric(12, 2) |
Sum of Demand 50% PoE |
| RESERVEREQ |
numeric(12, 2) |
numeric(12, 2) |
System total reserve requirement |
| UNCONSTRAINEDCAPACITY |
numeric(12, 2) |
numeric(12, 2) |
System energy unconstrained capacity MW subject to energy and network constraints |
| CONSTRAINEDCAPACITY |
numeric(12, 2) |
numeric(12, 2) |
System energy constrained capacity MW subject to energy and network constraints |
| SURPLUSCAPACITY |
numeric(12, 2) |
numeric(12, 2) |
System capacity surplus MW, +/- values indicate surplus/deficit capacity |
| SURPLUSRESERVE |
numeric(12, 2) |
numeric(12, 2) |
System reserve surplus MW, +/- values indicate surplus/deficit reserve |
| RESERVECONDITION |
numeric(1, 0) |
tinyint |
The system reserve condition: 0 Adequate, 1 LRC |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last changed date of this record |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| STPASA_SYSTEMSOLUTION_LCX |
nonclustered |
LASTCHANGED |
| STPASA_SYSTEMSOLUTION_NDX1 |
nonclustered |
RUN_DATETIME |
| SYSTEMSOLUTION_PK |
clustered, unique, primary key |
INTERVAL_DATETIME |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_STPASA_SYSTEMSOLUTION_LASTCHANGED |
nonclustered |
LASTCHANGED |
| IX_STPASA_SYSTEMSOLUTION_RUN_DATETIME |
nonclustered |
RUN_DATETIME |
| PK_STPASA_SYSTEMSOLUTION |
clustered, unique, primary key |
INTERVAL_DATETIME |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| STPASA_SYSTEMSOLUTION_LCX |
nonclustered |
LASTCHANGED |
| STPASA_SYSTEMSOLUTION_NDX1 |
nonclustered |
RUN_DATETIME |
| SYSTEMSOLUTION_PK |
clustered, unique, primary key |
INTERVAL_DATETIME |