fpp__hist_performance__1
AEMO Description
This report delivers the historical performance calculated b
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 1 |
| Combined Rows | 22,779 |
| Combined Size | 466.34 KiB |
| MMS Table | fpp_hist_performance |
| Unified View | nemwebviews.fpp__hist_performance__1 |
Schema Evolution
| Column | Type | Description | 1986d6b5 |
|---|---|---|---|
EFFECTIVE_END_DATETIME |
Nullable(DateTime64(3)) |
Effective period end date and time (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time) of the effective period for this historical performance values related to the FPP unit ID. This is the billing period over which these historical performance values will be effective / applied over. This will align to the settlement week. | ✓ |
EFFECTIVE_START_DATETIME |
Nullable(DateTime64(3)) |
Effective period start date and time (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time) of the effective period for this historical performance values related to the FPP unit ID. This is the billing period over which these historical performance values will be effective / applied over. This will align to the settlement week. | ✓ |
FPP_HIST_LOWER_PERFORMANCE |
Nullable(Float64) |
Calculated FPP historical lower performance from the historical performance period (substitute lower performance calculated used for negative contribution factor calculation when live performance is unavailable) - please see the NER and FPP procedure documents for further information | ✓ |
FPP_HIST_RAISE_PERFORMANCE |
Nullable(Float64) |
Calculated FPP historical raise performance from the historical performance period (substitute raise performance calculated used for negative contribution factor calculation when live performance is unavailable) - please see the NER and FPP procedure documents for further information | ✓ |
FPP_UNITID |
LowCardinality(String) |
FPP Unit ID (registered DUID/ TNI) | ✓ |
HIST_PERIOD_END_DATETIME |
Nullable(DateTime64(3)) |
Historical period end date and time (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time) of the historical period for this historical performance calculation related to the FPP unit ID. This is the historical period of trading intervals that feed into the historical performance calculation. This will align to the settlement week. | ✓ |
HIST_PERIOD_START_DATETIME |
Nullable(DateTime64(3)) |
Historical period start date and time (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time) of the historical period for this historical performance calculation related to the FPP unit ID. This is the historical period of trading intervals that feed into the historical performance calculation. This will align to the settlement week. | ✓ |
REG_HIST_LOWER_PERFORMANCE |
Nullable(Float64) |
Calculated regulation historical lower performance from the historical performance period (substitute lower performance when live performance is unavailable and default lower performance used for default contribution factor calculation) - please see the NER and FPP procedure documents for further information | ✓ |
REG_HIST_RAISE_PERFORMANCE |
Nullable(Float64) |
Calculated regulation historical raise performance from the historical performance period (substitute raise performance when live performance is unavailable and default raise performance used for default contribution factor calculation) - please see the NER and FPP procedure documents for further information | ✓ |
VERSIONNO |
Nullable(Float64) |
Version (FPP historical performance calculation run number from the FPP database) Note that due to the these historical calculations, the version numbers listed here are different to the normal FPP run number version for trading interval calculations. | ✓ |
processed_at |
DateTime64(3) |
✓ | |
source_zip |
String |
✓ |
Schema Versions
| Version | Rows | Size |
|---|---|---|
1986d6b5 |
22,779 | 466.34 KiB |
Last updated: 2025-12-10 08:00:06