DISPATCH_INTERCONNECTION

Inter-regional flow information common to or aggregated for regulated (i. e. not MNSP) Interconnectors spanning the From-Region and To-Region - NB only the physical run is calculated.

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
INTERVENTION	numeric(2, 0)	bit	Intervention case or not
FROM_REGIONID	varchar(20)	varchar(20)	Nominated RegionID from which the energy flows
TO_REGIONID	varchar(20)	varchar(20)	Nominated RegionID to which the energy flows
IRLF	numeric(15, 5)	numeric(15, 5)	Inter-Regional Loss Factor. Calculated based on the MWFLOW and the nominal From and To Region losses.
MWFLOW	numeric(16, 6)	numeric(16, 6)	Summed MW flow of the parallel regulated Interconnectors
METEREDMWFLOW	numeric(16, 6)	numeric(16, 6)	Summed Metered MW flow of the parallel regulated Interconnectors
FROM_REGION_MW_LOSSES	numeric(16, 6)	numeric(16, 6)	Losses across the Interconnection attributable to the nominal From Region
TO_REGION_MW_LOSSES	numeric(16, 6)	numeric(16, 6)	Losses across the Interconnection attributable to the nominal To Region
LASTCHANGED	datetime(3)	datetime2(0)	The datetime that the record was last changed
RUNNO	numeric(3, 0)	-	-
DISPATCHINTERVAL	numeric(22, 0)	-	-

Official MMS data model indexes

Index name	Index type	Index columns (in order)
DISPATCH_INTERCONNECTION_PK	clustered, unique, primary key	SETTLEMENTDATE, RUNNO, FROM_REGIONID, TO_REGIONID, INTERVENTION

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
PK_DISPATCH_INTERCONNECTION	clustered, unique, primary key	SETTLEMENTDATE, INTERVENTION, FROM_REGIONID, TO_REGIONID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
PK_DISPATCH_INTERCONNECTION	clustered, unique, primary key	SETTLEMENTDATE, INTERVENTION, FROM_REGIONID, TO_REGIONID