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

failed on dev

SELECT * from merge_candidates where id = 'a9bb1628-1fbb-435e-87e2-127b51e005e3' 


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

passed

  • mpi.merged_candidates.status =  STALE


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

passed

  • mpi.merged_candidates.status =  STALE

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

passed

  • mpi.merged_candidates.status =  DECLINED

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