Snapshot of Global Party Status
A new table FCC_ER_GLOBAL_PARTY_STATUS is introduced. This table records the status of global parties for each FIC_MIS_DATE (batch run), enabling clear identification and tracking of changes across batch executions.
The parties are further categorized as:
- N (New): A newly created global party ID resulting from newly formed probable group or split from previous group.
- U (Updated/Modified): A global party ID that has changed due to a split or merge involving one or more associated parties.
- R (Retained/Unmodified): An existing global party ID that remains unchanged, as there are no changes to the associated party IDs linked to it.
- D (Deleted): An active global party ID that is deactivated in the current run due to split or deletion of parties in it's group.
Below is an example for FCC_ER_GLOBAL_PARTY_STATUS after execution of ER batches from 10-DEC-2015 to 14-DEC-2015.
Table 4-2 Sample data
| GLOBAL_ID | FIC_MIS_DATE | V_STATUS |
|---|---|---|
| G1 | 10-12-2015 | N |
| G1 | 11-12-2025 | U |
| G1 | 12-12-2015 | R |
| G2 | 12-12-2015 | N |
| G1 | 13-12-2015 | R |
| G2 | 13-12-2015 | U |
| G3 | 13-12-2015 | N |
| G4 | 13-12-2015 | N |
| G1 | 14-12-2015 | R |
| G2 | 14-12-2015 | R |
| G3 | 14-12-2015 | R |
| G4 | 14-12-2015 | D |