|
Name |
|
|
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. |
|
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. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Public |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
SETTLEMENTDATE |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
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 |
|
|
|