4.9.4 Expiry of Entity Document 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 document 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_CUSTOMER_IDENTIFCTN_DOC_PRE table. This will remove document mapping as part of the Entity Resolution batch run from the STG_CUSTOMER_IDENTIFCTN_DOC table.

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