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 |