Table: BILLINGIRAUCSURPLUS

BILLINGIRAUCSURPLUS

Name

BILLINGIRAUCSURPLUS

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.


Description

Source

Obsolete

Volume

This view contains a maximum of 30, 000 records per year.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

BILLRUNNO

CONTRACTID

CONTRACTYEAR

FROMREGIONID

INTERCONNECTORID

PARTICIPANTID

WEEKNO


Index Columns

Name

LASTCHANGED


Content

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