Link suspect negative transit time query: Difference between revisions

Revision as of 15:07, 24 March 2022

Data Integrity Checks
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.
Related:	PHIN, Arrive DtTm field, Dispo DtTm field
Firmness:	hard check
Timing:	always
App:	Centralized data front end.accdb
Coding:	link_suspect_negative_transit_time query
Uses L Problem table:	no
Status:	implemented
Implementation Date:	not entered
Backlogged:	No

Generally follow steps in Processing errors in patient data to fix errors found.

You have to click the 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

PTorres 13:59, 2022 March 24 (CDT)

	You say "Sometimes the error continuous admission the second admission was admitted to ER" - that woldn't come up in this query, though, right? What are you actually telling someone who is doing vac relief with this? Ttenbergen 14:24, 2022 March 24 (CDT)

If after correcting the errors in this query it still shows entries, re-do Populate linking pairs and it will update the linking error.

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

@@ Line 15: / Line 15: @@
 * 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
+* 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
 [[User:PTorres|PTorres]] 13:59, 2022 March 24 (CDT)
 {{Discuss | who = Pagasa |question =