DISPATCH_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
DISPATCH
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 dispatch case that triggers the constraint FCAS processor run |
| RUNNO |
numeric(5, 0) |
tinyint |
The dispatch case run number that has triggers the constraint FCAS processor run |
| INTERVAL_DATETIME |
datetime(3) |
datetime2(0) |
The trading interval date and time of the dispatch 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 DISPATCHCONSTRAINT 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 DISPATCHCONSTRAINT table |
| MARGINALVALUE |
numeric(15, 5) |
numeric(15, 5) |
Shadow price of constraint from the DISPATCHCONSTRAINT 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 DISPATCHREGIONSUM 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 DISPATCHREGIONSUM 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) |
| DISPATCH_FCASREQ_CONSTRAINT_PK |
clustered, unique, primary key |
RUN_DATETIME, RUNNO, INTERVAL_DATETIME, CONSTRAINTID, REGIONID, BIDTYPE |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_DISPATCH_FCAS_REQ_CONSTRAINT |
clustered, unique, primary key |
RUN_DATETIME, RUNNO, INTERVAL_DATETIME, CONSTRAINTID, REGIONID, BIDTYPE |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| DISPATCH_FCAS_REQ_CONSTRAINT_CCI |
clustered, columnstore |
n/a |
| PK_DISPATCH_FCAS_REQ_CONSTRAINT |
nonclustered, unique, primary key |
RUN_DATETIME, RUNNO, INTERVAL_DATETIME, CONSTRAINTID, REGIONID, BIDTYPE |