Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


n/n
description
inputs
expected resultactual result
PD1
  • 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_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()

passed

PD2
  • 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')
PD3
  • Two persons with active declarations has been merged
  • 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
  • Person1.status = INACTIVE
  • mpi.merged_pairs-→new record inserted
  • mpi.merged_candidates.status = MERGED

preprod person_id:

('7b386455-b49e-4201-b64d-53f221f62bb7',
'ef51b639-475b-4677-b916-9bf7f4e8b0cf');
PD4
  • 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 declarations
  • Master_Person has active declaration2
  • Person1.status = INACTIVE
  • Person1.updated_by = SYSTEM_USER_ID
  • mpi.merged_pairs-→new record inserted
  • mpi.merged_candidates.status = MERGED
passed
PD5
  • 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

failed

  • Person1.status = INACTIVE
  • mpi.merged_pairs-→new record inserted
  • declaration1.status = terminated

preprod person_id:

('604ec4d2-92f5-47cd-92fb-2b86c863f7d0',
'81d23ffe-dcd1-46e5-a2cb-ebc5afa38f24')