Table: BILLINGIRPARTSURPLUSSUM

BILLINGIRPARTSURPLUSSUM

Name

BILLINGIRPARTSURPLUSSUM

Comment

BILLINGIRPARTSURPLUSSUM supports the Settlements Residue Auction, by showing the weekly billing SRA distribution and associated fees to Auction participants.


Description

BILLINGIRPARTSURPLUSSUM data is confidential to the relevant participant.

Source

BILLINGIRPARTSURPLUSSUM is populated by the posting of a billing run where the participant has purchased auction units relating to that billing run.

Volume

An indicative maximum is 16 records inserted per billing run, or 166 records inserted per week.


Primary Key Columns

Name

BILLRUNNO

CONTRACTYEAR

FROMREGIONID

INTERCONNECTORID

PARTICIPANTID

QUARTER

RESIDUEYEAR

WEEKNO


Index Columns

Name

RESIDUEYEAR

QUARTER


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

Residue Contract 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)

 

Total auction fees payable in this week (negative amount). If AUCTIONFEES + AUCTIONFEES_GST >= TOTALSURPLUS then ACTUALPAYMENT is zero.

ACTUALPAYMENT

NUMBER(15,5)

 

Net payment to participant, including auction fees

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.

AUCTIONFEES_TOTALGROSS_ADJ

Number(18,8)

 

The adjusted total Auction fees for the Directional Interconnector. Calculated as the amount of the total fees due from the SRA Auction Participant, pro-rated based on the total surplus for each Directional Interconnector the SRA Auction Participant contracted.