fpp__forecast_default_cf__1
AEMO Description
This report delivers the forecast default contribution facto
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 1 |
| Combined Rows | 648,356 |
| Combined Size | 1.71 MiB |
| MMS Table | fpp_forecast_default_cf |
| Unified View | nemwebviews.fpp__forecast_default_cf__1 |
Schema Evolution
| Column | Type | Description | db342f14 |
|---|---|---|---|
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) as the historical performance is always negative for DCF. For further details please see the FPP procedure document. >0 = Performance was calculated for the units NULL = Performance for the units was unavailable | ✓ |
DCF_REASON_FLAG |
Nullable(Float64) |
The reason flag showing the decision matrix for the default contribution factor (DCF) | ✓ |
DEFAULT_CONTRIBUTION_FACTOR |
Nullable(Float64) |
Calculated default contribution factor from the historical performance period. For further details please see the FPP procedure document. | ✓ |
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 default contribution factor related to the combination of FPP unit ID / 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 default contribution factor related to the combination of FPP unit ID / 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. | ✓ |
FPP_UNITID |
LowCardinality(String) |
FPP Unit ID (registered DUID/ TNI) | ✓ |
REGIONID |
LowCardinality(String) |
Region ID of the frequency deviation / frequency measure | ✓ |
SETTLEMENTS_UNITID |
LowCardinality(String) |
The Settlements Unit ID (registered DUID / TNI) Note that this SETTLEMENTS_UNITID is what is sent and used by the Settlements system, and may be different from the FPP_UNITID for non-scheduled loads where the FPP_UNITID may be a descriptive key, whereas what will be sent to Settlements as the SETTLEMENTS_UNITID will be the TNI code. | ✓ |
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 |
|---|---|---|
db342f14 |
648,356 | 1.71 MiB |
Last updated: 2025-12-10 08:00:05