Check duplicate patient: Difference between revisions

m Text replacement - "| DIC_app" to "| DIC_timing = complete always | DIC_app"
 
(18 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
| DIC_summary = there are no dupliate entries for the same patient ward admission on the laptop at send time
| 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]]
| DIC_related_concepts = PHIN; DOB; Chart number; First Name; Last Name; Service tmp entry; Dispo DtTm
| DIC_firmness = hard check  
| DIC_firmness = hard check  
| DIC_timing = complete always
| DIC_timing =
| DIC_app = CCMDB.mdb
| DIC_app = CCMDB.accdb
| DIC_coding = functions ''has_multiples()'' and ''overlap()'' and query ''Check_pt_multiples''  
| DIC_coding = functions ''has_multiples()'' and ''overlap()'' and query ''Check_pt_multiples''  
| DIC_status = needs review
| DIC_status = implemented
| DIC_implementation_date = date change was rolled out / first applied
| DIC_implementation_date = date change was rolled out / first applied
}}
}}


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 [[sending | send]] '''any''' patients.  
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 [[Arrive DtTm]] / [[Dispo DtTm]]:  
Duplicates of the following with overlapping first [[Service tmp entry]] / [[Dispo DtTm]]:  
* [[Chart number]]
* [[Chart number]]
* [[PHIN]] (except 999999999 for [[PHIN_field#Location_Manitoba_and_no_PHIN]])
* [[PHIN]] (except 999999999 for [[PHIN_field#Location_Manitoba_and_no_PHIN]])
* combination of ([[DOB]], [[First Name]], [[Last Name]])
* 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


== Related articles ==
== Related articles ==
{{Related Articles}}
{{Related Articles}}


[[Category: Data Collection Guide]]
[[Category:Registry checks]]
[[Category:CCMDB Data Integrity Checks]]