PREDISPATCHCONSTRAINT
PREDISPATCHCONSTRAINT sets out constraints that are binding in each predispatch run and interconnector constraints (whether binding or not). Only binding and interconnector constraints are reported. Binding contracts have marginal value greater than $0. Interconnector constraints are listed so RHS values can be reported for ST PASA. Constraint solutions only report fixed loading /MR constraints on the next day.
Package
PRE_DISPATCH
Visibility
Private, Public Next-Day
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| PREDISPATCHSEQNO |
varchar(20) |
int  |
Unique identifier of predispatch run in the form YYYYMMDDPP with 01 at 04:30 |
| CONSTRAINTID |
varchar(20) |
varchar(20) |
Generic constraint identifier |
| 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 that there is not intervention in the market, both pricing and physical runs correspond to INTERVENTION=0 |
| DATETIME |
datetime(3) |
datetime2(0) |
Period date and time |
| RHS |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
RHS value used. |
| MARGINALVALUE |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
Marginal value of violated constraint |
| VIOLATIONDEGREE |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
Degree of constraint violation |
| LASTCHANGED |
datetime(3) |
datetime2(0) (not nullable) |
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) |
- |
- |
| PERIODID |
varchar(20) |
- |
- |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_PREDISPATCHCONSTRAINT |
clustered, unique, primary key |
DATETIME, CONSTRAINTID |
| PREDISPATCHCONSTRAIN_NDX2 |
nonclustered |
PREDISPATCHSEQNO |
| PREDISPATCHCONSTRAINT_LCX |
nonclustered |
LASTCHANGED |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_PREDISPATCHCONSTRAINT |
clustered, unique, primary key |
PREDISPATCHSEQNO, INTERVENTION, CONSTRAINTID, DATETIME |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_PREDISPATCHCONSTRAINT |
nonclustered, unique, primary key |
CONSTRAINTID, PREDISPATCHSEQNO, INTERVENTION, DATETIME |
| PREDISPATCHCONSTRAINT_CCI |
clustered, columnstore |
n/a |