pd7day__constraintsolution
AEMO Description
PD7DAY constraint solution
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 1 |
| Combined Rows | 272,265,541 |
| Combined Size | 2.28 GiB |
| MMS Table | pd7day_constraintsolution |
| Unified View | nemwebviews.pd7day__constraintsolution |
Schema Evolution
| Column | Type | Description | f04f519e |
|---|---|---|---|
CONSTRAINTID |
LowCardinality(String) |
Constraint identifier (synonymous with GenConID) | ✓ |
INTERVAL_DATETIME |
Nullable(DateTime64(3)) |
The unique identifier for the interval within this study | ✓ |
INTERVENTION |
Nullable(Float64) |
Flag to indicate if this Predispatch case includes an intervention pricing run: 0 = case does not include an intervention pricing run, 1 = case does include an intervention pricing run. | ✓ |
LASTCHANGED |
Nullable(DateTime64(3)) |
Last date and time record changed | ✓ |
LHS |
Nullable(Float64) |
Aggregation of the constraints LHS term solution values in MW | ✓ |
MARGINALVALUE |
Nullable(Float64) |
Marginal cost of constraint (>0 if binding) in $/MW | ✓ |
RHS |
Nullable(Float64) |
Right Hand Side value in the capacity evaluation in MW | ✓ |
RUN_DATETIME |
Nullable(DateTime64(3)) |
Unique Timestamp Identifier for this study | ✓ |
VIOLATIONDEGREE |
Nullable(Float64) |
Amount of Violation (>0 if violating) in MW | ✓ |
processed_at |
DateTime64(3) |
✓ | |
source_zip |
String |
✓ |
Schema Versions
| Version | Rows | Size |
|---|---|---|
f04f519e |
272,265,541 | 2.28 GiB |
Last updated: 2026-07-16 05:00:09