Removal of Addresses

Deletion of address from STG_ADDRESS_MASTER can be achieved by providing input to STG_DELETED_ADDRESS_MASTER_PRE. This is a new table introduced as part of ER Data Model. Address IDs for deletion must be populated in this table against the FIC_MIS_DATE. If an address ID is provided in this table and the address is not actively mapped, the corresponding record is deleted from STG_ADDRESS_MASTER.

Removal of addresses is supported only when deltaComputed is set to true for ER Job 1.

Note:

If any address listed in STG_DELETED_ADDRESS_MASTER_PRE for a given FIC_MIS_DATE is actively mapped to a party, then all addresses in STG_DELETED_ADDRESS_MASTER_PRE are considered active and none are deleted. In this case, the validation fails and no records are removed from the table. After excluding the active addresses, the remaining addresses can be provided to STG_DELETED_ADDRESS_MASTER_PRE on a new FIC_MIS_DATE.