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.

Error scenario

2018-06-01; Problem sending A4 Val Penner. Error message Re: Duplicate patients......Screen shots of the error message sent to Pagasa. Copy of the csv file in Pagasa's C drive. Serial# 15268 & 15306 no obvious problem other than MB Province both had PHIN# 999999999. Collector solution ended up being to changed one PHIN to 123456789.

• The correct data collection process if province is MB and no PHIN go to: PHIN field. Staff sent link to collection instructions & main office review also.