Link suspect not same visitAdmitDtTm query: Difference between revisions

(15 intermediate revisions by 2 users not shown)

Line 1:

{{Data Integrity Check

|DIC_summary=Checks for records ~~where~~ [[Visit Admit DtTm field]] ~~should likely be the same but is not~~. ~~{{Discussion}} should be based on what?~~

|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

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

|DIC_firmness=soft check

|DIC_coding=~~query~~ ''Link_suspect_not_same_visitAdmitDtTm''

|DIC_coding=''Link_suspect_not_same_visitAdmitDtTm'' query

|DIC_status=implemented

|DIC_LProblem=~~Yes~~

|DIC_LProblem=no

|DIC_app=Centralized data front end.accdb

|DIC_backlogged=No

}}

{{Discuss | ~~who~~ = ~~Tina | question~~ = ~~confirm~~:

* ~~this one likely uses~~ the [[~~L Problem table~~]].~~.. no?~~

{{Discuss |

* is ~~description really what~~ this ~~does? }}~~

* 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:

* have different [[Visit Admit DtTm]]

* the both [[Visit Admit DtTm]]s are less than 2 years ago (to reduce query size)

* the earlier is not [[Dispo]] to "Home" or "AMA (left against medical advice)"

* 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 '''OR'''

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

:)

== Log ==

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

[[Category:Registry checks]]

@@ Line 1: / Line 1: @@
+{{DISPLAYTITLE:Link_suspect_not_same_visitAdmitDtTm query}}
 {{Data Integrity Check
-|DIC_summary=Checks for records where [[Visit Admit DtTm field]] should likely be the same but is not. {{Discussion}} should be based on what?
+|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
+|DIC_related_concepts=Visit Admit DtTm field; Dispo; Service/Location; Previous Location; Pre-admit Inpatient Institution
 |DIC_firmness=soft check
-|DIC_coding=query ''Link_suspect_not_same_visitAdmitDtTm''
+|DIC_coding=''Link_suspect_not_same_visitAdmitDtTm'' query
 |DIC_status=implemented
-|DIC_LProblem=Yes
+|DIC_LProblem=no
 |DIC_app=Centralized data front end.accdb
+|DIC_backlogged=No
 }}
-{{Discuss | who = Tina | question = confirm:
-* this one likely uses the [[L Problem table]]... no?
+{{Discuss |
-* is description really what this does? }}
+* 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:
+* have different [[Visit Admit DtTm]]
+* the both [[Visit Admit DtTm]]s are less than 2 years ago (to reduce query size)
+* the earlier is not [[Dispo]] to "Home" or "AMA (left against medical advice)"
+* 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 '''OR'''
+:* first [[dispo]] and second [[Pre-admit Inpatient Institution]] or [[Previous Location]]
+:)
+== Log ==
+* 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 ==
 {{Related Articles}}
 [[Category:Registry checks]]