FPP_RESIDUAL_CF
This report delivers the calculated residual contribution factor value for each 5 minute trading interval for each constraint.
Package
FPP
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| INTERVAL_DATETIME |
datetime(3)  |
datetime2(0) |
Date and time of the trading interval (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time) |
| CONSTRAINTID |
varchar(20) |
varchar(20) |
Constraint ID (binding constraint ID from FCAS data used in FPP calculations) |
| VERSIONNO |
numeric(5, 0) |
smallint |
Version (FPP run number from the FPP database) |
| BIDTYPE |
varchar(10) |
varchar(10) |
Bid type (the bid type saved in relation to constraint ID from FCAS data used in FPP calculations) |
| RESIDUAL_CF |
numeric(18, 8) |
numeric(18, 8) |
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 |
| NEGATIVE_RESIDUAL_CF |
numeric(18, 8) |
numeric(18, 8) |
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_DCF |
numeric(18, 8) |
numeric(18, 8) |
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 |
| RESIDUAL_CF_REASON_FLAG |
numeric(5, 0) |
tinyint |
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. |
| CF_ABS_POSITIVE_PERF_TOTAL |
numeric(18, 8) |
numeric(18, 8) |
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 |
| CF_ABS_NEGATIVE_PERF_TOTAL |
numeric(18, 8) |
numeric(18, 8) |
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 |
| NCF_ABS_NEGATIVE_PERF_TOTAL |
numeric(18, 8) |
numeric(18, 8) |
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 |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| FPP_RESIDUAL_CF_PK |
clustered, unique, primary key |
INTERVAL_DATETIME, CONSTRAINTID, VERSIONNO |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_FPP_RESIDUAL_CF |
clustered, unique, primary key |
INTERVAL_DATETIME, CONSTRAINTID, VERSIONNO |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_FPP_RESIDUAL_CF |
clustered, unique, primary key |
INTERVAL_DATETIME, CONSTRAINTID, VERSIONNO |