P5MIN_CONSTRAINTSOLUTION
The Five-Minute Pre-Dispatch (P5Min) is a MMS system providing projected dispatch for 12 Dispatch cycles (one hour). The Five-Minute Pre-dispatch cycle runs every 5-minutes to produce a dispatch and pricing schedule to a 5-minute resolution covering the next hour, a total of twelve periods. P5MIN_CONSTRAINTSOLUTION shows binding and violated constraint results from the capacity evaluation, including the RHS value.
Package
P5MIN
Visibility
Private and Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| RUN_DATETIME |
datetime(3)  |
datetime2(0) |
Unique Timestamp Identifier for this study |
| 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) |
| INTERVENTION |
numeric(2, 0) |
bit |
Flag to indicate if this result set was sourced from the pricing run (INTERVENTION=0) or the physical run(INTERVENTION=1). In the event there is not intervention in the market, both pricing and physical runs correspond to INTERVENTION=0) |
| RHS |
numeric(15, 5) |
numeric(15, 5) |
Right Hand Side value in the capacity evaluation |
| MARGINALVALUE |
numeric(15, 5) |
numeric(15, 5) |
Marginal cost of constraint (>0 if binding) |
| VIOLATIONDEGREE |
numeric(15, 5) |
numeric(15, 5) |
Amount of Violation (>0 if violating) |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| DUID |
varchar(20) |
varchar(10) |
DUID to which the Constraint is confidential. Null denotes non-confidential |
| GENCONID_EFFECTIVEDATE |
datetime(3) |
date |
Effective date of the Generic Constraint (ConstraintID). This field is used to track the version of this generic constraint applied in this dispatch interval |
| GENCONID_VERSIONNO |
numeric(22, 0) |
smallint |
Version number of the Generic Constraint (ConstraintID). This field is used to track the version of this generic constraint applied in this dispatch interval |
| LHS |
numeric(15, 5) |
numeric(15, 5) |
Aggregation of the constraints LHS term solution values |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| P5MIN_CONSTRAINTSOLUTION_LCX |
nonclustered |
LASTCHANGED |
| P5MIN_CONSTRAINTSOLUTION_PK |
clustered, unique, primary key |
RUN_DATETIME, CONSTRAINTID, INTERVAL_DATETIME |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_P5MIN_CONSTRAINTSOLUTION |
clustered, unique, primary key |
RUN_DATETIME, INTERVENTION, CONSTRAINTID, INTERVAL_DATETIME |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| P5MIN_CONSTRAINTSOLUTION_CCI |
clustered, columnstore |
n/a |
| PK_P5MIN_CONSTRAINTSOLUTION |
nonclustered, unique, primary key |
CONSTRAINTID, RUN_DATETIME, INTERVAL_DATETIME, INTERVENTION |