BILLINGDAYTRK
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.
Package
BILLING_RUN
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 |
| BILLRUNNO |
numeric(3, 0) |
smallint |
Unique run no within a given contract year and week no |
| SETTLEMENTDATE |
datetime(3) |
datetime2(0) |
Calendar Settlement Date contained in the billing run. |
| RUNNO |
numeric(3, 0) |
smallint |
Settlement run number used for each settlement date in that billing run. |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLINGDAYTRK_LCX |
nonclustered |
LASTCHANGED |
| BILLINGDAYTRK_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, SETTLEMENTDATE |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_BILLINGDAYTRK_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_BILLINGDAYTRK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, SETTLEMENTDATE |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BILLINGDAYTRK_LCX |
nonclustered |
LASTCHANGED |
| BILLINGDAYTRK_PK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, SETTLEMENTDATE |