Check duplicate patient: Difference between revisions

mNo edit summary
 
(30 intermediate revisions by the same user not shown)
Line 1: Line 1:
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.  
{{Data Integrity Check
| DIC_summary = there are no duplicate entries for the same patient ward admission on the laptop at send time
| DIC_related_concepts = PHIN; DOB; Chart number; First Name; Last Name; Service tmp entry; Dispo DtTm
| DIC_firmness = hard check
| DIC_timing =
| DIC_app = CCMDB.accdb
| DIC_coding = functions ''has_multiples()'' and ''overlap()'' and query ''Check_pt_multiples''
| DIC_status = implemented
| DIC_implementation_date = date change was rolled out / first applied
}}
 
The same patient should not be on a laptop twice with overlapping admission periods. If there is a patient like that you will get an error and you will not be able to [[sending | send]] '''any''' patients. Function Overlap defines what it means for two timeframes to overlap.  


== Definition ==
== Definition ==
Duplicates of the following with overlapping admit/discharge dates:  
Duplicates of the following with overlapping first [[Service tmp entry]] / [[Dispo DtTm]]:  
* chart number
* [[Chart number]]
* phin
* [[PHIN]] (except 999999999 for [[PHIN_field#Location_Manitoba_and_no_PHIN]])
* combination of (DOB, fname, lname)
* combination of ([[DOB]], [[First Name]], [[Last Name]])
 
== Log ==
* 2022-03-31 - updated to use first [[Service tmp entry]] instead of ''Accept DtTm''
* 2021-01-22 - better labels and included the relevant dates right in the query listing.
* 2019-10-27 - changed to only include if recordstatus is complete or incomplete


== IT Instructions ==  
== Related articles ==
Uses functions ''has_multiples()'' and ''overlap()'' and query ''Check_pt_multiples''.
{{Related Articles}}


[[Category: Data Collection Guide]]
[[Category:Registry checks]]
[[Category: CCMDB.mdb]]