Skip to content

SET_IRSR_LOOP_NSP_ALLOCATION

This report contains Inter-Regional Negative Residue Amounts to allocate to TNSPs.

Package

SETTLEMENT_DATA

Visibility

Private

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 Identifier
PARTICIPANTID varchar(20) 🔑 varchar(10) 🔑 The TNSP Participant Identifier
INTERCONNECTORLOOPID varchar(20) 🔑 varchar(20) 🔑 The Interconnector Loop Identifier
ALLOCATION numeric(18, 8) numeric(18, 8) Participant Portion %(e.g. 100)
NLA numeric(18, 8) numeric(18, 8) Net Loop Allocation(negative only)
AVGREGION_MWH numeric(18, 8) numeric(18, 8) Annual Regional Demand for the Region
TOTALREGION_MWH numeric(18, 8) numeric(18, 8) Total Annual Regional Demand for all Regions in the Loop
RESIDUE_AMOUNT numeric(18, 8) numeric(18, 8) Calculated Negative Residue Amount based on regional share
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_NSPALLOCATION_PK clustered, unique, primary key SETTLEMENTDATE, VERSIONNO, PERIODID, REGIONID, PARTICIPANTID, INTERCONNECTORLOOPID

GR-MMS data model indexes

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

Historical-MMS data model indexes

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