Table: BILLINGCALENDAR

BILLINGCALENDAR

Name

BILLINGCALENDAR

Comment

BILLINGCALENDAR sets out the billing calendar for the year, with week number 1 starting on 1 January. BILLINGCALENDAR advises preliminary and final statement posting date and corresponding settlement for each billing week.


Description

BILLINGCALENDAR is public data, and is available to all participants.

Source

Infrequently, only when inserting billing weeks for a future contractyear.

Volume

52-53 records inserted per contractyear


Primary Key Columns

Name

CONTRACTYEAR

WEEKNO


Index Columns

Name

LASTCHANGED


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

STARTDATE

DATE

 

Start Date of week

ENDDATE

DATE

 

End Date of week

PRELIMINARYSTATEMENTDATE

DATE

 

Preliminary Statement Date

FINALSTATEMENTDATE

DATE

 

Final Statement Date

PAYMENTDATE

DATE

 

Payment Date

LASTCHANGED

DATE

 

Last date and time record changed

REVISION1_STATEMENTDATE

DATE

 

Revision 1 Statement Date for the billing week.

REVISION2_STATEMENTDATE

DATE

 

Revision 2 Statement Date for the billing week.