|
Name |
|
|
Comment |
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. |
|
Source Obsolete Volume This view contains a maximum of 30, 000 records per year. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTID |
|
CONTRACTYEAR |
|
FROMREGIONID |
|
INTERCONNECTORID |
|
PARTICIPANTID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
SRA Contracted Year (calendar year) |
|
WEEKNO |
NUMBER(2,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1st January |
|
RESIDUEYEAR |
NUMBER(4,0) |
|
Year of the Residue Contract; may differ from the calendar year at week 1. |
|
QUARTER |
NUMBER(2,0) |
|
Residue Contract Quarter |
|
BILLRUNNO |
NUMBER(3,0) |
X |
The sequential number of a billing run |
|
CONTRACTID |
VARCHAR2(30) |
X |
SRA Contract unique identifier |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
INTERCONNECTORID |
VARCHAR2(10) |
X |
Contracted Interconnector |
|
FROMREGIONID |
VARCHAR2(10) |
X |
Nominated source region for Interconnector |
|
TOTALRESIDUES |
NUMBER(15,5) |
|
Total residues allocated to participant |
|
ADJUSTMENT |
NUMBER(15,5) |
|
Adjustment allocated to participant |
|
LASTCHANGED |
DATE |
|
Date and time this record was last modified |
|
|
|