MTPASA_CONSTRAINTSOLUTION (Historical table)
MTPASA_CONSTRAINTSOLUTION is obsolete from 2017 End of Year DM4.27 Release. The MTPASA_CONSTRAINTSOLUTION table holds the binding and violated constraint results from the capacity evaluation, including the RHS value. Change Notice 379 announced the replacement of the MT PASA data model so all MTPASAxxx tables become obsolete, replaced by MTPASA_xxx tables.
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 caseid |
| 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 periodid |
| LDCBLOCK |
numeric(3, 0) |
smallint |
LDC block this solution is for. Generated from the solution file periodid |
| CONSTRAINTID |
varchar(20) |
varchar(20) |
The unique identifier for the constraint |
| RUNTYPE |
varchar(20) |
varchar(20) |
Type of run. Values are RELIABILITY_LRC and OUTAGE_LRC |
| CAPACITYRHS |
numeric(12, 2) |
numeric(12, 2) |
The RHS value in the capacity evaluation |
| 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; 0 if not violating |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Date the solution was loaded |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MTPASA_CONSTRAINTSOLUTION_NDX2 |
nonclustered |
LASTCHANGED |
| MTPASA_CONSTRAINTSOLUTION_PK |
clustered, unique, primary key |
RUN_DATETIME, RUN_NO, RUNTYPE, ENERGYBLOCK, DAY, LDCBLOCK, CONSTRAINTID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_MTPASA_CONSTRAINTSOLUTION |
clustered, unique, primary key |
RUN_DATETIME, RUN_NO, RUNTYPE, ENERGYBLOCK, DAY, LDCBLOCK, CONSTRAINTID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MTPASA_CONSTRAINTSOLUTION_CCI |
clustered, columnstore |
n/a |
| PK_MTPASA_CONSTRAINTSOLUTION |
nonclustered, unique, primary key |
RUN_DATETIME, RUN_NO, RUNTYPE, ENERGYBLOCK, DAY, LDCBLOCK, CONSTRAINTID |