PASACONSTRAINTSOLUTION (Historical table)
PASACONSTRAINTSOLUTION records the latest binding STPASA constraint details for each period. For each solution, the latest recalculation for each period overwrites the previous entry.
Package
HISTORICAL_TABLES
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CONSTRAINTID |
varchar(20)  |
varchar(20) |
Generic Constraint Id |
| PERIODID |
varchar(20) |
varchar(20) |
PASA Interval (48 half hours) |
| CASEID |
varchar(20) (not nullable) |
varchar(20) (not nullable) |
PASA Case Identifier |
| CAPACITYMARGINALVALUE |
numeric(16, 6) |
numeric(16, 6) |
Binding value of capacity and adequacy (if insufficient to measure) |
| CAPACITYVIOLATIONDEGREE |
numeric(16, 6) |
numeric(16, 6) |
Deficit MW of surplus capacity |
| EXCESSGENMARGINALVALUE |
numeric(16, 6) |
numeric(16, 6) |
Binding value of dispatch generator above aggregate self dispatch |
| EXCESSGENVIOLATIONDEGREE |
numeric(16, 6) |
numeric(16, 6) |
Deficit of generator above aggregate self dispatch level |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| DATETIME |
datetime(3) |
datetime2(0) |
Date and time of the end of the period |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PASACONSTRAINTSOLUTION_LCX |
nonclustered |
LASTCHANGED |
| PASACONSTRAINTSOLUTION_PK |
clustered, unique, primary key |
PERIODID, CONSTRAINTID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_PASACONSTRAINTSOLUTION_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_PASACONSTRAINTSOLUTION |
clustered, unique, primary key |
PERIODID, CONSTRAINTID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PASACONSTRAINTSOLUTION_LCX |
nonclustered |
LASTCHANGED |
| PASACONSTRAINTSOLUTION_PK |
clustered, unique, primary key |
PERIODID, CONSTRAINTID |