SET_APC_RECOVERY
APC Compensation recovery amounts in the Settlements timeframe.
Package
SETTLEMENT_DATA
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Settlement run date |
| VERSIONNO |
numeric(3, 0) |
smallint |
Settlement run number |
| APEVENTID |
numeric(6, 0) |
int |
AP Event Id |
| CLAIMID |
numeric(6, 0) |
int |
AP Event Claim Id |
| PARTICIPANTID |
varchar(20) |
varchar(20) |
Participant identifier |
| PERIODID |
numeric(3, 0) |
smallint |
Settlements Trading Interval. |
| REGIONID |
varchar(20) |
varchar(20) |
Region id for the recovery amount |
| RECOVERY_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
Recovery amount in the region attributable to the participant for the event claim in this interval |
| REGION_RECOVERY_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
Total Recovery amount in the region for the event claim in this interval |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SET_APC_RECOVERY_PK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, APEVENTID, CLAIMID, PARTICIPANTID, PERIODID, REGIONID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SET_APC_RECOVERY |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, APEVENTID, CLAIMID, PARTICIPANTID, PERIODID, REGIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SET_APC_RECOVERY |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, APEVENTID, CLAIMID, PARTICIPANTID, PERIODID, REGIONID |