Check duplicate patient

Data Integrity Checks
Summary:	there are no dupliate entries for the same patient ward admission on the laptop at send time
Related:	PHIN, DOB, Chart number, First Name, Last Name
Firmness:	hard check
Timing:
App:	CCMDB.mdb
Coding:	functions has_multiples() and overlap() and query Check_pt_multiples
Uses L Problem table:	not relevant for this app
Status:	needs review
Implementation Date:	date change was rolled out / first applied
Backlogged:	true

• Cargo

• SMW

"CCMDB.mdb" is not in the list (SAP, not entered, Centralized data front end.accdb, DSM Labs Consistency check.accdb, CCMDB.accdb, TISS28.accdb) of allowed values for the "DICApp" property. 

• Categories:  

• form:

The same patient should not be on a laptop twice with overlapping Arrive DtTm / Dispo DtTm. If there is a patient like that you will get an error and you will not be able to send any patients.

Definition

Duplicates of the following with overlapping Arrive DtTm / Dispo DtTm:

• Chart number
• PHIN (except 999999999 for PHIN_field#Location_Manitoba_and_no_PHIN)
• combination of (DOB, First Name, Last Name)