Table: BILLINGINTERRESIDUES

BILLINGINTERRESIDUES

Name

BILLINGINTERRESIDUES

Comment

BILLINGINTERRESIDUES shows interregion residues payable to NSP.


Description

Source

Obsolete, was weekly with billing run.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

BILLRUNNO

CONTRACTYEAR

INTERCONNECTORID

PARTICIPANTID

REGIONID

WEEKNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

ALLOCATION

NUMBER(6,3)

 

May not be necessary

TOTALSURPLUS

NUMBER(15,5)

 

May not be necessary

INTERCONNECTORID

VARCHAR2(10)

X

Unique identifier for an interconnector which joins two regions.

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 NSP is paid for Inter-Regional Residues

LASTCHANGED

DATE

 

Last date and time record changed

REGIONID

VARCHAR2(10)

X

Region ID