interconnectorres

dispatch__interconnectorres

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 739,794
Combined Size 25.25 MiB
MMS Table dispatchinterconnectorres
Unified View nemwebviews.dispatch__interconnectorres

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 739,794 25.25 MiB

Last updated: 2026-01-02 16:00:06