PREDISPATCH_FCAS_REQ
PREDISPATCH_FCAS_REQ shows Predispatch Constraint tracking for Regional FCAS Requirements.
Package
PRE_DISPATCH
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| PREDISPATCHSEQNO |
varchar(20) |
int  |
PreDispatch Sequence number |
| INTERVENTION |
numeric(2, 0) |
bit |
Intervention Flag |
| GENCONID |
varchar(20) |
varchar(20) |
Generic Constraint ID - Join to table GenConData |
| REGIONID |
varchar(10) |
varchar(10) |
Region ID |
| BIDTYPE |
varchar(10) |
varchar(10) |
Bid Type Identifier |
| DATETIME |
datetime(3) |
datetime2(0) |
Date and Time of trading interval |
| GENCONEFFECTIVEDATE |
datetime(3) |
date |
Generic Constraint EffectiveDate - Join to table GenConData |
| GENCONVERSIONNO |
numeric(3, 0) |
smallint |
Generic Constraint Version number - Join to table GenConData |
| MARGINALVALUE |
numeric(16, 6) |
numeric(16, 6) |
Marginal Value of generic constraint |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| 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, before the regulation/contingency split |
| ESTIMATED_CMPF |
numeric(18, 8) |
numeric(18, 8) |
An estimated value for the constraint CMPF, based on dispatched data |
| ESTIMATED_CRMPF |
numeric(18, 8) |
numeric(18, 8) |
An estimated value for the constraint CRMPF, based on dispatched 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 factor for CRMPF based recovery |
Removed columns
| Column |
Official MMS Datatype |
Comment |
| RUNNO |
numeric(3, 0) |
Case Run number |
| PERIODID |
varchar(20) |
Unique period identifier, in the format yyyymmddpp. The period (pp) is 01 to 48, with 01 corresponding to the half-hour ending at 04:30am. |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PREDISPATCH_FCAS_REQ_LCX |
nonclustered |
LASTCHANGED |
| PREDISPATCH_FCAS_REQ_PK |
clustered, unique, primary key |
DATETIME, GENCONID, REGIONID, BIDTYPE |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_PREDISPATCH_FCAS_REQ |
clustered, unique, primary key |
PREDISPATCHSEQNO, INTERVENTION, REGIONID, BIDTYPE, GENCONID, DATETIME |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_PREDISPATCH_FCAS_REQ |
nonclustered, unique, primary key |
PREDISPATCHSEQNO, INTERVENTION, REGIONID, GENCONID, BIDTYPE, DATETIME |
| PREDISPATCH_FCAS_REQ_CCI |
clustered, columnstore |
n/a |