Check duplicate patient: Difference between revisions

(24 intermediate revisions by the same user not shown)

Line 1:

=={{~~CCMDB~~ Data Integrity ~~Checks~~|implemented}}==

{{Data Integrity Check

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.

| 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 ==

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]])

~~==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''.~~

== 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 ==

[[Category: ~~Data Collection Guide]]~~

[[Category:Registry checks]]

~~[[Category:CCMDB Data Integrity Checks~~]]

@@ Line 1: / Line 1: @@
-=={{CCMDB Data Integrity Checks|implemented}}==
+{{Data Integrity Check
-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.
+| 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 ==
-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]])
-==Error scenario==
--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''.
+== 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}}
-[[Category: Data Collection Guide]]
+[[Category:Registry checks]]
-[[Category:CCMDB Data Integrity Checks]]