MCC_CONSTRAINTSOLUTION
Constraint solution data from the MCC dispatch rerun process. Note only constraints with a non-zero marginal value are published.
Package
MCC_DISPATCH
Visibility
Private, Public Next-Day
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| RUN_DATETIME |
datetime(3)  |
datetime2(0) |
5-minute Dispatch Run identifier |
| CONSTRAINTID |
varchar(20) |
varchar(20) |
Generic Constraint identifier (synonymous with GenConID) |
| RHS |
numeric(15, 5) |
numeric(15, 5) |
Generic Constraint RHS Value for this MCC run |
| MARGINALVALUE |
numeric(15, 5) |
numeric(15, 5) |
Generic Constraint Marginal Value for this MCC run |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MCC_CONSTRAINTSOLUTION_PK |
clustered, unique, primary key |
RUN_DATETIME, CONSTRAINTID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_MCC_CONSTRAINTSOLUTION |
clustered, unique, primary key |
RUN_DATETIME, CONSTRAINTID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MCC_CONSTRAINTSOLUTION_CCI |
clustered, columnstore |
n/a |
| PK_MCC_CONSTRAINTSOLUTION |
nonclustered, unique, primary key |
CONSTRAINTID, RUN_DATETIME |