Check duplicate patient: Difference between revisions

(23 intermediate revisions by the same user not shown)

Line 1:

{{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_app = CCMDB.~~mdb~~

| DIC_timing =

| DIC_app = CCMDB.accdb

| DIC_coding = functions ''has_multiples()'' and ''overlap()'' and query ''Check_pt_multiples''

| DIC_status = implemented

Line 9:

Line 10:

}}

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

Duplicates of the following with overlapping ~~admit~~/~~discharge dates~~:

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

* [[Chart number]]

* [[PHIN]]

* [[PHIN]] (except 999999999 for [[PHIN_field#Location_Manitoba_and_no_PHIN]])

* 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.~~

~~== IT Instructions ==~~

~~Uses functions~~ ''~~has_multiples()'' and ''overlap()~~'' and query ~~''Check_pt_multiples''~~.

== Related articles ==

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

[[Category:Registry checks]]

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

@@ Line 1: / Line 1: @@
 {{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_app = CCMDB.mdb
+| DIC_timing =
+| DIC_app = CCMDB.accdb
 | DIC_coding = functions ''has_multiples()'' and ''overlap()'' and query ''Check_pt_multiples''
 | DIC_status = implemented
@@ Line 9: / Line 10: @@
 }}
-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 ==
-Duplicates of the following with overlapping admit/discharge dates:
+Duplicates of the following with overlapping  first [[Service tmp entry]] / [[Dispo DtTm]]:
 * [[Chart number]]
-* [[PHIN]]
+* [[PHIN]] (except 999999999 for [[PHIN_field#Location_Manitoba_and_no_PHIN]])
 * combination of ([[DOB]], [[First Name]], [[Last Name]])
-==Error scenario==
+== Log ==
--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.
-== IT Instructions ==
-Uses functions ''has_multiples()'' and ''overlap()'' and query ''Check_pt_multiples''.
 == Related articles ==
 {{Related Articles}}
-[[Category: Data Collection Guide]]
+[[Category:Registry checks]]
-[[Category:CCMDB Data Integrity Checks]]