PD7DAY_CONSTRAINTSOLUTION
PD7DAY constraint solution.
Package
PD7DAY
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| RUN_DATETIME |
datetime(3)  |
datetime2(0) |
Unique Timestamp Identifier for this study |
| INTERVENTION |
numeric(2, 0) |
tinyint |
Flag to indicate if this Predispatch case includes an intervention pricing run: 0 = case does not include an intervention pricing run, 1 = case does include an intervention pricing run. |
| INTERVAL_DATETIME |
datetime(3) |
datetime2(0) |
The unique identifier for the interval within this study |
| CONSTRAINTID |
varchar(20) |
varchar(20) |
Constraint identifier (synonymous with GenConID) |
| RHS |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
Right Hand Side value in the capacity evaluation in MW |
| MARGINALVALUE |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
Marginal cost of constraint (>0 if binding) in $/MW |
| VIOLATIONDEGREE |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
Amount of Violation (>0 if violating) in MW |
| LHS |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
Aggregation of the constraints LHS term solution values in MW |
| LASTCHANGED |
datetime(3) |
datetime2(0) (not nullable) |
Last date and time record changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PD7DAY_CONSTRAINTSOLUTION_PK |
clustered, unique, primary key |
RUN_DATETIME, INTERVAL_DATETIME, CONSTRAINTID, INTERVENTION |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_PD7DAY_CONSTRAINTSOLUTION |
clustered, unique, primary key |
RUN_DATETIME, INTERVENTION, INTERVAL_DATETIME, CONSTRAINTID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PD7DAY_CONSTRAINTSOLUTION_CCI |
clustered, columnstore |
n/a |
| PK_PD7DAY_CONSTRAINTSOLUTION |
nonclustered, unique, primary key |
RUN_DATETIME, INTERVENTION, INTERVAL_DATETIME, CONSTRAINTID |