Table: BILLINGREALLOC

BILLINGREALLOC

Name

BILLINGREALLOC

Comment

BILLINGREALLOC shows reallocation contract values in each billing run, where participants have used reallocations.


Description

BILLINGREALLOC data is confidential to the relevant participant.

Source

BILLINGREALLOC is populated by the posting of a billing run.

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

COUNTERPARTY

PARTICIPANTID

WEEKNO


Index Columns

Name

LASTCHANGED


Index Columns

Name

PARTICIPANTID


Content

Name

Data Type

Mandatory

Comment

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

COUNTERPARTY

VARCHAR2(10)

X

Participant who is the counter party to this contract

VALUE

NUMBER(15,5)

 

Value billed on this contract

LASTCHANGED

DATE

 

Last date and time record changed