mtpasa__constraintsummary__1
AEMO Description
Constraint Summary results over aggregation periods
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 1 |
| Combined Rows | 16,731,465 |
| Combined Size | 38.02 MiB |
| MMS Table | mtpasa_constraintsummary |
| Unified View | nemwebviews.mtpasa__constraintsummary__1 |
Schema Evolution
| Column | Type | Description | a0ba243c |
|---|---|---|---|
AGGREGATION_PERIOD |
LowCardinality(String) |
Period data is aggregated over. Values are PEAK, SHOULDER, OFFPEAK. PEAK = 14:00-19:59, SHOULDER = 07:00-13:59 and 20:00-21:59, OFFPEAK = 22:00-06:59 | ✓ |
CONSTRAINTHOURSBINDING |
Nullable(Float64) |
Constraint hours binding or violating for period, averaged across iterations and reference years | ✓ |
CONSTRAINTID |
LowCardinality(String) |
The unique identifier for the constraint. Only binding or violating constraints are reported | ✓ |
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 | ✓ |
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 constraintID | ✓ |
processed_at |
DateTime64(3) |
✓ | |
source_zip |
String |
✓ |
Schema Versions
| Version | Rows | Size |
|---|---|---|
a0ba243c |
16,731,465 | 38.02 MiB |
Last updated: 2025-12-10 08:00:06