BILLINGIRNSPSURPLUS
BILLINGIRNSPSURPLUS supports the Settlements Residue Auction (SRA), by showing the weekly billing Interconnector Residue (IR) payments as calculated for each bill run for Transmission Network Service Providers (TNSP) from the amount paid by participants (i. e. derogated amounts).
Package
BILLING_RUN
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CONTRACTYEAR |
numeric(4, 0)  |
smallint |
AEMO Contract Year number starting in week containing 1st January |
| 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) |
| BILLINGIRNSPSURPLUS_LCX |
nonclustered |
LASTCHANGED |
| BILLINGNSPSURPLUS_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, CONTRACTID, INTERCONNECTORID, FROMREGIONID, PARTICIPANTID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_BILLINGIRNSPSURPLUS_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_BILLINGIRNSPSURPLUS |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, CONTRACTID, INTERCONNECTORID, FROMREGIONID, PARTICIPANTID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLINGIRNSPSURPLUS_LCX |
nonclustered |
LASTCHANGED |
| BILLINGNSPSURPLUS_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, CONTRACTID, INTERCONNECTORID, FROMREGIONID, PARTICIPANTID |