SET_FCAS_CLAWBACK_RUN_TRK
This Settlements FCAS Clawback Run Track report contains the Interval Datetime for which a Clawback has occurred and included in the Settlement run. The report will be produced only if there is any Clawback Run for the Interval date time in the Settlement Date.
Package
SETTLEMENT_DATA
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
The Settlement Date of the Billing Week |
| VERSIONNO |
numeric(3, 0) |
smallint |
The Settlement Run No |
| INTERVAL_DATETIME |
datetime(3) |
datetime2(0) |
The Interval Datetime for which a Clawback Run has been completed. |
| RUNNO |
numeric(3, 0) |
tinyint |
The RunNo associated with the Clawback for the above interval date time. |
| CLAWBACK_DATE |
datetime(3) |
datetime2(0) |
The Date time the Clawback data has been loaded into the System for processing. |
| PREV_DATA_SOURCE |
varchar(20) |
varchar(20) |
The Clawback Data source Used. If this interval has any Clawback already applied in past then value will be CLAWBACK , else DISPATCH. For the first Clawback processing for the Interval the Source is DISPATCH. |
| 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_RUN_TRK_PK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, INTERVAL_DATETIME |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SET_FCAS_CLAWBACK_RUN_TRK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, INTERVAL_DATETIME |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SET_FCAS_CLAWBACK_RUN_TRK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, INTERVAL_DATETIME |