Table: BILLINGIRNSPSURPLUS

BILLINGIRNSPSURPLUS

Name

BILLINGIRNSPSURPLUS

Comment

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).


Description

BILLINGIRNSPSURPLUS data is confidential to the relevant participant.

Source

BILLINGIRNSPSURPLUS updates in a billing run where any derogated Settlement Residue Auction purchase flows to a TNSP.

Volume

BILLINGIRNSPSURPLUS 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

AEMO Contract Year number starting in week containing 1st January

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