Table: BILLINGDAYTRK

BILLINGDAYTRK

Name

BILLINGDAYTRK

Comment

BILLINGDAYTRK is key for matching settlement versions with billing runs. BILLINGDAYTRK displays the billrunnos per billing week, and the settlement version numbers per settlement day comprising the billrunno.


Description

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

Source

BILLINGDAYTRK is populated by the posting of a billing run, being several times each week.

Volume

Each billing run inserts approximately 7 records, being about 77 records per week.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

BILLRUNNO

CONTRACTYEAR

SETTLEMENTDATE

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

BILLRUNNO

NUMBER(3,0)

X

Unique run no within a given contract year and week no

SETTLEMENTDATE

DATE

X

Calendar Settlement Date contained in the billing run.

RUNNO

NUMBER(3,0)

 

Settlement run number used for each settlement date in that billing run.

LASTCHANGED

DATE

 

Last date and time record changed