MTPASA_RESERVELIMITSOLUTION (Historical table)
MTPASA_RESERVELIMITSOLUTION is obsolete from 2017 End of Year DM4.27 Release. MT PASA Solution table reporting whether a MT PASA Reserve requirement is binding for each day and LDC block of the run.
Package
HISTORICAL_TABLES
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| RUN_DATETIME |
datetime(3)  |
datetime2(0) |
Date processing of the run begins |
| RUN_NO |
numeric(3, 0) |
smallint |
Unique run ID. Generated from the solution file Case ID. |
| RUNTYPE |
varchar(20) |
varchar(20) |
Type of run. Values are RELIABILITY_LRC and OUTAGE_LRC |
| ENERGYBLOCK |
datetime(3) |
datetime2(0) |
Sunday at start of the week for this solutions energy block. Generated from the solution file energy block. |
| DAY |
datetime(3) |
datetime2(0) |
Day this solution is for. Generated from the solution file period id. |
| LDCBLOCK |
numeric(3, 0) |
smallint |
Load Duration Curve block this solution is for. Generated from the solution file period id. |
| RESERVELIMITID |
varchar(20) |
varchar(20) |
The unique identifier of the MT PASA LRC Reserve Requirement. |
| MARGINALVALUE |
numeric(16, 6) |
numeric(16, 6) |
Marginal Value of the Reserve Requirement Constraint. A non-zero value indicates that the reserve requirement is binding. |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Timestamp the record was last modified. |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_MTPASA_RESERVELIMITSOLUTION |
clustered, unique, primary key |
RUN_DATETIME, RUN_NO, RUNTYPE, ENERGYBLOCK, DAY, LDCBLOCK, RESERVELIMITID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_MTPASA_RESERVELIMITSOLUTION |
clustered, unique, primary key |
RUN_DATETIME, RUN_NO, RUNTYPE, ENERGYBLOCK, DAY, LDCBLOCK, RESERVELIMITID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_MTPASA_RESERVELIMITSOLUTION |
clustered, unique, primary key |
RUN_DATETIME, RUN_NO, RUNTYPE, ENERGYBLOCK, DAY, LDCBLOCK, RESERVELIMITID |