fpp
forecast_residual_dcf

fpp__forecast_residual_dcf

AEMO Description

This report delivers the forecast residual default contribut

Note that the provided table descriptions are truncated by AEMO.

Total Schema Versions 1
Combined Rows 1,887
Combined Size 42.96 KiB
MMS Table fpp_forecast_residual_dcf
Unified View nemwebviews.fpp__forecast_residual_dcf

Schema Evolution

Column Type Description 35d4a8a4
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)
DCF_ABS_NEGATIVE_PERF_TOTAL Nullable(Float64) The sum of absolute negative performance in MWHz for the combination of constraint (raise or lower). This is used as the denominator in normalising default contribution factors (DCF). For further details please see the FPP procedure document. >0 = Performance was calculated for the units NULL = Performance for the units was unavailable
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 residual default contribution factor related to the constraint. This is the billing period over which these default contribution factors will be effective / applied. Effective end date will align with the end of a 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 residual default contribution factor related to the constraint. This is the billing period over which these default contribution factors will be effective / applied. In most cases this will align to the settlement week, however there are some cases (like a new constraint) where the effective start date will be prorated to align with the change.
RESIDUAL_DCF Nullable(Float64) Calculated residual default contribution factor from the historical performance period. For further details please see the FPP procedure document.
RESIDUAL_DCF_REASON_FLAG Nullable(Float64) The reason flag showing the decision matrix for the residual default contribution factor (DCF)
VERSIONNO Nullable(Float64) The version number. In most cases this version will be the historical performance calculation run number from the FPP database (which is different from the FPP run number), however there are some cases (like a new constraint) where the version number listed here will be the FPP run number from the FPP database (this will be where the effective start date time will be prorated to align with the detection of this change).
processed_at DateTime64(3)
source_zip String

Schema Versions

Version Rows Size
35d4a8a4 1,887 42.96 KiB

Last updated: 2026-01-02 16:00:06