FPP_RCR
This report delivers the calculated RCR 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) |
| RCR |
numeric(18, 5) |
numeric(18, 5) |
RCR (the calculated requirement for corrective response from FPP database) |
| RCR_REASON_FLAG |
numeric(5, 0) |
tinyint |
The reason flag showing the decision matrix for the requirement for corrective response (RCR) calculation Supported values are: 0 = RCR is calculated based on good input data 1 = RCR is 0 as FM is unreliable 2 = RCR 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_RCR_PK |
clustered, unique, primary key |
INTERVAL_DATETIME, CONSTRAINTID, VERSIONNO |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_FPP_RCR |
clustered, unique, primary key |
INTERVAL_DATETIME, CONSTRAINTID, VERSIONNO |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_FPP_RCR |
clustered, unique, primary key |
INTERVAL_DATETIME, CONSTRAINTID, VERSIONNO |