FPP_EST_COST
This report delivers the estimated cost for each FPP unit for each constraint for each 5 minute trading interval.
Package
FPP
Visibility
Private
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) |
| FPP_UNITID |
varchar(20) |
varchar(20) |
FPP Unit ID (registered DUID / TNI) |
| VERSIONNO |
numeric(10, 0) |
smallint |
The version number. In most cases this version will be the FPP run number from the FPP database, however there are some cases (like a new pricing run of the constraint FCAS processor received by the FPP system) where the version number listed here will be the financial estimate run number from the FPP database (this number is a different sequence from the FPP run number because there is no recalculation of performance or contribution, just changes to pricing / p regulation hence only the financial estimation is performed). |
| 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) |
| FPP |
numeric(18, 8) |
numeric(18, 8) |
FPP in AUD (the financial estimate of frequency performance payment calculated for the constraint / bid type / unit). This value can be either positive (credit) or negative (debit). For details on the calculation, please see FPP procedure and supporting documentation. |
| USED_FCAS |
numeric(18, 8) |
numeric(18, 8) |
Used recovery FCAS in AUD (the financial estimate of the recovery of used FCAS calculated for the constraint / bid type / unit). 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. |
| UNUSED_FCAS |
numeric(18, 8) |
numeric(18, 8) |
Unused recovery FCAS in AUD (the financial estimate of the recovery of unused FCAS calculated for the constraint / bid type / unit). 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. |
| PARTICIPANTID |
varchar(20) |
varchar(10) |
Participant ID |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| FPP_EST_COST_PK |
clustered, unique, primary key |
INTERVAL_DATETIME, CONSTRAINTID, FPP_UNITID, VERSIONNO |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_FPP_EST_COST |
clustered, unique, primary key |
INTERVAL_DATETIME, CONSTRAINTID, FPP_UNITID, VERSIONNO |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_FPP_EST_COST |
clustered, unique, primary key |
INTERVAL_DATETIME, CONSTRAINTID, FPP_UNITID, VERSIONNO |