Table: BILLINGIRNSPSURPLUSSUM

BILLINGIRNSPSURPLUSSUM

Name

BILLINGIRNSPSURPLUSSUM

Comment

BILLINGIRNSPSURPLUSSUM contains derogated payments made to TNSPs arising from the Settlements Residue Auction process.


Description

BILLINGIRNSPSURPLUSSUM data is confidential to the relevant participant.

Source

BILLINGIRNSPSURPLUSSUM is populated by the posting of a billing run where derogated payments apply.

Volume

An indicative maximum is two records inserted per billing run, or 22 records inserted per week.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

BILLRUNNO

CONTRACTYEAR

FROMREGIONID

INTERCONNECTORID

PARTICIPANTID

QUARTER

RESIDUEYEAR

WEEKNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

CONTRACTYEAR

NUMBER(4,0)

X

SRA Contracted Year (calendar year)

WEEKNO

NUMBER(3,0)

X

Week no within the contract year. Week no 1 is the week containing 1st January

RESIDUEYEAR

NUMBER(4,0)

X

Year of the Residue Contract; may differ from the calendar year at week 1.

QUARTER

NUMBER(2,0)

X

SRA Contracted Quarter

BILLRUNNO

NUMBER(3,0)

X

The sequential number of a billing run

INTERCONNECTORID

VARCHAR2(10)

X

Contracted Interconnector

FROMREGIONID

VARCHAR2(10)

X

Nominated source region for Interconnector

PARTICIPANTID

VARCHAR2(10)

X

Unique participant identifier

TOTALSURPLUS

NUMBER(15,5)

 

Total residue amount allocated to participant

AUCTIONFEES

NUMBER(15,5)

 

This field is 0.

AUCTIONFEES_GST

NUMBER(15,5)

 

The GST amount on the auction fees, always being zero.

LASTCHANGED

DATE

 

Date and time this record was last modified

CSP_DEROGATION_AMOUNT

NUMBER(18,8)

 

The CSP derogation amount applied as an adjustment to SRA.

UNADJUSTED_IRSR

NUMBER(18,8)

 

The SRA amount unadjusted by CSP.