4.9.2 Expiry of Entity Phone 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 phone 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_PHONE_MAP_PRE table. This will remove the phone mapping as part of the Entity Resolution batch run from the STG_PARTY_PHONE_MAP table.

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