fpp
est_perf_cost_rate v1

fpp__est_perf_cost_rate__1

AEMO Description

This report delivers the estimated performance cost rate for

Note that the provided table descriptions are truncated by AEMO.

Total Schema Versions 1
Combined Rows 417,035
Combined Size 11.30 MiB
MMS Table fpp_est_perf_cost_rate
Unified View nemwebviews.fpp__est_perf_cost_rate__1

Schema Evolution

Column Type Description 44fdaaaf
BIDTYPE LowCardinality(String) Bid type (the bid type saved in relation to constraint ID from FCAS data used in FPP calculations)
CONSTRAINTID LowCardinality(String) Constraint ID (binding constraint ID from FCAS data used in FPP calculations)
FPP_PAYMENT_RATE Nullable(Float64) The payment rate for FPP in AUD / MWHz (the denominator used is the sum of positive performance for the constraint calculated by contribution factor calculation). This value will be either 0 (nil), or a positive value (credit) only. For details on the calculation, please see FPP procedure and supporting documentation.
FPP_RECOVERY_RATE Nullable(Float64) The recovery rate for FPP in AUD / MWHz (the denominator used is the absolute sum of negative performance for the constraint calculated by the contribution factor calculation). This value will be either 0 (nil), or a negative value (debit) only. For details on the calculation, please see FPP procedure and supporting documentation.
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)
RELEVANT_REGIONS LowCardinality(String) Relevant regions (a comma separated list of the relevant regions for the constraint from FCAS data)
UNUSED_FCAS_RATE Nullable(Float64) The rate for unused FCAS in AUD / MWHz (the denominator used is the absolute sum of negative performance for the constraint calculated by the default contribution factor calculation). This value will be either 0 (nil), or a negative value (debit) only. For details on the calculation, please see FPP procedure and supporting documentation.
USED_FCAS_RATE Nullable(Float64) The rate for used FCAS in AUD / MWHz (the denominator used is the absolute sum of negative performance for the constraint calculated by the negative contribution factor calculation). This value will be either 0 (nil), or a negative value (debit) only. For details on the calculation, please see FPP procedure and supporting documentation.
VERSIONNO Nullable(Float64) The version number. In most cases this version will be the FPP run number from the FPP database, however there are some cases (like a new pricing run of the constraint FCAS processor received by the FPP system) where the version number listed here will be the financial estimate run number from the FPP database (this number is a different sequence from the FPP run number because there is no recalculation of performance or contribution, just changes to pricing / p regulation hence only the financial estimation is performed).
processed_at DateTime64(3)
source_zip String

Schema Versions

Version Rows Size
44fdaaaf 417,035 11.30 MiB

Last updated: 2025-12-10 08:00:05