mtpasa__constraintresult__1
AEMO Description
Constraint results for Binding or Violating Constraints
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 1 |
| Combined Rows | 1,654,933 |
| Combined Size | 7.76 MiB |
| MMS Table | mtpasa_constraintresult |
| Unified View | nemwebviews.mtpasa__constraintresult__1 |
Schema Evolution
| Column | Type | Description | cb33226e |
|---|---|---|---|
CONSTRAINTID |
LowCardinality(String) |
The unique identifier for the constraint. Only binding or violating constraints are reported | ✓ |
CONSTRAINTVIOLATION10 |
Nullable(Float64) |
The 10th percentile violation degree for this constraint, across iterations and reference years (MW) | ✓ |
CONSTRAINTVIOLATION50 |
Nullable(Float64) |
The 50th percentile violation degree for this constraint, across iterations and reference years (MW) | ✓ |
CONSTRAINTVIOLATION90 |
Nullable(Float64) |
The 90th percentile violation degree for this constraint, across iterations and reference years (MW) | ✓ |
DAY |
Nullable(DateTime64(3)) |
Day this result is for | ✓ |
DEMAND_POE_TYPE |
LowCardinality(String) |
Demand POE type used. Value is POE10 | ✓ |
EFFECTIVEDATE |
Nullable(DateTime64(3)) |
The effective date of the constraint used | ✓ |
LASTCHANGED |
Nullable(DateTime64(3)) |
Last date and time record changed | ✓ |
PERIODID |
Nullable(Float64) |
Half hourly period reported, selected as period of maximum NEM scheduled demand (calculated as maximum of scheduled demands, averaged across iterations and reference years) | ✓ |
PROBABILITYOFBINDING |
Nullable(Float64) |
Proportion of a constraint binding, across iterations and reference years | ✓ |
PROBABILITYOFVIOLATION |
Nullable(Float64) |
Proportion of a constraint violating, across iterations and reference years | ✓ |
RUNTYPE |
LowCardinality(String) |
Type of run. Always RELIABILITY | ✓ |
RUN_DATETIME |
Nullable(DateTime64(3)) |
Date processing of the run begins. | ✓ |
RUN_NO |
Nullable(Float64) |
Unique run id. | ✓ |
VERSIONNO |
Nullable(Float64) |
The version of the constraint used | ✓ |
processed_at |
DateTime64(3) |
✓ | |
source_zip |
String |
✓ |
Schema Versions
| Version | Rows | Size |
|---|---|---|
cb33226e |
1,654,933 | 7.76 MiB |
Last updated: 2025-12-10 08:00:06