predispatch__constraint_solution
AEMO Description
PREDISPATCHCONSTRAINT sets out constraints that are binding
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 2 |
| Combined Rows | 1,745,504,595 |
| Combined Size | 14.82 GiB |
| MMS Table | predispatchconstraint |
| Unified View | nemwebviews.predispatch__constraint_solution |
Schema Evolution
| Column | Type | Description | 558f14b5 | f07ad67f |
|---|---|---|---|---|
CONSTRAINTID |
LowCardinality(String) |
Generic constraint identifier | ✓ | ✓ |
DATETIME |
Nullable(DateTime64(3)) |
Period date and time | ✓ | ✓ |
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) |
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 | ✓ | ✓ |
LASTCHANGED |
Nullable(DateTime64(3)) |
Last date and time record changed | ✓ | ✓ |
LHS |
Nullable(Float64) |
Aggregation of the constraints LHS term solution values | ✓ | ✓ |
MARGINALVALUE |
Nullable(Float64) |
Marginal value of violated constraint | ✓ | ✓ |
PERIODID |
Nullable(Float64) |
Unique period identifier, in the format yyyymmddpp. The period (pp) is 01 to 48, with 01 corresponding to the half-hour ending at 04:30am. | ✓ | ✓ |
PREDISPATCHSEQNO |
Nullable(Float64) |
Unique identifier of predispatch run in the form YYYYMMDDPP with 01 at 04:30 | ✓ | ✓ |
RHS |
Nullable(Float64) |
RHS value used. | ✓ | ✓ |
RUNNO |
Nullable(Float64) |
SPD Predispatch run no, typically 1. It increments if the case is re-run. | ✓ | ✓ |
VIOLATIONDEGREE |
Nullable(Float64) |
Degree of constraint violation | ✓ | ✓ |
processed_at |
DateTime64(3) |
✓ | ✓ | |
source_zip |
String |
✓ | ✓ |
Schema Versions
| Version | Rows | Size |
|---|---|---|
558f14b5 |
19,740,323 | 165.48 MiB |
f07ad67f |
1,725,764,272 | 14.66 GiB |
Last updated: 2026-07-16 05:00:09