Stop using Integer ID’s in your Database

numbers referring to the same patient.

The problem is that most companies don’t apply the required forethought to creating the right primary keys to allow data from different channels to be merged.