Table: BILLINGINTRARESIDUES

BILLINGINTRARESIDUES

Name

BILLINGINTRARESIDUES

Comment

BILLINGINTRARESIDUES shows intra-region settlement residue details for each Transmission Network Service Provider participant by region.


Description

BILLINGINTRARESIDUES is confidential to the relevant participant.

Source

BILLINGINTRARESIDUES is populated by the posting of a billing run, being several times each week.

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

PARTICIPANTID

REGIONID

WEEKNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

ALLOCATION

NUMBER(6,3)

 

TNSP allocation

TOTALSURPLUS

NUMBER(15,5)

 

Total $ residue amount for the region

CONTRACTYEAR

NUMBER(4,0)

X

AEMO Contract Year number starting in week containing 1st January

WEEKNO

NUMBER(3,0)

X

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

BILLRUNNO

NUMBER(3,0)

X

Unique run no within a given contract year and week no

PARTICIPANTID

VARCHAR2(10)

X

Unique participant identifier

SURPLUSVALUE

NUMBER(15,6)

 

Amount TNSP is paid for Intra-Regional Residues

LASTCHANGED

DATE

 

Last changed date

REGIONID

VARCHAR2(10)

X

Region ID