settlements__daytrack
AEMO Description
DAYTRACK identifies the actual settlement run processed for
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 3 |
| Combined Rows | 16,285 |
| Combined Size | 388.13 KiB |
| MMS Table | daytrack |
| Unified View | nemwebviews.settlements__daytrack |
Schema Evolution
| Column | Type | Description | 62af4f37 | 6ed37142 | 7b400620 |
|---|---|---|---|---|---|
EXANTERUNNO |
Nullable(Float64) |
Not Used | ✓ | ✓ | ✓ |
EXANTERUNSTATUS |
LowCardinality(String) |
Not Used | ✓ | ✓ | ✓ |
EXPOSTRUNNO |
Nullable(Float64) |
Settlement Run No | ✓ | ✓ | ✓ |
EXPOSTRUNSTATUS |
LowCardinality(String) |
Not Used | ✓ | ✓ | ✓ |
LASTCHANGED |
Nullable(DateTime64(3)) |
Last date and time record changed | ✓ | ✓ | ✓ |
METERDATA_SOURCE |
Nullable(Float64) |
✓ | ✓ | ✓ | |
METER_CASEID |
Nullable(Float64) |
The Metering Case Id used for the Settlement Run. For Estimate Daily Run this will be 0 | - | ✓ | - |
METER_RUNTYPE |
LowCardinality(String) |
The Type of Settlement Run(ESTIMATE/PRELIM/FINAL/REVISE) | - | ✓ | - |
REGIONID |
LowCardinality(String) |
Not Used | ✓ | ✓ | ✓ |
SETTLEMENTDATE |
Nullable(DateTime64(3)) |
Calendar Settlement Date | ✓ | ✓ | ✓ |
SETTLEMENTINTERVALLENGTH |
Nullable(Float64) |
Length of a settlement interval, in minutes (was 30 minutes, will be 5 minutes starting the commencement of 5MS rule change date). | ✓ | ✓ | - |
processed_at |
DateTime64(3) |
✓ | ✓ | ✓ | |
source_zip |
String |
✓ | ✓ | ✓ |
Schema Versions
| Version | Rows | Size |
|---|---|---|
62af4f37 |
7,629 | 180.13 KiB |
6ed37142 |
1,053 | 40.77 KiB |
7b400620 |
7,603 | 167.22 KiB |
Last updated: 2026-01-02 16:00:09