FPP_P5_FWD_EST_RESIDUALRATE
This report delivers the forward estimated residual cost rate based on P5min runs. These high-level estimates (i. e. assuming that all is unused FCAS) will be provided for each constraint for each 5 minute pre-dispatch interval.
Package
FPP
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| RUN_DATETIME |
datetime(3)  |
datetime2(0) |
The run date and time of the 5 minute predispatch case that was the trigger for the constraint FCAS processor execution (as the FCAS requirement data is the basis of these forward estimates) |
| RUNNO |
numeric(5, 0) |
smallint |
The 5 minute predispatch case run number that was the trigger for the constraint FCAS processor execution (as the FCAS requirement data is the basis for these forward estimates) |
| 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 |
The version number of the effective default contribution factor for the unit / constraint combination taken from the FPP_FORECAST_DEFAULT_CF table |
| BIDTYPE |
varchar(10) |
varchar(10) |
Bid type (the bid type saved in relation to constraint ID from FCAS data used in FPP calculations) |
| RELEVANT_REGIONS |
varchar(200) |
varchar(50) |
Relevant regions (a comma separated list of the relevant regions for the constraint from FCAS data) |
| EST_UNUSED_FCAS |
numeric(18, 8) |
numeric(18, 8) |
Estimated unused recovery FCAS in AUD/MWh (the forward financial estimate of the recovery of unused FCAS, assuming that all is unused FCAS). This value will be either 0 (nil), or a negative value (debit) only. For details on the calculation, please see FPP procedure and supporting documentation. Please note that there may be cases where there is not yet a residual default contribution factor for the constraint (for example if there is a new constraint binding in p5min that has not yet bound in dispatch). In these scenarios there will be no EST_UNUSED_FCAS row sent for the constraint, as this is currently incalculable until a corresponding residual default contribution factor is calculated from a dispatch run with this constraint binding. |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| FPP_P5_FWD_EST_RESIDUALRATE_PK |
clustered, unique, primary key |
RUN_DATETIME, RUNNO, INTERVAL_DATETIME, CONSTRAINTID, VERSIONNO |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_FPP_P5_FWD_EST_RESIDUALRATE |
clustered, unique, primary key |
RUN_DATETIME, RUNNO, INTERVAL_DATETIME, CONSTRAINTID, VERSIONNO |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_FPP_P5_FWD_EST_RESIDUALRATE |
clustered, unique, primary key |
RUN_DATETIME, RUNNO, INTERVAL_DATETIME, CONSTRAINTID, VERSIONNO |