FPP_USAGE
This report delivers the calculated usage for each constraint for each 5 minute trading interval.
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) |
| REGULATION_MW |
numeric(18, 8) |
numeric(18, 8) |
Enabled regulation MW used in the FPP calculation (from FPP database) |
| USED_MW |
numeric(18, 8) |
numeric(18, 8) |
Maximum used regulation MW value (quantity of regulation FCAS that was calculated to be used in MW) |
| USAGE_VALUE |
numeric(18, 8) |
numeric(18, 8) |
Usage (calculation of the proportion of regulation FCAS that was calculated to be used) |
| USAGE_REASON_FLAG |
numeric(5, 0) |
tinyint |
The reason flag showing the decision matrix for the usage calculation Supported values are: 0 = Usage is calculated based on good input data 1 = Usage is 0 as FM is unreliable 2 = Usage is 0 as the percentage of units with unavailable input or bad data is greater than the threshold percentage |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| FPP_USAGE_PK |
clustered, unique, primary key |
INTERVAL_DATETIME, CONSTRAINTID, VERSIONNO |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_FPP_USAGE |
clustered, unique, primary key |
INTERVAL_DATETIME, CONSTRAINTID, VERSIONNO |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_FPP_USAGE |
clustered, unique, primary key |
INTERVAL_DATETIME, CONSTRAINTID, VERSIONNO |