This report delivers the calculated residual performance value 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) |
| REGIONID |
varchar(20) |
varchar(10) |
Region ID of the residual performance |
| VERSIONNO |
numeric(5, 0) |
smallint |
Version (FPP run number from the FPP database) |
| RAISE_PERFORMANCE |
numeric(18, 5) |
numeric(18, 5) |
Raise performance value in MWHz units (calculated by FPP for that trading interval taken from FPP database) |
| RAISE_REASON_FLAG |
numeric(5, 0) |
tinyint |
The reason flag showing the decision matrix for the raise performance value Supported values are: 0 = Performance is calculated based on good input data 4 = Performance is Null as Input data is bad or unavailable 8 = Performance is Null as FM is unreliable 12 = Performance is Null as Input data is bad or unavailable and FM is unreliable |
| LOWER_PERFORMANCE |
numeric(18, 5) |
numeric(18, 5) |
Lower performance value in MWHz units (calculated by FPP for that trading interval taken from FPP database) |
| LOWER_REASON_FLAG |
numeric(5, 0) |
tinyint |
The reason flag showing the decision matrix for the lower performance value Supported values are: 0 = Performance is calculated based on good input data 4 = Performance is Null as Input data is bad or unavailable 8 = Performance is Null as FM is unreliable 12 = Performance is Null as Input data is bad or unavailable and FM is unreliable |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| FPP_RESIDUAL_PERFORMANCE_PK |
clustered, unique, primary key |
INTERVAL_DATETIME, REGIONID, VERSIONNO |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_FPP_RESIDUAL_PERFORMANCE |
clustered, unique, primary key |
INTERVAL_DATETIME, REGIONID, VERSIONNO |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_FPP_RESIDUAL_PERFORMANCE |
clustered, unique, primary key |
INTERVAL_DATETIME, REGIONID, VERSIONNO |