Link suspect not same visitAdmitDtTm query: Difference between revisions

(9 intermediate revisions by 2 users not shown)

Line 1:

{{Data Integrity Check

|DIC_summary= Checks for records that are likely part of the same admission but have different [[Visit Admit DtTm field]].

|DIC_summary=Checks for records that are likely part of the same admission but have different [[Visit Admit DtTm field]].

|DIC_related_concepts=Visit Admit DtTm field; Dispo; Service/Location; Previous Location; Pre-admit Inpatient Institution

|DIC_firmness=soft check

|DIC_coding=''Link_suspect_not_same_visitAdmitDtTm'' query

|DIC_status=implemented

|DIC_LProblem=No

|DIC_LProblem=no

|DIC_app=Centralized data front end.accdb

|DIC_backlogged=No

}}

{{Discuss |

* Found a record from last Oct in this query so emailed Julie and Pagasa to see if we are still running this. Guess that raises the question if [[Correcting suspect links]] is still being followed, and [[Centralized data Vetting Process]] in general. [[User:Ttenbergen|Ttenbergen]] 22:49, 11 March 2025 (CDT)

}}

== What does this actually check? ==

As of 2022-02-16 the query looks for records that:

Line 15:

Line 22:

* both profiles are at the same site

* have a difference of less than 1 day between the dispo at the first location and the Arrive at the second.

* have a difference of less than 7 days between the dispo at the first location and the Arrive at the second '''and''' (first [[dispo]] and second [[Service/Location]] match '''OR''' first [[Service/Location]] and second [[Pre-admit Inpatient Institution]] match '''OR''' first [[Service/Location]] and second [[Previous Location]] match

* have a difference of less than 7 days between the dispo at the first location and the Arrive at the second '''and'''

:(

:* (first [[dispo]] and second [[Service/Location]] match '''OR'''

:* first [[Service/Location]] and second [[Pre-admit Inpatient Institution]] match '''OR'''

:* first [[Service/Location]] and second [[Previous Location]] match '''OR'''

:* first [[dispo]] and second [[Pre-admit Inpatient Institution]] or [[Previous Location]]

:)

== Log ==

2022-02-16 - updated query to use new [[Created AdmitDtTm query]] instead of Accept or Arrive dttm; also pulled some filters into intermediate query to filter earlier to make more efficient [[User:Ttenbergen|Ttenbergen]] 15:37, 2022 February 16 (CST)

* 2023-06-07 - deleted old Link_suspect_not_same_visitAdmitDtTm query and renamed query ''link_suspect_not_same_visitAdmitDtTm_foo'' to that; seems the difference to the old query is that the new one excludes records that are not from the same site

* 2022-05-04 - had false positives, updated to also check that the earlier and later record are at the same site

* 2022-04-05 - something went wrong with this query, and likely got corrupted and re-saving it fixed it

* 2022-03-09 - tweaked query to only consider 4th option if at same site.

* 2022-02-16 - updated query to use new [[Created AdmitDtTm query]] instead of Accept or Arrive dttm; also pulled some filters into intermediate query to filter earlier to make more efficient [[User:Ttenbergen|Ttenbergen]] 15:37, 2022 February 16 (CST)

== Related articles ==

@@ Line 1: / Line 1: @@
+{{DISPLAYTITLE:Link_suspect_not_same_visitAdmitDtTm query}}
 {{Data Integrity Check
-|DIC_summary= Checks for records that are likely part of the same admission but have different [[Visit Admit DtTm field]].
+|DIC_summary=Checks for records that are likely part of the same admission but have different [[Visit Admit DtTm field]].
 |DIC_related_concepts=Visit Admit DtTm field; Dispo; Service/Location; Previous Location; Pre-admit Inpatient Institution
 |DIC_firmness=soft check
 |DIC_coding=''Link_suspect_not_same_visitAdmitDtTm'' query
 |DIC_status=implemented
-|DIC_LProblem=No
+|DIC_LProblem=no
 |DIC_app=Centralized data front end.accdb
+|DIC_backlogged=No
 }}
+{{Discuss |
+* Found a record from last Oct in this query so emailed Julie and Pagasa to see if we are still running this. Guess that raises the question if [[Correcting suspect links]] is still being followed, and [[Centralized data Vetting Process]] in general. [[User:Ttenbergen|Ttenbergen]] 22:49, 11 March 2025 (CDT)
+}}
 == What does this actually check? ==
 As of 2022-02-16 the query looks for records that:
@@ Line 15: / Line 22: @@
 * both profiles are at the same site
 * have a difference of less than 1 day between the dispo at the first location and the Arrive at the second.
-* have a difference of less than 7 days  between the dispo at the first location and the Arrive at the second '''and''' (first [[dispo]] and second [[Service/Location]] match '''OR''' first [[Service/Location]] and second [[Pre-admit Inpatient Institution]] match '''OR''' first [[Service/Location]] and second [[Previous Location]] match
+* have a difference of less than 7 days  between the dispo at the first location and the Arrive at the second '''and'''
+:(
+:* (first [[dispo]] and second [[Service/Location]] match '''OR'''
+:* first [[Service/Location]] and second [[Pre-admit Inpatient Institution]] match '''OR'''
+:* first [[Service/Location]] and second [[Previous Location]] match '''OR'''
+:* first [[dispo]] and second [[Pre-admit Inpatient Institution]] or [[Previous Location]]
+:)
 == Log ==
--02-16 - updated query to use new [[Created AdmitDtTm query]] instead of Accept or Arrive dttm; also pulled some filters into intermediate query to filter earlier to make more efficient [[User:Ttenbergen|Ttenbergen]] 15:37, 2022 February 16 (CST)
+* 2023-06-07 - deleted old Link_suspect_not_same_visitAdmitDtTm query and renamed query ''link_suspect_not_same_visitAdmitDtTm_foo'' to that; seems the difference to the old query is that the new one excludes records that are not from the same site
+* 2022-05-04 - had false positives, updated to also check that the earlier and later record are at the same site
+* 2022-04-05 - something went wrong with this query, and likely got corrupted and re-saving it fixed it
+* 2022-03-09 - tweaked query to only consider 4th option if at same site.
+* 2022-02-16 - updated query to use new [[Created AdmitDtTm query]] instead of Accept or Arrive dttm; also pulled some filters into intermediate query to filter earlier to make more efficient [[User:Ttenbergen|Ttenbergen]] 15:37, 2022 February 16 (CST)
 == Related articles ==