Skip to content

BILLINGCALENDAR

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.

Package

BILLING_CONFIG

Visibility

Public

Table schema

Column Official MMS Datatype GR-MMS Datatype Comment
CONTRACTYEAR numeric(4, 0) 🔑 smallint 🔑 AEMO Contract Year number starting in week containing 1st January
WEEKNO numeric(3, 0) 🔑 smallint 🔑 Week no within the contract year. Week no 1 is the week containing 1st January
STARTDATE datetime(3) datetime2(0) Start Date of week
ENDDATE datetime(3) datetime2(0) End Date of week
PRELIMINARYSTATEMENTDATE datetime(3) datetime2(0) Preliminary Statement Date
FINALSTATEMENTDATE datetime(3) datetime2(0) Final Statement Date
PAYMENTDATE datetime(3) datetime2(0) Payment Date
LASTCHANGED datetime(3) datetime2(0) Last date and time record changed
REVISION1_STATEMENTDATE datetime(3) datetime2(0) Revision 1 Statement Date for the billing week.
REVISION2_STATEMENTDATE datetime(3) datetime2(0) Revision 2 Statement Date for the billing week.
REVISION0_STATEMENTDATE datetime(3) datetime2(0) Revision 0 Statement Date for the billing week.
REVISIONS_ATTACHED_TO_FINAL varchar(50) varchar(50) The list of Revisions that are attached in the FINAL Statement of the week
REV0_FINAL_ATTACH_WEEK varchar(10) varchar(10) The FINAL Week where the R0 will be attached.
REV0_PAYMENT_DATE datetime(3) datetime2(0) The payment date of the FINAL week in REV0_FINAL_ATTACH_WEEK.
REV1_FINAL_ATTACH_WEEK varchar(10) varchar(10) The FINAL Week where the R1 will be attached.
REV1_PAYMENT_DATE datetime(3) datetime2(0) The payment date of the FINAL week in REV1_FINAL_ATTACH_WEEK.
REV2_FINAL_ATTACH_WEEK varchar(10) varchar(10) The FINAL Week where the R2 will be attached.
REV2_PAYMENT_DATE datetime(3) datetime2(0) The payment date of the FINAL week in REV2_FINAL_ATTACH_WEEK.

Official MMS data model indexes

Index name Index type Index columns (in order)
BILLINGCALENDAR_LCX nonclustered LASTCHANGED
BILLINGCALENDAR_PK clustered, unique, primary key CONTRACTYEAR, WEEKNO

GR-MMS data model indexes

Index name Index type Index columns (in order)
IX_BILLINGCALENDAR_LASTCHANGED nonclustered LASTCHANGED
PK_BILLINGCALENDAR clustered, unique, primary key CONTRACTYEAR, WEEKNO

Historical-MMS data model indexes

Index name Index type Index columns (in order)
BILLINGCALENDAR_LCX nonclustered LASTCHANGED
BILLINGCALENDAR_PK clustered, unique, primary key CONTRACTYEAR, WEEKNO