nmas_tst_recvry_rbf

billing__nmas_tst_recvry_rbf

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 1,180
Combined Size 7.67 KiB
MMS Table billing_nmas_tst_recvry_rbf
Unified View nemwebviews.billing__nmas_tst_recvry_rbf

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 1,180 7.67 KiB

Last updated: 2026-07-16 05:00:06