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 | 2 |
| Combined Rows | 3,973,224,750 |
| Combined Size | 21.45 GiB |
| MMS Table | fpp_unit_mw |
| Unified View | nemwebviews.fpp__unit_mw |
Schema Evolution
| Column | Type | Description | 0efd4a4c | 6d7454df |
|---|---|---|---|---|
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) | ✓ | ✓ |
LASTCHANGED |
Nullable(DateTime64(3)) |
- | ✓ | |
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 |
2,253,917,625 | 12.13 GiB |
6d7454df |
1,719,307,125 | 9.32 GiB |
Last updated: 2026-10-28 14:00:05