billing__nmas_tst_recvry_rbf__1
AEMO Description
BILLING_NMAS_TEST_RECVRY_RBF sets out the NSCAS/SRAS Testing
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 1 |
| Combined Rows | 470 |
| Combined Size | 4.32 KiB |
| MMS Table | billing_nmas_tst_recvry_rbf |
| Unified View | nemwebviews.billing__nmas_tst_recvry_rbf__1 |
Schema Evolution
| Column | Type | Description | 45a8b685 |
|---|---|---|---|
BILLRUNNO |
Nullable(Float64) |
The current Billing RunNo for the week | ✓ |
CONTRACTID |
LowCardinality(String) |
The NMAS Contract Id | ✓ |
CONTRACTYEAR |
Nullable(Float64) |
AEMO Contract Year number starting in week containing 1 January | ✓ |
LASTCHANGED |
Nullable(DateTime64(3)) |
The Last Updated date and time | ✓ |
PAYMENT_AMOUNT |
Nullable(Float64) |
The total Testing Payment Amount to recover from all benefitting regions | ✓ |
RBF |
Nullable(Float64) |
The Benefitting Factor for the RegionId | ✓ |
RECOVERY_AMOUNT |
Nullable(Float64) |
The Testing Payment amount to recover from RegionId | ✓ |
REGIONID |
LowCardinality(String) |
The region from where the amount is recovered | ✓ |
SERVICE |
LowCardinality(String) |
The type of NSCAS service. Current value values are: | ✓ |
WEEKNO |
Nullable(Float64) |
Week no within the contract year. Week no 1 is the week containing 1 January | ✓ |
processed_at |
DateTime64(3) |
✓ | |
source_zip |
String |
✓ |
Schema Versions
| Version | Rows | Size |
|---|---|---|
45a8b685 |
470 | 4.32 KiB |
Last updated: 2025-12-10 08:00:04