P5MIN_FCAS_REQ_RUN
The constraint FCAS processor run details. This enhanced output table format is established for the constraint FCAS processor release required for the Frequency Performance Payments (FPP) release. This enhanced output is hierarchical in nature, with the parent *_FCAS_REQ_RUN table holding the details about the triggering case run and time, and the child *_FCAS_REQ_CONSTRAINT table holding the constraint level details of FCAS costs / prices.
Package
P5MIN
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| RUN_DATETIME |
datetime(3)  |
datetime2(0) |
The run date and time of the 5 minute predispatch case that triggers the constraint FCAS processor run |
| RUNNO |
numeric(5, 0) |
tinyint |
The 5 minute predispatch case run number that has triggers the constraint FCAS processor run |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
The last time the constraint FCAS processor was executed for this case run time. |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| P5MIN_FCAS_REQ_RUN_PK |
clustered, unique, primary key |
RUN_DATETIME, RUNNO |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_P5MIN_FCAS_REQ_RUN |
clustered, unique, primary key |
RUN_DATETIME, RUNNO |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_P5MIN_FCAS_REQ_RUN |
clustered, unique, primary key |
RUN_DATETIME, RUNNO |