SET_FCAS_CLAWBACK_UNITSOLN
This report contains the Interval Datetime affected by the Clawback Run and the reduced MW for the FCAS Service for each affected DUID.
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. |
| DUID |
varchar(20) |
varchar(10) |
The DUID for which the Reduced MW has been applied for the FCAS Service. |
| LOWER1SEC |
numeric(18, 8) |
numeric(18, 8) |
The Clawback Volume for the LOWER1SEC Service. If this service is not affected in that Clawback then retain Prev Value. |
| LOWER5MIN |
numeric(18, 8) |
numeric(18, 8) |
The Clawback Volume for the LOWER5MIN Service. If this service is not affected in that Clawback then retain Prev Value. |
| LOWER60SEC |
numeric(18, 8) |
numeric(18, 8) |
The Clawback Volume for the LOWER60SEC Service. If this service is not affected in that Clawback then retain Prev Value. |
| LOWER6SEC |
numeric(18, 8) |
numeric(18, 8) |
The Clawback Volume for the LOWER6SEC Service. If this service is not affected in that Clawback then retain Prev Value. |
| RAISE1SEC |
numeric(18, 8) |
numeric(18, 8) |
The Clawback Volume for the RAISE1SEC Service. If this service is not affected in that Clawback then retain Prev Value. |
| RAISE5MIN |
numeric(18, 8) |
numeric(18, 8) |
The Clawback Volume for the RAISE5MIN Service. If this service is not affected in that Clawback then retain Prev Value. |
| RAISE60SEC |
numeric(18, 8) |
numeric(18, 8) |
The Clawback Volume for the RAISE60SEC Service. If this service is not affected in that Clawback then retain Prev Value. |
| RAISE6SEC |
numeric(18, 8) |
numeric(18, 8) |
The Clawback Volume for the RAISE6SEC Service. If this service is not affected in that Clawback then retain Prev Value. |
| LOWERREG |
numeric(18, 8) |
numeric(18, 8) |
The Clawback Volume for the LOWERREG Service. If this service is not affected in that Clawback then retain Prev Value. |
| RAISEREG |
numeric(18, 8) |
numeric(18, 8) |
The Clawback Volume for the RAISEREG Service. If this service is not affected in that Clawback then retain Prev Value. |
| 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_UNITSOLN_PK |
clustered, unique, primary key |
INTERVAL_DATETIME, RUNNO, DUID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SET_FCAS_CLAWBACK_UNITSOLN |
clustered, unique, primary key |
INTERVAL_DATETIME, RUNNO, DUID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SET_FCAS_CLAWBACK_UNITSOLN |
clustered, unique, primary key |
INTERVAL_DATETIME, RUNNO, DUID |