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 | 1 |
| Combined Rows | 145,384,298 |
| Combined Size | 1.28 GiB |
| MMS Table | dispatchconstraint |
| Unified View | nemwebviews.dispatch__constraint |
Schema Evolution
| Column | Type | Description | 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 | ✓ |
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 |
|---|---|---|
69c87931 |
145,384,298 | 1.28 GiB |
Last updated: 2026-01-02 16:00:05