fpp__forecast_residual_dcf__1
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,707 |
| Combined Size | 40.36 KiB |
| MMS Table | fpp_forecast_residual_dcf |
| Unified View | nemwebviews.fpp__forecast_residual_dcf__1 |
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,707 | 40.36 KiB |
Last updated: 2025-12-10 08:00:05