BILLING_NMAS_TST_PAYMENTS
BILLING_NMAS_TEST_PAYMENTS publish the NSCAS / SRAS Testing Payments data for a posted billing week. 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
Private
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 |
| PARTICIPANTID |
varchar(20) |
varchar(20) |
The Participant from whom the amount is recovered |
| SERVICE |
varchar(10) |
varchar(10) |
The type of NSCAS service. Current value values are: - REACTIVE - LOADSHED |
| CONTRACTID |
varchar(10) |
varchar(10) |
The NMAS Contract Id |
| PAYMENT_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The Testing Payment Amount to recover |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_BILLING_NMAS_TST_PAYMENTS |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, SERVICE, CONTRACTID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_BILLING_NMAS_TST_PAYMENTS |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, SERVICE, CONTRACTID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_BILLING_NMAS_TST_PAYMENTS |
clustered, unique, primary key |
CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, SERVICE, CONTRACTID |