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 |