Skip to content

DISPATCHINTERCONNECTORRES

DISPATCHINTERCONNECTORRES sets out MW flow and losses on each interconnector for each dispatch period, including fields for the Frequency Controlled Ancillary Services export and import limits and extra reporting of the generic constraints set the energy import and export limits.

Package

DISPATCH

Visibility

Public

Table schema

Column Official MMS Datatype GR-MMS Datatype Comment
SETTLEMENTDATE datetime(3) 🔑 datetime2(0) 🔑 Market date starting at 04:05
INTERCONNECTORID varchar(10) 🔑 varchar(10) 🔑 Interconnector identifier
INTERVENTION numeric(2, 0) 🔑 tinyint 🔑 Intervention case or not
METEREDMWFLOW numeric(15, 5) numeric(15, 5) (not nullable) Metered MW Flow from SCADA.
MWFLOW numeric(15, 5) numeric(15, 5) (not nullable) Target MW Flow for next 5 mins.
MWLOSSES numeric(15, 5) numeric(15, 5) (not nullable) Calculated MW Losses
MARGINALVALUE numeric(15, 5) numeric(15, 5) (not nullable) Shadow price resulting from thermal or reserve sharing constraints on Interconnector import/export (0 unless binding) - NEMDE Solution InterconnectorSolution element \"Price\" attribute
VIOLATIONDEGREE numeric(15, 5) numeric(15, 5) (not nullable) Degree of violation on interconnector constraints
LASTCHANGED datetime(3) datetime2(0) (not nullable) Last changed.
EXPORTLIMIT numeric(15, 5) numeric(15, 5) (not nullable) Calculated export limit applying to energy only.
IMPORTLIMIT numeric(15, 5) numeric(15, 5) (not nullable) Calculated import limit applying to energy only.
MARGINALLOSS numeric(15, 5) numeric(15, 5) (not nullable) Marginal loss factor. Use this to adjust prices between regions.
EXPORTGENCONID varchar(20) varchar(20) Generic Constraint setting the export limit
IMPORTGENCONID varchar(20) varchar(20) Generic Constraint setting the import limit
FCASEXPORTLIMIT numeric(15, 5) numeric(15, 5) Calculated export limit applying to energy + FCAS.
FCASIMPORTLIMIT numeric(15, 5) numeric(15, 5) Calculated import limit applying to energy + FCAS.
LOCAL_PRICE_ADJUSTMENT_EXPORT numeric(10, 2) numeric(10, 2) Aggregate Constraint contribution cost of this Interconnector: Sum(MarginalValue x Factor) for all relevant Constraints, for Export (Factor >= 0)
LOCALLY_CONSTRAINED_EXPORT numeric(1, 0) tinyint 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
LOCAL_PRICE_ADJUSTMENT_IMPORT numeric(10, 2) numeric(10, 2) Aggregate Constraint contribution cost of this Interconnector: Sum(MarginalValue x Factor) for all relevant Constraints, for Import (Factor >= 0)
LOCALLY_CONSTRAINED_IMPORT numeric(1, 0) tinyint 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
RUNNO numeric(3, 0) 🔑 - -
DISPATCHINTERVAL numeric(22, 0) 🔑 - -

Official MMS data model indexes

Index name Index type Index columns (in order)
DISPATCHINTERCONNECTORRES_LCX nonclustered LASTCHANGED
PK_DISPATCHINTERCONNECTORRES clustered, unique, primary key SETTLEMENTDATE, RUNNO, INTERCONNECTORID, DISPATCHINTERVAL, INTERVENTION

GR-MMS data model indexes

Index name Index type Index columns (in order)
PK_DISPATCHINTERCONNECTORRES clustered, unique, primary key SETTLEMENTDATE, INTERVENTION, INTERCONNECTORID

Historical-MMS data model indexes

Index name Index type Index columns (in order)
DISPATCHINTERCONNECTORRES_CCI clustered, columnstore n/a
PK_DISPATCHINTERCONNECTORRES nonclustered, unique, primary key SETTLEMENTDATE, INTERVENTION, INTERCONNECTORID