DISPATCH_FCAS_REQ
DISPATCH_FCAS_REQ shows Dispatch Constraint tracking for Regional FCAS recovery.
Package
DISPATCH
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Settlement date and time of Dispatch Interval |
| INTERVENTION |
numeric(2, 0) |
bit |
Intervention Flag |
| GENCONID |
varchar(20) |
varchar(20) |
Generic Constraint ID - Join to table GenConData |
| REGIONID |
varchar(10) |
varchar(10) |
- |
| BIDTYPE |
varchar(10) |
varchar(10) |
DUID offered type |
| RUNNO |
numeric(3, 0) |
tinyint |
Dispatch run no; always 1 |
| 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) |
- |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Date record is 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 |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| DISPATCH_FCAS_REQ_LCX |
nonclustered |
LASTCHANGED |
| DISPATCH_FCAS_REQ_PK |
clustered, unique, primary key |
SETTLEMENTDATE, RUNNO, INTERVENTION, GENCONID, REGIONID, BIDTYPE |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_DISPATCH_FCAS_REQ |
clustered, unique, primary key |
SETTLEMENTDATE, RUNNO, INTERVENTION, BIDTYPE, REGIONID, GENCONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| DISPATCH_FCAS_REQ_CCI |
clustered, columnstore |
n/a |
| PK_DISPATCH_FCAS_REQ |
nonclustered, unique, primary key |
BIDTYPE, REGIONID, SETTLEMENTDATE, RUNNO, INTERVENTION, GENCONID |