Skip to content

SET_IRSR_LOOP_REGION_SUMMARY

This report contains Inter-Regional Net Loop Allocations and Net Regional Export Quantities.

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)
REGIONID varchar(20) 🔑 varchar(10) 🔑 The Region Id
INTERCONNECTORLOOPID varchar(20) 🔑 varchar(20) 🔑 The Interconnector Loop Identifier
POSLOOPALLOCATION numeric(18, 8) numeric(18, 8) Total Positive Allocation across the Loop
NEGLOOPALLOCATION numeric(18, 8) numeric(18, 8) Total Negative Allocation across the Loop
NLA numeric(18, 8) numeric(18, 8) Net Loop Allocation(can be positive or negative)
EXPORT_MWH numeric(18, 8) numeric(18, 8) Total Export Flow in MWh for the Region
IMPORT_MWH numeric(18, 8) numeric(18, 8) Total Import Flow in MWh for the Region
NETREGIONAL_MWH numeric(18, 8) numeric(18, 8) Net Flow for the Region
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_LOOPREGION_SUMMARY_PK clustered, unique, primary key SETTLEMENTDATE, VERSIONNO, PERIODID, REGIONID, INTERCONNECTORLOOPID

GR-MMS data model indexes

Index name Index type Index columns (in order)
PK_SET_IRSR_LOOP_REGION_SUMMARY clustered, unique, primary key SETTLEMENTDATE, VERSIONNO, PERIODID, REGIONID, INTERCONNECTORLOOPID

Historical-MMS data model indexes

Index name Index type Index columns (in order)
PK_SET_IRSR_LOOP_REGION_SUMMARY clustered, unique, primary key SETTLEMENTDATE, VERSIONNO, PERIODID, REGIONID, INTERCONNECTORLOOPID