DISPATCHCONSTRAINT
DISPATCHCONSTRAINT sets out details of all binding and interregion constraints in each dispatch run. Note: invoked constraints can be established from GENCONSETINVOKE. Binding constraints show as marginal value >$0. Interconnector constraints are listed so RHS (SCADA calculated limits) can be reported.
Package
DISPATCH
Visibility
Private, Public Next-Day
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Market date starting at 04:05 |
| CONSTRAINTID |
varchar(20) |
varchar(20) |
Generic Constraint identifier (synonymous with GenConID) |
| INTERVENTION |
numeric(2, 0) |
bit |
Manual Intervention flag, which, if set (1), causes predispatch to solve twice. |
| RHS |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
Right hand Side value as used in dispatch. |
| MARGINALVALUE |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
$ Value of binding constraint |
| VIOLATIONDEGREE |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
Degree of violation in MW |
| 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 |
| RUNNO |
numeric(3, 0) |
- |
- |
| DISPATCHINTERVAL |
numeric(22, 0) |
- |
- |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| DISPATCHCONSTRAINT_LCX |
nonclustered |
LASTCHANGED |
| DISPATCHCONSTRAINT_NDX2 |
nonclustered |
SETTLEMENTDATE |
| PK_DISPATCHCONSTRAINT |
clustered, unique, primary key |
SETTLEMENTDATE, RUNNO, CONSTRAINTID, DISPATCHINTERVAL, INTERVENTION |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_DISPATCHCONSTRAINT |
clustered, unique, primary key |
SETTLEMENTDATE, INTERVENTION, CONSTRAINTID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| DISPATCHCONSTRAINT_CCI |
clustered, columnstore |
n/a |
| PK_DISPATCHCONSTRAINT |
nonclustered, unique, primary key |
CONSTRAINTID, SETTLEMENTDATE, INTERVENTION |