BILLINGIRAUCSURPLUS
BILLINGIRAUCSURPLUS supports the Settlements Residue Auction, by showing the weekly billing Interconnector Residue (IR) payments as calculated for each bill run for Network Service Providers (NSPs) from the amount not auctioned.
Package
BILLING_RUN
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CONTRACTYEAR |
numeric(4, 0)  |
smallint |
SRA Contracted Year (calendar year) |
| WEEKNO |
numeric(2, 0) |
tinyint |
Week no within the contract year. Week no 1 is the week containing 1st January |
| BILLRUNNO |
numeric(3, 0) |
smallint |
The sequential number of a billing run |
| CONTRACTID |
varchar(30) |
varchar(30) |
SRA Contract unique identifier |
| PARTICIPANTID |
varchar(10) |
varchar(10) |
Unique participant identifier |
| INTERCONNECTORID |
varchar(10) |
varchar(10) |
Contracted Interconnector |
| FROMREGIONID |
varchar(10) |
varchar(10) |
Nominated source region for Interconnector |
| RESIDUEYEAR |
numeric(4, 0) |
smallint |
Year of the Residue Contract; may differ from the calendar year at week 1. |
| QUARTER |
numeric(2, 0) |
tinyint |
Residue Contract Quarter |
| TOTALRESIDUES |
numeric(15, 5) |
numeric(15, 5) |
Total residues allocated to participant |
| ADJUSTMENT |
numeric(15, 5) |
numeric(15, 5) |
Adjustment allocated to participant |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Date and time this record was last modified |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLINGAUCSURPLUS_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, CONTRACTID, INTERCONNECTORID, FROMREGIONID, PARTICIPANTID |
| BILLINGIRAUCSURPLUS_IDX_LC |
nonclustered |
LASTCHANGED |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_BILLINGIRAUCSURPLUS_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_BILLINGIRAUCSURPLUS |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, CONTRACTID, INTERCONNECTORID, FROMREGIONID, PARTICIPANTID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLINGAUCSURPLUS_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, CONTRACTID, INTERCONNECTORID, FROMREGIONID, PARTICIPANTID |
| BILLINGIRAUCSURPLUS_IDX_LC |
nonclustered |
LASTCHANGED |