SET_FCAS_CLAWBACK_REQ
This report contains the Interval Datetime affected by the Clawback Run and the adjusted FCAS requirement Costs.
Package
SETTLEMENT_DATA
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| INTERVAL_DATETIME |
datetime(3)  |
datetime2(0) |
The Interval Datetime for which a the Clawback Run has been completed. |
| RUNNO |
numeric(3, 0) |
tinyint |
The RunNo associated with the Clawback Run for the above interval date time. |
| CONSTRAINTID |
varchar(20) |
varchar(20) |
The FCAS Constraint ID used in the FCAS Requirements. |
| REGIONID |
varchar(20) |
varchar(10) |
The Region ID associated with each Constraint Requirements |
| BIDTYPE |
varchar(10) |
varchar(10) |
The FCAS Service - DUID offered type |
| REGION_ENABLEMENT |
numeric(18, 8) |
numeric(18, 8) |
The Overridden Regional Enablement. SUM(FCAS MW) from FCAS.Clawback_Unitsolution |
| CONSTRAINT_ENABLEMENT |
numeric(18, 8) |
numeric(18, 8) |
How much is enabled for this bid Type within the constraint. Sum(Regional_Enablement) Group by Interval_Datetime, ConstraintId, BidType |
| REGION_BASE_COST |
numeric(18, 8) |
numeric(18, 8) |
The Region Base Cost adjusted by the Regional Enablement Adj Ratio |
| BASE_COST |
numeric(18, 8) |
numeric(18, 8) |
The Base cost of the constraint before the regulation/contingency split. SUM(REGION_BASE_COST) Group by interval datetime, ConstraintId |
| ADJUSTED_COST |
numeric(18, 8) |
numeric(18, 8) |
The adjusted cost of the constraint for this service, after the regulation/contingency split. This is adjusted by the Base Cost Adjustment Ratio. |
| P_REGULATION |
numeric(18, 8) |
numeric(18, 8) |
P Regulation value is not affected by Clawback. This value is copied from Original Data source(DISPATCH ) |
| PREV_REGION_ENABLEMENT |
numeric(18, 8) |
numeric(18, 8) |
The Regional Enablement before Override |
| PREV_CONSTRAINT_ENABLEMENT |
numeric(18, 8) |
numeric(18, 8) |
The Constraint Enablement before Override |
| PREV_REGION_BASE_COST |
numeric(18, 8) |
numeric(18, 8) |
The Region Base Cost before Override |
| PREV_BASE_COST |
numeric(18, 8) |
numeric(18, 8) |
The Base Cost before Override |
| PREV_ADJUSTED_COST |
numeric(18, 8) |
numeric(18, 8) |
The Adjusted Cost before override |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
The Last Changed Date time of the record. |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SET_FCAS_CLAWBACK_REQ_PK |
clustered, unique, primary key |
INTERVAL_DATETIME, RUNNO, CONSTRAINTID, REGIONID, BIDTYPE |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SET_FCAS_CLAWBACK_REQ |
clustered, unique, primary key |
INTERVAL_DATETIME, RUNNO, CONSTRAINTID, REGIONID, BIDTYPE |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SET_FCAS_CLAWBACK_REQ |
clustered, unique, primary key |
INTERVAL_DATETIME, RUNNO, CONSTRAINTID, REGIONID, BIDTYPE |