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:	always
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. Property "DICRelatedConcepts" (as page type) with input value "PHIN]], DOB, Chart number, First Name, [[Last Name" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process.

• 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)