FPP_PD_FWD_EST_COST
This report delivers the forward estimated unit cost based on PREDISPATCH runs. These high-level estimates (i. e. assuming that all is unused FCAS) will be provided for each constraint for each 30 minute pre-dispatch interval.
Package
FPP
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| PREDISPATCHSEQNO |
varchar(20)  |
int |
Predispatch sequence number for the 30 minute predispatch case that triggers the constraint FCAS processor run |
| RUN_DATETIME |
datetime(3) |
datetime2(0) |
The run date and time of the 30 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 30 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 30 minute predispatch 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) |
| FPP_UNITID |
varchar(20) |
varchar(20) |
FPP Unit ID (registered DUID / TNI) |
| 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 (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 default contribution factor for the constraint (for example if there is a new constraint binding in predispatch that has not yet bound in dispatch). In these scenarios there will be no EST_UNUSED_FCAS row sent for the constraint, as it is currently incalculable until a corresponding default contribution factor is calculated from a dispatch run with this constraint binding. |
| PARTICIPANTID |
varchar(20) |
varchar(10) |
Participant ID |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| FPP_PD_FWD_EST_COST_PK |
clustered, unique, primary key |
PREDISPATCHSEQNO, RUN_DATETIME, RUNNO, INTERVAL_DATETIME, CONSTRAINTID, FPP_UNITID, VERSIONNO |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_FPP_PD_FWD_EST_COST |
clustered, unique, primary key |
PREDISPATCHSEQNO, RUN_DATETIME, RUNNO, INTERVAL_DATETIME, CONSTRAINTID, FPP_UNITID, VERSIONNO |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_FPP_PD_FWD_EST_COST |
clustered, unique, primary key |
PREDISPATCHSEQNO, RUN_DATETIME, RUNNO, INTERVAL_DATETIME, CONSTRAINTID, FPP_UNITID, VERSIONNO |