settlements__daytrack__7

AEMO Description

DAYTRACK identifies the actual settlement run processed for

Note that the provided table descriptions are truncated by AEMO.

Total Schema Versions 1
Combined Rows 945
Combined Size 38.09 KiB
MMS Table daytrack
Unified View nemwebviews.settlements__daytrack__7

Schema Evolution

Column Type Description 6ed37142
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
6ed37142 945 38.09 KiB

Last updated: 2025-12-10 08:00:08