Skip to content

SET_IRSR_LOOP_NETTRADE_AMOUNT

This report contains the final net trade amount for the two directional interconnectors to allocate.

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
NLA numeric(18, 8) numeric(18, 8) Net Loop Allocation(can be positive or negative)
NETREGIONAL_MWH numeric(18, 8) numeric(18, 8) Net Flow for the Region
REGIONRRP numeric(18, 8) numeric(18, 8) Exporting Region RRP
RRPDIFF numeric(18, 8) numeric(18, 8) Importing and Exporting Region RRP difference
NOTIONALAMOUNT numeric(18, 8) numeric(18, 8) Notional Amount for each direction interconnector
PROVNETTRADEAMOUNT numeric(18, 8) numeric(18, 8) Provisional Net Trade Amount based on the Positive Allocation
FINALNETTRADEAMOUNT numeric(18, 8) numeric(18, 8) Final Net Trade Amount
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_LOOP_NETTRADE_AMT_PK clustered, unique, primary key SETTLEMENTDATE, VERSIONNO, PERIODID, INTERCONNECTORID, FROMREGIONID, INTERCONNECTORLOOPID

GR-MMS data model indexes

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

Historical-MMS data model indexes

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