FPP_FORECAST_RESIDUAL_DCF
This report delivers the forecast residual default contribution factors (DCF) effective for a billing period (aligned to the settlement week).
Package
FPP
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CONSTRAINTID |
varchar(20)  |
varchar(20) |
Constraint ID (binding constraint ID from FCAS data used in FPP calculations) |
| EFFECTIVE_START_DATETIME |
datetime(3) |
datetime2(0) |
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. |
| EFFECTIVE_END_DATETIME |
datetime(3) |
datetime2(0) |
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. |
| VERSIONNO |
numeric(10, 0) |
smallint |
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). |
| BIDTYPE |
varchar(10) |
varchar(10) |
Bid type (the bid type saved in relation to constraint ID from FCAS data used in FPP calculations) |
| RESIDUAL_DCF |
numeric(18, 8) |
numeric(18, 8) |
Calculated residual default contribution factor from the historical performance period. For further details please see the FPP procedure document. |
| RESIDUAL_DCF_REASON_FLAG |
numeric(5, 0) |
tinyint |
The reason flag showing the decision matrix for the residual default contribution factor (DCF) |
| DCF_ABS_NEGATIVE_PERF_TOTAL |
numeric(18, 8) |
numeric(18, 8) |
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 |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| FPP_FORECAST_RESIDUAL_DCF_PK |
clustered, unique, primary key |
CONSTRAINTID, EFFECTIVE_START_DATETIME, EFFECTIVE_END_DATETIME, VERSIONNO |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_FPP_FORECAST_RESIDUAL_DCF |
clustered, unique, primary key |
CONSTRAINTID, EFFECTIVE_START_DATETIME, EFFECTIVE_END_DATETIME, VERSIONNO |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_FPP_FORECAST_RESIDUAL_DCF |
clustered, unique, primary key |
CONSTRAINTID, EFFECTIVE_START_DATETIME, EFFECTIVE_END_DATETIME, VERSIONNO |