Check duplicate patient: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
 
(20 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_app = CCMDB.mdb
| DIC_timing =
| 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]]
* [[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]])


==Error scenario==
== Log ==
2018-06-01; Problem sending A4 Val Penner.
* 2022-03-31 - updated to use first [[Service tmp entry]] instead of ''Accept DtTm''
Error message Re: Duplicate patients......Screen shots of the error message sent to Pagasa.  Copy of the csv file in Pagasa's C drive.
* 2021-01-22 - better labels and included the relevant dates right in the query listing.  
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. 
* 2019-10-27 - changed to only include if recordstatus is complete or incomplete
*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.
{{Discuss | who=Tina | question =
* We need to accommodate the 99999999 used when [[PHIN_field#Location_Manitoba_and_no_PHIN]]. Ttenbergen 16:35, 2018 September 11 (CDT)}}
 
== other ==
from [[PHIN field]]:
{{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.
 


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


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

Latest revision as of 16:52, 21 April 2022

Data Integrity Checks
Summary: there are no duplicate entries for the same patient ward admission on the laptop at send time
Related: PHIN, DOB, Chart number, First Name, Last Name, Service tmp entry, Dispo DtTm
Firmness: hard check
Timing:
App: CCMDB.accdb
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


  • Categories:  
  • form:

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 send any patients. Function Overlap defines what it means for two timeframes to overlap.

Definition

Duplicates of the following with overlapping first Service tmp entry / Dispo DtTm:

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: