Table: BILLINGSMELTERREDUCTION

BILLINGSMELTERREDUCTION

Name

BILLINGSMELTERREDUCTION

Comment

BILLINGSMELTERREDUCTION shows the smelter reduction payment (only applies to participants with Victorian customer connection points).


Description

BILLINGSMELTERREDUCTION data is confidential to the relevant participant.

Source

BILLINGSMELTERREDUCTION is populated by the posting of a billing run where the participant has Victorian customer connectionpoints.

Volume

One record inserted per billing run, or 11 records inserted per week.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

BILLRUNNO

CONTRACTYEAR

PARTICIPANTID

WEEKNO


Index Columns

Name

PARTICIPANTID


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

CONTRACTYEAR

NUMBER(22,0)

X

AEMO Contract Year number starting in week containing 1st January

WEEKNO

NUMBER(22,0)

X

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

BILLRUNNO

NUMBER(22,0)

X

Unique run no within a given contract year and week no

PARTICIPANTID

VARCHAR2(10)

X

Unique participant identifier

RATE1

NUMBER(15,6)

 

Rate in $/MWh

RA1

NUMBER(15,6)

 

Payment

RATE2

NUMBER(15,6)

 

Rate in $/MWh

RA2

NUMBER(15,6)

 

Payment

TE

NUMBER(15,6)

 

Tabulated Energy

PCSD

NUMBER(15,6)

 

Victorian Demand as defined by Code Chapter 9 definitions

LASTCHANGED

DATE

 

Last date and time record changed