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:	implemented
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 admit/discharge dates:

• Chart number
• PHIN
• combination of (DOB, First Name, Last Name)

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.

IT Instructions

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