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