This report delivers the calculated performance value for each 5 minute trading interval for each FPP unit.
Package
FPP
Visibility
Private, Public Next-Day
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) |
| FPP_UNITID |
varchar(20) |
varchar(20) |
FPP Unit ID (registered DUID/ TNI) |
| 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 1 = Performance is Null as unit is a Non Primary DUID in the group 2 = Performance against the Primary DUID representing the group 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 6 = Performance against the Primary DUID representing the group is Null as Input data is bad or unavailable 10 = Performance against the Primary DUID representing the group is Null as FM is unreliable 14 = Performance against the Primary DUID representing the group 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 1 = Performance is Null as unit is a Non Primary DUID in the group 2 = Performance against the Primary DUID representing the group 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 6 = Performance against the Primary DUID representing the group is Null as Input data is bad or unavailable 10 = Performance against the Primary DUID representing the group is Null as FM is unreliable 14 = Performance against the Primary DUID representing the group is Null as Input data is bad or unavailable and FM is unreliable |
| PARTICIPANTID |
varchar(20) |
varchar(10) |
Participant ID |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| FPP_PERFORMANCE_PK |
clustered, unique, primary key |
INTERVAL_DATETIME, FPP_UNITID, VERSIONNO |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_FPP_PERFORMANCE |
clustered, unique, primary key |
INTERVAL_DATETIME, FPP_UNITID, VERSIONNO |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_FPP_PERFORMANCE |
clustered, unique, primary key |
INTERVAL_DATETIME, FPP_UNITID, VERSIONNO |