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 |