P5MIN_FCAS_REQUIREMENT
5-minute Predispatch constraint tracking for Regional FCAS recovery.
Package
P5MIN
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| RUN_DATETIME |
datetime(3)  |
datetime2(0) |
First interval of the 5-minute Predispatch case |
| INTERVENTION |
numeric(2, 0) |
bit |
Intervention flag |
| INTERVAL_DATETIME |
datetime(3) |
datetime2(0) |
Datetime of the 5-minute Predispatch interval |
| CONSTRAINTID |
varchar(20) |
varchar(20) |
ConstraintID Join to table GenConData |
| REGIONID |
varchar(20) |
varchar(20) |
Region Identifier |
| BIDTYPE |
varchar(10) |
varchar(10) |
DUID offered type |
| CONSTRAINT_EFFECTIVEDATE |
datetime(3) |
datetime2(0) |
Constraint EffectiveDate Join to table GenConData |
| CONSTRAINT_VERSIONNO |
numeric(3, 0) |
smallint |
Constraint Version number Join to table GenConData |
| MARGINALVALUE |
numeric(18, 8) |
numeric(18, 8) |
Marginal $ value for energy |
| BASE_COST |
numeric(18, 8) |
numeric(18, 8) |
The base cost of the constraint for this service, 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 |
| ESTIMATED_CMPF |
numeric(18, 8) |
numeric(18, 8) |
An estimated value for the constraint CMPF, based on 5- minute Predispatch data |
| ESTIMATED_CRMPF |
numeric(18, 8) |
numeric(18, 8) |
An estimated value for the constraint CRMPF, based on 5-minute Predispatch data |
| RECOVERY_FACTOR_CMPF |
numeric(18, 8) |
numeric(18, 8) |
Estimated recovery factor for CMPF based recovery |
| RECOVERY_FACTOR_CRMPF |
numeric(18, 8) |
numeric(18, 8) |
Estimated recovery for CRMPF based recovery |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last changed date for the record |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| P5MIN_FCAS_REQUIREMENT_PK |
clustered, unique, primary key |
RUN_DATETIME, INTERVAL_DATETIME, CONSTRAINTID, REGIONID, BIDTYPE |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_P5MIN_FCAS_REQUIREMENT |
clustered, unique, primary key |
RUN_DATETIME, INTERVENTION, INTERVAL_DATETIME, CONSTRAINTID, REGIONID, BIDTYPE |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| P5MIN_FCAS_REQUIREMENT_CCI |
clustered, columnstore |
n/a |
| PK_P5MIN_FCAS_REQUIREMENT |
nonclustered, unique, primary key |
RUN_DATETIME, INTERVENTION, REGIONID, BIDTYPE, CONSTRAINTID, INTERVAL_DATETIME |