PD_FCAS_REQ_CONSTRAINT
The constraint level FCAS cost / price details for constraint FCAS processor runs. 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 |
| INTERVAL_DATETIME |
datetime(3) |
datetime2(0) |
The 30 minute interval date and time of the 30 minute predispatch interval that was processed by the constraint FCAS processor |
| CONSTRAINTID |
varchar(20) |
varchar(20) |
ConstraintID join to table GenConData |
| REGIONID |
varchar(20) |
varchar(10) |
Region identifier |
| BIDTYPE |
varchar(10) |
varchar(10) |
DUID offered type |
| LHS |
numeric(15, 5) |
numeric(15, 5) |
Constraints summed LHS - aggregate LHS Solution values from the physical run from the PREDISPATCHCONSTRAINT table |
| RHS |
numeric(15, 5) |
numeric(15, 5) |
Constraints RHS value used in the solution - may be either dynamic (calculated) or static from the physical run from the PREDISPATCHCONSTRAINT table |
| MARGINALVALUE |
numeric(15, 5) |
numeric(15, 5) |
Shadow price of constraint from the PREDISPATCHCONSTRAINT table from the physical run. |
| RRP |
numeric(15, 5) |
numeric(15, 5) |
Bid type prices for the region coming from the pricing run of the PREDISPATCHREGIONSUM table |
| REGIONAL_ENABLEMENT |
numeric(15, 5) |
numeric(15, 5) |
The dispatched MW for the bid type inside the region from the physical run of the PREDISPATCHREGIONSUM table |
| CONSTRAINT_ENABLEMENT |
numeric(15, 5) |
numeric(15, 5) |
MW enabled for this bid type within the constraint |
| REGION_BASE_COST |
numeric(18, 8) |
numeric(18, 8) |
The regional payment allocated to the constraint for the interval pro-rated based on marginal value ratios over the binding constraints for that service in that region (this is an intermediate calculation to get to the base cost) |
| BASE_COST |
numeric(18, 8) |
numeric(18, 8) |
The base cost of the constraint, before the regulation/contingency split |
| ADJUSTED_COST |
numeric(18, 8) |
numeric(18, 8) |
The adjusted cost of the constraint for this service, after the regulation/contingency split |
| P_REGULATION |
numeric(18, 8) |
numeric(18, 8) |
The adjusted marginal value of the constraint for FPP recovery (blank for constraints without REG terms) |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PD_FCAS_REQ_CONSTRAINT_PK |
clustered, unique, primary key |
PREDISPATCHSEQNO, RUN_DATETIME, RUNNO, INTERVAL_DATETIME, CONSTRAINTID, REGIONID, BIDTYPE |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_PD_FCAS_REQ_CONSTRAINT |
clustered, unique, primary key |
PREDISPATCHSEQNO, RUN_DATETIME, RUNNO, INTERVAL_DATETIME, CONSTRAINTID, REGIONID, BIDTYPE |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PD_FCAS_REQ_CONSTRAINT_CCI |
clustered, columnstore |
n/a |
| PK_PD_FCAS_REQ_CONSTRAINT |
nonclustered, unique, primary key |
PREDISPATCHSEQNO, RUN_DATETIME, RUNNO, INTERVAL_DATETIME, CONSTRAINTID, REGIONID, BIDTYPE |