dispatch__interconnectorres__3
AEMO Description
DISPATCHINTERCONNECTORRES sets out MW flow and losses on eac
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 1 |
| Combined Rows | 699,480 |
| Combined Size | 23.82 MiB |
| MMS Table | dispatchinterconnectorres |
| Unified View | nemwebviews.dispatch__interconnectorres__3 |
Schema Evolution
| Column | Type | Description | 59f7a933 |
|---|---|---|---|
DISPATCHINTERVAL |
Nullable(Float64) |
Dispatch period identifier, from 001 to 288 in format YYYYMMDDPPP. | ✓ |
EXPORTGENCONID |
LowCardinality(String) |
Generic Constraint setting the export limit | ✓ |
EXPORTLIMIT |
Nullable(Float64) |
Calculated export limit applying to energy only. | ✓ |
FCASEXPORTLIMIT |
Nullable(Float64) |
Calculated export limit applying to energy + FCAS. | ✓ |
FCASIMPORTLIMIT |
Nullable(Float64) |
Calculated import limit applying to energy + FCAS. | ✓ |
IMPORTGENCONID |
LowCardinality(String) |
Generic Constraint setting the import limit | ✓ |
IMPORTLIMIT |
Nullable(Float64) |
Calculated import limit applying to energy only. | ✓ |
INTERCONNECTORID |
LowCardinality(String) |
Interconnector identifier | ✓ |
INTERVENTION |
Nullable(Float64) |
Intervention case or not | ✓ |
LASTCHANGED |
Nullable(DateTime64(3)) |
Last changed. | ✓ |
LOCALLY_CONSTRAINED_EXPORT |
Nullable(Float64) |
Key for Local_Price_Adjustment_Export: 2 = at least one Outage Constraint; 1 = at least 1 System Normal Constraint (and no Outage Constraint); 0 = No System Normal or Outage Constraints | ✓ |
LOCALLY_CONSTRAINED_IMPORT |
Nullable(Float64) |
Key for Local_Price_Adjustment_Import: 2 = at least one Outage Constraint; 1 = at least 1 System Normal Constraint (and no Outage Constraint); 0 = No System Normal or Outage Constraints | ✓ |
LOCAL_PRICE_ADJUSTMENT_EXPORT |
Nullable(Float64) |
Aggregate Constraint contribution cost of this Interconnector: Sum(MarginalValue x Factor) for all relevant Constraints, for Export (Factor >= 0) | ✓ |
LOCAL_PRICE_ADJUSTMENT_IMPORT |
Nullable(Float64) |
Aggregate Constraint contribution cost of this Interconnector: Sum(MarginalValue x Factor) for all relevant Constraints, for Import (Factor >= 0) | ✓ |
MARGINALLOSS |
Nullable(Float64) |
Marginal loss factor. Use this to adjust prices between regions. | ✓ |
MARGINALVALUE |
Nullable(Float64) |
Shadow price resulting from thermal or reserve sharing constraints on Interconnector import/export (0 unless binding) - NEMDE Solution InterconnectorSolution element “Price” attribute | ✓ |
METEREDMWFLOW |
Nullable(Float64) |
Metered MW Flow from SCADA. | ✓ |
MWFLOW |
Nullable(Float64) |
Target MW Flow for next 5 mins. | ✓ |
MWLOSSES |
Nullable(Float64) |
Calculated MW Losses | ✓ |
RUNNO |
Nullable(Float64) |
Dispatch run no; always 1 | ✓ |
SETTLEMENTDATE |
Nullable(DateTime64(3)) |
Market date starting at 04:05 | ✓ |
VIOLATIONDEGREE |
Nullable(Float64) |
Degree of violation on interconnector constraints | ✓ |
processed_at |
DateTime64(3) |
✓ | |
source_zip |
String |
✓ |
Schema Versions
| Version | Rows | Size |
|---|---|---|
59f7a933 |
699,480 | 23.82 MiB |
Last updated: 2025-12-10 08:00:05