CCMDB Wiki

Link suspect negative transit time query: Difference between revisions

← Older edit
mNo edit summary
m Text replacement - "|DIC_LProblem=yes" to "|DIC_LProblem=Yes"
 
(18 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
|DIC_summary=Used in [[Correcting suspect links]] to find records where an earlier record for a patient with that [[PHIN]] has a [[Dispo DtTm]] that is later than the next record's [[Arrive DtTm]].
|DIC_summary=Used in [[Correcting suspect links]] to find records where an earlier record for a patient with that [[PHIN]] has a [[Dispo DtTm]] that is later than the next record's [[Admit DtTm]].
|DIC_related_concepts=PHIN; Arrive DtTm field; Dispo DtTm field
|DIC_related_concepts=PHIN; Admit DtTm; Dispo DtTm field
|DIC_firmness=hard check
|DIC_firmness=hard check
|DIC_coding=query ''link_suspect_negative_transit_time''
|DIC_coding=''link_suspect_negative_transit_time'' query
|DIC_status=implemented
|DIC_status=implemented
|DIC_LProblem=Yes
|DIC_LProblem=Yes
|DIC_app=Centralized data front end.accdb
|DIC_app=Centralized data front end.accdb
|DIC_backlogged=No
}}
}}
Follow steps in [[Processing errors in patient data]] to fix errors found.
Generally follow steps in [[Processing errors in patient data]] to fix errors found.


If after correcting the query and if still showing the negative query click the "populate linking_pairs" again and it will update the linking error.  
== Specific error fixing info for this query ==
* You have to click the [[Cat button|hand shake]] to see the admission the patient
* Most of the error on this query the discharged date of the first admission is after the second admission, if the case is this scenario,  I just change the discharged date without looking the EPR
* Sometimes this query triggers as a side effect for errors that are actually [[link_suspect_mismatch_pre_inpt_should_be_ours_incomplete query]], ie error continuous admission the second admission was admitted to ER
 
== Still shows records after errors are fixed ==
If after correcting the errors in this query it still shows entries, re-do [[Populate linking pairs]] and it will update the linking error.


== log ==
== log ==
* 2022-07-13 - updated to only show if diff is > 30min
* 2022-04-05 - updated to use [[Admit DtTm]]
* 2021-10-07 - changed overlap threshold to 1s because we were getting false positives since arrive dttm and dispo dttm come in at different precision/resolution from Cognos
* 08:58, 2019 January 30 (CST): fixed problem with field name in query
* 08:58, 2019 January 30 (CST): fixed problem with field name in query


Line 18: Line 29:
{{Related Articles}}
{{Related Articles}}


[[Category: Data Processing]]
[[Category:Data Processing]]
[[Category:Multiple Encounter linking]]
[[Category:Multiple Encounter linking]]
[[Category:Multiple encounter longitudinal consistency check]]
[[Category:Multiple encounter longitudinal consistency check]]
[[Category:Registry checks]]
[[Category:Registry checks]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Link_suspect_negative_transit_time_query"