Link suspect mismatch from ours incomplete query: Difference between revisions

(8 intermediate revisions by 2 users not shown)

Line 1:

{{Data Integrity Check

|DIC_summary=Used in [[Correcting suspect links]] to find records where a later record with that [[PHIN]] has a [[Previous Location]] entry corresponding to one of our sites as per the [[s_dispo table]].real_collection table, but an earlier corresponding entry doesn't exist for that location.

|DIC_related_concepts=PHIN field; Previous Location field

|DIC_firmness=hard check

|DIC_coding=''Link_suspect_mismatch_from_ours__incomplete'' query

|DIC_status=implemented

|DIC_LProblem=no

|DIC_app=Centralized data front end.accdb

|DIC_backlogged=No

}}

Follow steps in [[Processing errors in patient data]] to fix errors found.

~~One of the queries used in [[Correcting suspect links]].~~

~~This one lists patients where a later record with that PHIN has a~~ [[~~Previous Location~~]] ~~entry corresponding to one of our sites as per the [~~[~~s_dispo table]~~]~~.real_collection table~~, ~~but an earlier corresponding entry doesn't exist for~~ that ~~location.~~

== Log ==

* 2022-05-26 - changed the linking from previous to next to use <>s_dispoIDs and [s_dispo_early_location].[real_collection]<>[s_dispo_late_previous].[location_name]; without these, the a change we had made that turned “STB_SICU” into “STB_SICU (Legacy)” would result in false positives; also changed query to only compare up to 2018

~~Follow steps in [[Processing errors in patient data]] to fix errors found.~~

== Related articles ==

[[Category: Data Processing]]

[[Category:Multiple Encounter linking]]

[[Category:Multiple encounter longitudinal consistency check]]

[[Category:Registry checks]]

@@ Line 1: / Line 1: @@
-{{Data Integrity Check}}
+{{Data Integrity Check
+|DIC_summary=Used in [[Correcting suspect links]] to find records where a later record with that [[PHIN]] has a [[Previous Location]] entry corresponding to one of our sites as per the [[s_dispo table]].real_collection table, but an earlier corresponding entry doesn't exist for that location.
+|DIC_related_concepts=PHIN field; Previous Location field
+|DIC_firmness=hard check
+|DIC_coding=''Link_suspect_mismatch_from_ours__incomplete'' query
+|DIC_status=implemented
+|DIC_LProblem=no
+|DIC_app=Centralized data front end.accdb
+|DIC_backlogged=No
+}}
+Follow steps in [[Processing errors in patient data]] to fix errors found.
-One of the queries used in [[Correcting suspect links]].
+{{Organ donor inconsistencies}}
-This one lists patients where a later record with that PHIN has a [[Previous Location]] entry corresponding to one of our sites as per the [[s_dispo table]].real_collection table, but an earlier corresponding entry doesn't exist for that location.
+== Log ==
+* 2022-05-26 - changed the linking from previous to next to use <>s_dispoIDs and [s_dispo_early_location].[real_collection]<>[s_dispo_late_previous].[location_name]; without these, the a change we had made that turned “STB_SICU” into “STB_SICU (Legacy)” would result in false positives; also changed query to only compare up to 2018
-Follow steps in [[Processing errors in patient data]] to fix errors found.
+== Related articles ==
+{{Related Articles}}
 [[Category: Data Processing]]
 [[Category:Multiple Encounter linking]]
 [[Category:Multiple encounter longitudinal consistency check]]
+[[Category:Registry checks]]