predispatch__constraint_solution__5
AEMO Description
PREDISPATCHCONSTRAINT sets out constraints that are binding
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 1 |
| Combined Rows | 1,128,711,600 |
| Combined Size | 9.73 GiB |
| MMS Table | predispatchconstraint |
| Unified View | nemwebviews.predispatch__constraint_solution__5 |
Schema Evolution
| Column | Type | Description | f07ad67f |
|---|---|---|---|
CONSTRAINTID |
LowCardinality(String) |
Generic constraint identifier | ✓ |
DATETIME |
Nullable(DateTime64(3)) |
Period date and time | ✓ |
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 |
|---|---|---|
f07ad67f |
1,128,711,600 | 9.73 GiB |
Last updated: 2025-12-10 08:00:07