fpp
residual_performance

fpp__residual_performance

AEMO Description

This report delivers the calculated residual performance val

Note that the provided table descriptions are truncated by AEMO.

Total Schema Versions 2
Combined Rows 565,705
Combined Size 6.71 MiB
MMS Table fpp_residual_performance
Unified View nemwebviews.fpp__residual_performance

Schema Evolution

Column Type Description 28e3e17e bbd33f0e
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)) ✓ -
LOWER_PERFORMANCE Nullable(Float64) Lower performance value in MWHz units (calculated by FPP for that trading interval taken from FPP database) ✓ ✓
LOWER_REASON_FLAG Nullable(Float64) The reason flag showing the decision matrix for the lower performance value Supported values are: 0 = Performance is calculated based on good input data 4 = Performance is Null as Input data is bad or unavailable 8 = Performance is Null as FM is unreliable 12 = Performance is Null as Input data is bad or unavailable and FM is unreliable ✓ ✓
RAISE_PERFORMANCE Nullable(Float64) Raise performance value in MWHz units (calculated by FPP for that trading interval taken from FPP database) ✓ ✓
RAISE_REASON_FLAG Nullable(Float64) The reason flag showing the decision matrix for the raise performance value Supported values are: 0 = Performance is calculated based on good input data 4 = Performance is Null as Input data is bad or unavailable 8 = Performance is Null as FM is unreliable 12 = Performance is Null as Input data is bad or unavailable and FM is unreliable ✓ ✓
REGIONID LowCardinality(String) Region ID of the residual performance ✓ ✓
VERSIONNO Nullable(Float64) Version (FPP run number from the FPP database) ✓ ✓
processed_at DateTime64(3) ✓ ✓
source_zip String ✓ ✓

Schema Versions

Version Rows Size
28e3e17e 241,285 2.94 MiB
bbd33f0e 324,420 3.76 MiB

Last updated: 2026-10-28 14:00:05