stpasa__interconnectorsoln__3
AEMO Description
STPASA_INTERCONNECTORSOLN shows the results of the capacity
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 1 |
| Combined Rows | 115,511,616 |
| Combined Size | 632.85 MiB |
| MMS Table | stpasa_interconnectorsoln |
| Unified View | nemwebviews.stpasa__interconnectorsoln__3 |
Schema Evolution
| Column | Type | Description | f52e3adf |
|---|---|---|---|
CALCULATEDEXPORTLIMIT |
Nullable(Float64) |
Calculated Interconnector limit of exporting energy on the basis of invoked constraints and static interconnector export limit | ✓ |
CALCULATEDIMPORTLIMIT |
Nullable(Float64) |
Calculated Interconnector limit of importing energy on the basis of invoked constraints and static interconnector import limit. Note unlike the input interconnector import limit this is a directional quantity and should be defined with respect to the interconnector flow. | ✓ |
CAPACITYMARGINALVALUE |
Nullable(Float64) |
Capacity adequacy assessment marginal value, 0 if not binding | ✓ |
CAPACITYMWFLOW |
Nullable(Float64) |
Interconnector loading level (MW) that can be reached in case of capacity scarcity in neighbouring regions subject to network and energy constraints | ✓ |
CAPACITYVIOLATIONDEGREE |
Nullable(Float64) |
Capacity adequacy assessment violation degree for interconnector capacity; 0 if not violating | ✓ |
EXPORTLIMITCONSTRAINTID |
LowCardinality(String) |
ID of the constraint that sets the Interconnector Export Limit | ✓ |
IMPORTLIMITCONSTRAINTID |
LowCardinality(String) |
ID of the constraint that sets the Interconnector Import Limit | ✓ |
INTERCONNECTORID |
LowCardinality(String) |
Interconnector Identifier | ✓ |
INTERVAL_DATETIME |
Nullable(DateTime64(3)) |
The unique identifier for the interval within this study | ✓ |
LASTCHANGED |
Nullable(DateTime64(3)) |
Last changed date of this record | ✓ |
RUNTYPE |
LowCardinality(String) |
Type of run. Values are RELIABILITY_LRC, OUTAGE_LRC and LOR. | ✓ |
RUN_DATETIME |
Nullable(DateTime64(3)) |
Unique Timestamp Identifier for this study | ✓ |
STUDYREGIONID |
LowCardinality(String) |
Primary Region for LP Solve (or MARKET if none). | ✓ |
processed_at |
DateTime64(3) |
✓ | |
source_zip |
String |
✓ |
Schema Versions
| Version | Rows | Size |
|---|---|---|
f52e3adf |
115,511,616 | 632.85 MiB |
Last updated: 2025-12-10 08:00:08