This report delivers the historical performance calculated based on a historical period and effective for a billing period (aligned to the settlement week).
Package
FPP
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| FPP_UNITID |
varchar(20)  |
varchar(20) |
FPP Unit ID (registered DUID/ TNI) |
| EFFECTIVE_START_DATETIME |
datetime(3) |
datetime2(0) |
Effective period start date and time (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time) of the effective period for this historical performance values related to the FPP unit ID. This is the billing period over which these historical performance values will be effective / applied over. This will align to the settlement week. |
| EFFECTIVE_END_DATETIME |
datetime(3) |
datetime2(0) |
Effective period end date and time (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time) of the effective period for this historical performance values related to the FPP unit ID. This is the billing period over which these historical performance values will be effective / applied over. This will align to the settlement week. |
| VERSIONNO |
numeric(10, 0) |
smallint |
Version (FPP historical performance calculation run number from the FPP database) Note that due to the these historical calculations, the version numbers listed here are different to the normal FPP run number version for trading interval calculations. |
| HIST_PERIOD_START_DATETIME |
datetime(3) |
datetime2(0) |
Historical period start date and time (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time) of the historical period for this historical performance calculation related to the FPP unit ID. This is the historical period of trading intervals that feed into the historical performance calculation. This will align to the settlement week. |
| HIST_PERIOD_END_DATETIME |
datetime(3) |
datetime2(0) |
Historical period end date and time (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time) of the historical period for this historical performance calculation related to the FPP unit ID. This is the historical period of trading intervals that feed into the historical performance calculation. This will align to the settlement week. |
| REG_HIST_RAISE_PERFORMANCE |
numeric(18, 5) |
numeric(18, 5) |
Calculated regulation historical raise performance from the historical performance period (substitute raise performance when live performance is unavailable and default raise performance used for default contribution factor calculation) - please see the NER and FPP procedure documents for further information |
| REG_HIST_LOWER_PERFORMANCE |
numeric(18, 5) |
numeric(18, 5) |
Calculated regulation historical lower performance from the historical performance period (substitute lower performance when live performance is unavailable and default lower performance used for default contribution factor calculation) - please see the NER and FPP procedure documents for further information |
| FPP_HIST_RAISE_PERFORMANCE |
numeric(18, 5) |
numeric(18, 5) |
Calculated FPP historical raise performance from the historical performance period (substitute raise performance calculated used for negative contribution factor calculation when live performance is unavailable) - please see the NER and FPP procedure documents for further information |
| FPP_HIST_LOWER_PERFORMANCE |
numeric(18, 5) |
numeric(18, 5) |
Calculated FPP historical lower performance from the historical performance period (substitute lower performance calculated used for negative contribution factor calculation when live performance is unavailable) - please see the NER and FPP procedure documents for further information |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| FPP_HIST_PERFORMANCE_PK |
clustered, unique, primary key |
FPP_UNITID, EFFECTIVE_START_DATETIME, EFFECTIVE_END_DATETIME, VERSIONNO |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_FPP_HIST_PERFORMANCE |
clustered, unique, primary key |
FPP_UNITID, EFFECTIVE_START_DATETIME, EFFECTIVE_END_DATETIME, VERSIONNO |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_FPP_HIST_PERFORMANCE |
clustered, unique, primary key |
FPP_UNITID, EFFECTIVE_START_DATETIME, EFFECTIVE_END_DATETIME, VERSIONNO |