fpp__residual_cf__1
AEMO Description
This report delivers the calculated residual contribution fa
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 1 |
| Combined Rows | 417,043 |
| Combined Size | 11.41 MiB |
| MMS Table | fpp_residual_cf |
| Unified View | nemwebviews.fpp__residual_cf__1 |
Schema Evolution
| Column | Type | Description | 5f0c3f01 |
|---|---|---|---|
BIDTYPE |
LowCardinality(String) |
Bid type (the bid type saved in relation to constraint ID from FCAS data used in FPP calculations) | ✓ |
CF_ABS_NEGATIVE_PERF_TOTAL |
Nullable(Float64) |
The sum of absolute negative performance in MWHz for the combination of constraint / bid type (raise or lower). This is used as the denominator in normalising contribution factors (CF) where a units performance is negative. For further details please see the FPP procedure document. >0 = Performance was calculated for the units NULL = Performance for the units was unavailable | ✓ |
CF_ABS_POSITIVE_PERF_TOTAL |
Nullable(Float64) |
The sum of absolute positive performance in MWHz for the combination of constraint / bid type (raise or lower). This is used as the denominator in normalising contribution factors (CF) where a units performance is positive. For further details please see the FPP procedure document. >0 = Performance was calculated for the units NULL = Performance for the units was unavailable | ✓ |
CONSTRAINTID |
LowCardinality(String) |
Constraint ID (binding constraint ID from FCAS data used in FPP calculations) | ✓ |
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) | ✓ |
NCF_ABS_NEGATIVE_PERF_TOTAL |
Nullable(Float64) |
The sum of absolute negative performance in MWHz for the combination of constraint / bid type (raise or lower). This is used as the denominator in normalising negative contribution factors (NCF). For further details please see the FPP procedure document. >0 = Performance was calculated for the units NULL = Performance for the units was unavailable 0 = When NCF is zero (i.e. CF is positive), then this total will be represented as zero | ✓ |
NEGATIVE_RESIDUAL_CF |
Nullable(Float64) |
Negative Residual Contribution Factor (the calculated negative residual contribution factor for the constraint ID for that trading interval) - for further details please see the FPP procedure document | ✓ |
RESIDUAL_CF |
Nullable(Float64) |
Residual Contribution Factor (the calculated residual contribution factor for the constraint ID for that trading interval) - for further details please see the FPP procedure document | ✓ |
RESIDUAL_CF_REASON_FLAG |
Nullable(Float64) |
The reason flag showing the decision matrix for the residual contribution factor (CF) Supported values are: 0 = CF is calculated based on good input data 8 = CF is 0 because FM is unreliable. 16 = CF is 0 because more than 50 percent input is bad or not available. | ✓ |
RESIDUAL_DCF |
Nullable(Float64) |
The Residual Default Contribution Factor (the calculated residual default contribution factor based on historical performance for the constraint ID for that trading interval) that is effective for this trading interval, which joins back to FPP_FORECAST_RESIDUAL_DCF - for further details please see the FPP procedure document | ✓ |
VERSIONNO |
Nullable(Float64) |
Version (FPP run number from the FPP database) | ✓ |
processed_at |
DateTime64(3) |
✓ | |
source_zip |
String |
✓ |
Schema Versions
| Version | Rows | Size |
|---|---|---|
5f0c3f01 |
417,043 | 11.41 MiB |
Last updated: 2025-12-10 08:00:06