Link suspect not same visitAdmitDtTm query: Difference between revisions
Ttenbergen (talk | contribs) m →Log |
Ttenbergen (talk | contribs) No edit summary |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{DISPLAYTITLE:Link_suspect_not_same_visitAdmitDtTm query}} | |||
{{Data Integrity Check | {{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]]. | ||
| Line 9: | Line 10: | ||
|DIC_backlogged=No | |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? == | == What does this actually check? == | ||
As of 2022-02-16 the query looks for records that: | As of 2022-02-16 the query looks for records that: | ||
| Line 25: | Line 31: | ||
== Log == | == 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-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-03-09 - tweaked query to only consider 4th option if at same site. | ||