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 |