Edit Data Integrity Check: Link suspect not same visitAdmitDtTm query

Are you logged on?

You do not have permission to edit this page, for the following reason:

The action you have requested is limited to users in the group: CCMDB_legit.

Summary (what is the check, one-liner):
links to related pages:
Firmness (is this a warning only (soft check) or will it stop sending (hard check) - applicable only in CCMDB.accdb app):	None/unknown hard check soft check
Timing (does this query run for all records or only complete ones):	None/unknown complete always
Name of the function or query this is implemented as:	''Link_suspect_not_same_visitAdmitDtTm'' query
Implementation date:
Implementation Status:
L_Problem (are false positive special cases addressed in table L_Problems - applicable only in CFE):	None/unknown Yes No
App:
Backlogged (is this query cleaned up to date or backlogged? Applicable only in CFE):

Free text:

{{DISPLAYTITLE:Link_suspect_not_same_visitAdmitDtTm query}} {{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: * 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]]

Explain your edit, if you think it needs explanation (e.g. "as discussed with ...", or "content moved to ...", or "duplicate content, see ..."):

This is a minor edit

Watch this page

Cancel