MTPASACONSTRAINTSOLUTION_D (Historical table)
MTPASACONSTRAINTSOLUTION_D sets out MT PASA constraint solution results, where constraints are binding.
Package
HISTORICAL_TABLES
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| DATETIME |
datetime(3)  |
datetime2(0) |
Date constraint is binding |
| CONSTRAINT_ID |
varchar(20) |
varchar(20) |
Constraint Identifier |
| DEGREE_OF_VIOLATION |
numeric(16, 6) |
numeric(16, 6) |
The degree in MW by which the constraint would be violated if the solution could not solve. This could be due to incorrect penalties etc. This figure should always be 0. |
| LASTCHANGED |
datetime(3) |
datetime2(0) (not nullable) |
Last changed data and time. |
| RUN_DATETIME |
datetime(3) |
datetime2(0) (not nullable) |
The run date and time |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MTPASACONSOLUTION_D_LCX |
nonclustered |
LASTCHANGED |
| MTPASACONSTRAINTSOLUTION_D_PK |
clustered, unique, primary key |
DATETIME, CONSTRAINT_ID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_MTPASACONSTRAINTSOLUTION_D_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_MTPASACONSTRAINTSOLUTION_D |
clustered, unique, primary key |
DATETIME, CONSTRAINT_ID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MTPASACONSOLUTION_D_LCX |
nonclustered |
LASTCHANGED |
| MTPASACONSTRAINTSOLUTION_D_PK |
clustered, unique, primary key |
DATETIME, CONSTRAINT_ID |