mtpasa__interconnectorresult__1
AEMO Description
Interconnector results for interval of max demand per day
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 1 |
| Combined Rows | 284,898 |
| Combined Size | 5.08 MiB |
| MMS Table | mtpasa_interconnectorresult |
| Unified View | nemwebviews.mtpasa__interconnectorresult__1 |
Schema Evolution
| Column | Type | Description | 531af1bc |
|---|---|---|---|
CALCULATEDEXPORTLIMIT |
Nullable(Float64) |
Calculated Interconnector limit of exporting energy on the basis of invoked constraints and static interconnector export limit, averaged across iterations and reference years | ✓ |
CALCULATEDIMPORTLIMIT |
Nullable(Float64) |
Calculated Interconnector limit of importing energy on the basis of invoked constraints and static interconnector import limit, averaged across iterations and reference years | ✓ |
DAY |
Nullable(DateTime64(3)) |
Day this result is for | ✓ |
DEMAND_POE_TYPE |
LowCardinality(String) |
Demand POE type used. Value is POE10 | ✓ |
FLOW10 |
Nullable(Float64) |
The 10th percentile for flows, across iterations and reference years. Positive values indicate exporting, negative values indicate importing (MW) | ✓ |
FLOW50 |
Nullable(Float64) |
The 50th percentile for flows, across iterations and reference years. Positive values indicate exporting, negative values indicate importing (MW) | ✓ |
FLOW90 |
Nullable(Float64) |
The 90th percentile for flows, across iterations and reference years. Positive values indicate exporting, negative values indicate importing (MW) | ✓ |
INTERCONNECTORID |
LowCardinality(String) |
The unique identifier for the interconnector | ✓ |
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) | ✓ |
PROBABILITYOFBINDINGEXPORT |
Nullable(Float64) |
Proportion of iterations and reference years with interconnector constrained when exporting | ✓ |
PROBABILITYOFBINDINGIMPORT |
Nullable(Float64) |
Proportion of iterations and reference years with interconnector constrained when importing | ✓ |
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. | ✓ |
processed_at |
DateTime64(3) |
✓ | |
source_zip |
String |
✓ |
Schema Versions
| Version | Rows | Size |
|---|---|---|
531af1bc |
284,898 | 5.08 MiB |
Last updated: 2025-12-10 08:00:06