Skip to content

SET_IRSR_DIRECTIONAL_LINK

This report contains the MW Flow and Inter-Regional Residue Amounts for all primary interconnectors.

Package

SETTLEMENT_DATA

Visibility

Public

Table schema

Column Official MMS Datatype GR-MMS Datatype Comment
SETTLEMENTDATE datetime(3) 🔑 datetime2(0) 🔑 The Settlement Date of the Billing Week
VERSIONNO numeric(3, 0) 🔑 smallint 🔑 The Settlement Run No
PERIODID numeric(3, 0) 🔑 smallint 🔑 The Settlement Period Id(1-288)
INTERCONNECTORID varchar(20) 🔑 varchar(20) 🔑 The Interconnector Identifier
FROMREGIONID varchar(20) 🔑 varchar(10) 🔑 The Exporting Region Identifier
INTERCONNECTORLOOPID varchar(20) varchar(20) The Interconnector Loop Identifier, Blank if Interconnector not part of the loop
MWFLOW numeric(18, 8) numeric(18, 8) Consumed Energy in MWh
SURPLUSVALUE numeric(18, 8) numeric(18, 8) Updated Surplus Value for the primary interconnector
ORG_SURPLUSVALUE numeric(18, 8) numeric(18, 8) Original Surplus Value
LASTCHANGED datetime(3) datetime2(0) The last changed date time of the record

Official MMS data model indexes

Index name Index type Index columns (in order)
SET_IRSR_DIRECTIONAL_LINK_PK clustered, unique, primary key SETTLEMENTDATE, VERSIONNO, PERIODID, INTERCONNECTORID, FROMREGIONID

GR-MMS data model indexes

Index name Index type Index columns (in order)
PK_SET_IRSR_DIRECTIONAL_LINK clustered, unique, primary key SETTLEMENTDATE, VERSIONNO, PERIODID, INTERCONNECTORID, FROMREGIONID

Historical-MMS data model indexes

Index name Index type Index columns (in order)
PK_SET_IRSR_DIRECTIONAL_LINK clustered, unique, primary key SETTLEMENTDATE, VERSIONNO, PERIODID, INTERCONNECTORID, FROMREGIONID