fpp__fpp_performance
AEMO Description
This report delivers the calculated performance value for ea
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 2 |
| Combined Rows | 73,688,472 |
| Combined Size | 389.25 MiB |
| MMS Table | fpp_performance |
| Unified View | nemwebviews.fpp__fpp_performance |
Schema Evolution
| Column | Type | Description | 178046a9 | d92c57bc |
|---|---|---|---|---|
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)) |
- | ✓ | |
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 1 = Performance is Null as unit is a Non Primary DUID in the group 2 = Performance against the Primary DUID representing the group 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 6 = Performance against the Primary DUID representing the group is Null as Input data is bad or unavailable 10 = Performance against the Primary DUID representing the group is Null as FM is unreliable 14 = Performance against the Primary DUID representing the group is Null as Input data is bad or unavailable and FM is unreliable | ✓ | ✓ |
PARTICIPANTID |
LowCardinality(String) |
Participant ID | ✓ | ✓ |
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 1 = Performance is Null as unit is a Non Primary DUID in the group 2 = Performance against the Primary DUID representing the group 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 6 = Performance against the Primary DUID representing the group is Null as Input data is bad or unavailable 10 = Performance against the Primary DUID representing the group is Null as FM is unreliable 14 = Performance against the Primary DUID representing the group is Null as Input data is bad or unavailable and FM is unreliable | ✓ | ✓ |
VERSIONNO |
Nullable(Float64) |
Version (FPP run number from the FPP database) | ✓ | ✓ |
processed_at |
DateTime64(3) |
✓ | ✓ | |
source_zip |
String |
✓ | ✓ |
Schema Versions
| Version | Rows | Size |
|---|---|---|
178046a9 |
67,198,867 | 354.43 MiB |
d92c57bc |
6,489,605 | 34.82 MiB |
Last updated: 2026-06-30 17:00:11