p5min__constraintsolution__6
AEMO Description
The Five-Minute Pre-Dispatch (P5Min) is a MMS system providi
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 1 |
| Combined Rows | 1,298,919,270 |
| Combined Size | 11.31 GiB |
| MMS Table | p5min_constraintsolution |
| Unified View | nemwebviews.p5min__constraintsolution__6 |
Schema Evolution
| Column | Type | Description | 4a0a6856 |
|---|---|---|---|
CONSTRAINTID |
LowCardinality(String) |
Constraint identifier (synonymous with GenConID) | ✓ |
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 | ✓ |
INTERVAL_DATETIME |
Nullable(DateTime64(3)) |
The unique identifier for the interval within this study | ✓ |
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 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 cost of constraint (>0 if binding) | ✓ |
RHS |
Nullable(Float64) |
Right Hand Side value in the capacity evaluation | ✓ |
RUN_DATETIME |
Nullable(DateTime64(3)) |
Unique Timestamp Identifier for this study | ✓ |
VIOLATIONDEGREE |
Nullable(Float64) |
Amount of Violation (>0 if violating) | ✓ |
processed_at |
DateTime64(3) |
✓ | |
source_zip |
String |
✓ |
Schema Versions
| Version | Rows | Size |
|---|---|---|
4a0a6856 |
1,298,919,270 | 11.31 GiB |
Last updated: 2025-12-10 08:00:07