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

We need to accommodate the 99999999 used when PHIN_field#Location_Manitoba_and_no_PHIN. Ttenbergen 16:35, 2018 September 11 (CDT)

• SMW

• Cargo

• Categories

other

from PHIN field: Template:Discussion

• 2018-Sept-11:
  • Tina to fix integrity check: if there are two pts on laptop that are complete and being sent with Rrov of MB with PHIN of 999999999, collecting will get sending error message regarding ....same pt with overlapping admission.
    • The Error message box also has a link to an integrity check on Wiki that does not exist. This message needs to be cleaned out of ccmdb.