dispatch__constraint
AEMO Description
DISPATCHCONSTRAINT sets out details of all binding and inter
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 2 |
| Combined Rows | 136,334,629 |
| Combined Size | 1.15 GiB |
| MMS Table | dispatchconstraint |
| Unified View | nemwebviews.dispatch__constraint |
Schema Evolution
| Column | Type | Description | 00670ced | 69c87931 |
|---|---|---|---|---|
CONSTRAINTID |
LowCardinality(String) |
Generic Constraint identifier (synonymous with GenConID) | ✓ | ✓ |
DISPATCHINTERVAL |
Nullable(Float64) |
Dispatch period identifier, from 001 to 288 in format YYYYMMDDPPP. | ✓ | ✓ |
DUID |
Nullable(Float64) |
DUID to which the Constraint is confidential. Null denotes non-confidential | - | ✓ |
DUID |
LowCardinality(String) |
DUID to which the Constraint is confidential. Null denotes non-confidential | ✓ | - |
GENCONID_EFFECTIVEDATE |
Nullable(DateTime64(3)) |
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 |
Nullable(Float64) |
Version number of the Generic Constraint (ConstraintID). This field is used to track the version of this generic constraint applied in this dispatch interval | ✓ | ✓ |
INTERVENTION |
Nullable(Float64) |
Manual Intervention flag, which, if set (1), causes predispatch to solve twice. | ✓ | ✓ |
LASTCHANGED |
Nullable(DateTime64(3)) |
Last date and time record changed | ✓ | ✓ |
LHS |
Nullable(Float64) |
Aggregation of the constraints LHS term solution values | ✓ | ✓ |
MARGINALVALUE |
Nullable(Float64) |
$ Value of binding constraint | ✓ | ✓ |
RHS |
Nullable(Float64) |
Right hand Side value as used in dispatch. | ✓ | ✓ |
RUNNO |
Nullable(Float64) |
Dispatch run no; always 1 | ✓ | ✓ |
SETTLEMENTDATE |
Nullable(DateTime64(3)) |
Market date starting at 04:05 | ✓ | ✓ |
VIOLATIONDEGREE |
Nullable(Float64) |
Degree of violation in MW | ✓ | ✓ |
processed_at |
DateTime64(3) |
✓ | ✓ | |
source_zip |
String |
✓ | ✓ |
Schema Versions
| Version | Rows | Size |
|---|---|---|
00670ced |
30,507,662 | 236.49 MiB |
69c87931 |
105,826,967 | 938.69 MiB |
Last updated: 2026-10-28 14:00:04