ЕСОЗ - публічна документація

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 11 Next »


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
  • mpi.merged_pairs-→new record inserted
  • Declaration1.status = TERMINATED
  • Declaration1.reason = AUTO_MERGE
  • Declaration1.updated_at = now()
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 = 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 = 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

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

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

  • No labels