Link suspect not same visitAdmitDtTm query: Difference between revisions

(7 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_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)

}}

Line 25:

Line 31:

== 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_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)
 }}
@@ Line 25: / Line 31: @@
 == 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 ==