PD_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
PRE_DISPATCH
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| PREDISPATCHSEQNO |
varchar(20)  |
int |
Predispatch sequence number for the 30 minute predispatch case that triggers the constraint FCAS processor run |
| RUN_DATETIME |
datetime(3) |
datetime2(0) |
The run date and time of the 30 minute predispatch case that triggers the constraint FCAS processor run |
| RUNNO |
numeric(5, 0) |
tinyint |
The 30 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) |
| PD_FCAS_REQ_RUN_PK |
clustered, unique, primary key |
PREDISPATCHSEQNO, RUN_DATETIME, RUNNO |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_PD_FCAS_REQ_RUN |
clustered, unique, primary key |
PREDISPATCHSEQNO, RUN_DATETIME, RUNNO |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_PD_FCAS_REQ_RUN |
clustered, unique, primary key |
PREDISPATCHSEQNO, RUN_DATETIME, RUNNO |