Page Comparison

• Two persons with active declarations has been merged
• no changes since the dedup run

• Person1 and Person2 presented in Merge_candidates with score > 0.95
• Person1 has active declaration1
• Master_Person has active declaration2
• Master_Person.updated_at > Person1.updated_at

• Person1.status = INACTIVE
• Person1.updated_at = now()Person1.updated_by = SYSTEM_USER_ID
• mpi.merged_pairs-→new record inserted
• mpi.merged_candidates.status = MERGED
• Declaration1.status = TERMINATED
• Declaration1.reason = AUTO_MERGE
• Declaration1.updated_at = now()

• Declaration1.updated_at <> now()

• Two persons with active declarations has been merged
• Person1 has been updated after dedup run

• Person1 and Master_Person presented in Merge_candidates with score > 0.95
• Person1 has active declaration1
• Master_Person has active declaration2
• Person1.updated_at >= merge_candidate.inserted_at

• mpi.merged_candidates.status = SKIPPED

• • Person1.status = INACTIVE
  • mpi.merged_pairs-→new record inserted
  • mpi.merged_candidates.status = MERGED

preprod person_id:

('5c6b03bc-0bfe-4151-9113-ae218258d533',
'ef51b639-475b-4677-b916-9bf7f4e8b0cf')

• Two persons with active declarations has been merged
• Person2 has Master_Person has been updated after dedup run

• Person1 and Master_Person presented in Merge_candidates with score > 0.95
• Person1 has active declaration1
• Master_Person has active declaration2
• Master_Person.updated_at >= merge_candidate.inserted_a

• mpi.merged_candidates.status = SKIPPED

• Two persons has been merged
• Master person has active declaration
• Person1 has no declarations

• Person1 and Master_Person presented in Merge_candidates with score > 0.95
• Person1 has no active declaration1declarations
• Master_Person has active declaration2

• Person1.status = INACTIVEPerson1.updated_at = now()
• Person1.updated_by = SYSTEM_USER_ID
• mpi.merged_pairs-→new record inserted
• mpi.merged_candidates.status = MERGED

• Two persons has been merged
• Master person has no active declarations
• Person1 has active declaration1

• Person1 and Master_Person presented in Merge_candidates with score > 0.95
• Person1 has active declaration1
• Master_Person has no active declarations

• mpi.merged_candidates.status = SKIPPED