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()

failed on dev

  • mpi.merged_candidates.status = DECLINED
SELECT * from merge_candidates where id = 'a9bb1628-1fbb-435e-87e2-127b51e005e3' 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 = STALE

passed

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 = STALE
passed
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 = DECLINED
passed
PD6
  • Two persons has been merged
  • Master person has no active declarations
  • Person1 has no active declarations
  • Person1 and Master_Person presented in Merge_candidates with score > 0.95
  • Person1 has no active declarations
  • Master_Person has no active declarations
  • Person1.status = INACTIVE
  • Person1.updated_by = SYSTEM_USER_ID
  • mpi.merged_pairs-→new record inserted
  • mpi.merged_candidates.status = MERGED
passed