BILLING_NMAS_TST_RECVRY_TRK
BILLING_NMAS_TEST_RECVRY_TRK tracks the energy data used to allocate the test payment recovery over the recovery period. This Table may also be used for NSCAS and Type 1 transitional services procured by AEMO under the ISF framework during 2025 and prior to the implementation of all system changes. During this time descriptions in these tables may not be correct.
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 1 January |
| WEEKNO |
numeric(3, 0) |
smallint |
Week no within the contract year. Week no 1 is the week containing 1 January |
| BILLRUNNO |
numeric(3, 0) |
smallint |
The current Billing RunNo for the week |
| RECOVERY_CONTRACTYEAR |
numeric(4, 0) |
smallint |
AEMO Contract Year for energy data used in recovery calculation |
| RECOVERY_WEEKNO |
numeric(3, 0) |
smallint |
Week no for energy data used in recovery calculation |
| RECOVERY_BILLRUNNO |
numeric(3, 0) |
smallint |
Billing RunNo for energy data used in recovery calculation |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_BILLING_NMAS_TST_RECVRY_TRK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, RECOVERY_CONTRACTYEAR, RECOVERY_WEEKNO, RECOVERY_BILLRUNNO |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_BILLING_NMAS_TST_RECVRY_TRK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, RECOVERY_CONTRACTYEAR, RECOVERY_WEEKNO, RECOVERY_BILLRUNNO |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_BILLING_NMAS_TST_RECVRY_TRK |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, RECOVERY_CONTRACTYEAR, RECOVERY_WEEKNO, RECOVERY_BILLRUNNO |