Table: BILLINGEXCESSGEN

BILLINGEXCESSGEN

Name

BILLINGEXCESSGEN

Comment

BILLINGEXCESSGEN shows the excess generation cost by period for each participant.


Description

Source

Obsolete; was updated weekly with each billing run.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

BILLRUNNO

CONTRACTYEAR

PARTICIPANTID

PERIODID

REGIONID

SETTLEMENTDATE

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

SETTLEMENTDATE

DATE

X

Calendar settlement date record becomes effective

PERIODID

NUMBER(3,0)

X

Settlement interval within the settlement date (1-48) starting at 00:30

EXCESSENERGYCOST

NUMBER(15,5)

 

Cost of excess energy attributed to this customer

LASTCHANGED

DATE

 

Last date and time record changed

REGIONID

VARCHAR2(10)

X

Region Identifier