Check duplicate patient

Template:CCMDB Data Integrity Checks

The same patient should not be on a laptop/PDA twice with overlapping Admit/Discharge times. If there is a patient like that you will get an error.

Definition

Duplicates of the following with overlapping admit/discharge dates:

• chart number
• phin
• combination of (DOB, fname, lname)

IT Instructions

Uses functions has_multiples() and overlap() and query Check_pt_multiples.