P5MIN_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
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 |
| INTERVAL_DATETIME |
datetime(3) |
datetime2(0) |
The 5 minute interval date and time of the 5 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 P5MIN_CONSTRAINTSOLUTION 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 P5MIN_CONSTRAINTSOLUTION table |
| MARGINALVALUE |
numeric(15, 5) |
numeric(15, 5) |
Shadow price of constraint from the P5MIN_CONSTRAINTSOLUTION 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 P5MIN_REGIONSOLUTION 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 P5MIN_REGIONSOLUTION 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) |
| P5MIN_FCAS_REQ_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_P5MIN_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) |
| P5MIN_FCAS_REQ_CONSTRAINT_CCI |
clustered, columnstore |
n/a |
| PK_P5MIN_FCAS_REQ_CONSTRAINT |
nonclustered, unique, primary key |
RUN_DATETIME, RUNNO, INTERVAL_DATETIME, CONSTRAINTID, REGIONID, BIDTYPE |