4.9.1 Expiry of Entity Address Mapping

If an address mapped to the parties is to be removed from the system, then set the D_ADDRESS_END_DATE attribute as a date lesser than or equal to fic_mis_date in the STG_PARTY_ADDRESS_MAP_PRE table. This will remove the address mapping as part of the Entity Resolution batch run from the STG_PARTY_ADDRESS_MAP table but the mapped address will be available in the STG_ADDRESS_MASTER table.

The expired address mapping records will be loaded into the history tables (H$STG_PARTY_ADDRESS_MAP_PRE and H$STG_ADDRESS_MASTER_PRE), and it will not be present in the flattened input table (FCC_ER_FULL).