fpp__unit_mw

AEMO Description

This report delivers the curated 4 second measurement MW dat

Note that the provided table descriptions are truncated by AEMO.

Total Schema Versions 1
Combined Rows 3,038,553,300
Combined Size 16.71 GiB
MMS Table fpp_unit_mw
Unified View nemwebviews.fpp__unit_mw

Schema Evolution

Column Type Description 0efd4a4c
DEVIATION_MW Nullable(Float64) Unit Deviation (output of the FPP calculation process)
FPP_UNITID LowCardinality(String) FPP Unit ID (registered DUID/TNI)
INTERVAL_DATETIME Nullable(DateTime64(3)) Date and time of the trading interval (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time)
MEASURED_MW Nullable(Float64) Measured MW (4 second SCADA measurement in MW)
MEASUREMENT_DATETIME Nullable(DateTime64(3)) Date and time of the SCADA data (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time)
MW_QUALITY_FLAG Nullable(Float64) MW Quality (4 second SCADA measurement Quality) Supported values are: 0 = Bad Quality 1 = Good Quality 2 = Suspect Quality -1 = Value not used as input in the FPP calculation (generally used to indicate when SCADA data was late arriving after the FPP calculation commenced)
PARTICIPANTID LowCardinality(String) Participant ID
SCHEDULED_MW Nullable(Float64) Scheduled MW (reference trajectory value from FPP calculation process)
VERSIONNO Nullable(Float64) Version (FPP run number from the FPP database)
processed_at DateTime64(3)
source_zip String

Schema Versions

Version Rows Size
0efd4a4c 3,038,553,300 16.71 GiB

Last updated: 2026-01-02 16:00:07