billing__runtrk__5
AEMO Description
BILLINGRUNTRK identifies the Statement type (i.e. Status of
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 1 |
| Combined Rows | 1,198 |
| Combined Size | 25.18 KiB |
| MMS Table | billingruntrk |
| Unified View | nemwebviews.billing__runtrk__5 |
Schema Evolution
| Column | Type | Description | e531dd3f |
|---|---|---|---|
ADJ_CLEARED |
LowCardinality(String) |
Flag | ✓ |
AUTHORISEDBY |
Nullable(Float64) |
null, since not used | ✓ |
AUTHORISEDDATE |
Nullable(Float64) |
null, since not used | ✓ |
BILLRUNNO |
Nullable(Float64) |
Sequential run number | ✓ |
CONTRACTYEAR |
Nullable(Float64) |
Year of the run | ✓ |
LASTCHANGED |
Nullable(DateTime64(3)) |
Last date and time record changed | ✓ |
MAKEUP |
Nullable(Float64) |
Not Used | ✓ |
PAYMENTPOSTBY |
Nullable(Float64) |
Who posted the payment | ✓ |
PAYMENTPOSTDATE |
Nullable(Float64) |
When the payment was posted | ✓ |
POSTBY |
Nullable(Float64) |
Who posted the results | ✓ |
POSTDATE |
Nullable(Float64) |
When the results were posted | ✓ |
RECEIPTPOSTBY |
Nullable(Float64) |
null, since not used | ✓ |
RECEIPTPOSTDATE |
Nullable(Float64) |
null, since not used | ✓ |
SHORTFALL |
Nullable(Float64) |
Payment shortfall amount | ✓ |
STATUS |
LowCardinality(String) |
The billing run type, PRELIM, FINAL, REVISE or INTERIM | ✓ |
WEEKNO |
Nullable(Float64) |
Week number of the run | ✓ |
processed_at |
DateTime64(3) |
✓ | |
source_zip |
String |
✓ |
Schema Versions
| Version | Rows | Size |
|---|---|---|
e531dd3f |
1,198 | 25.18 KiB |
Last updated: 2025-12-10 08:00:04