4.9.3 Expiry of Entity Email Mapping

Note:

This functionality is available only on the new pipeline (CSA_8128). To uptake new feature/enhancement on new pipeline from an older pipeline, contact My Oracle Support (MOS).

If an email mapped to the parties is to be removed from the system, then set the D_RECORD_END_DATE attribute as a date lesser than or equal to fic_mis_date in the STG_PARTY_EMAIL_MAP_PRE table. This will remove an email mapping as part of the Entity Resolution batch run from the STG_PARTY_EMAIL_MAP table.

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