Query s tmp Boarding Loc ER delay reasonable

Data Integrity Checks
Summary:	Flags Boarding Loc entries for ERs where a second Boarding Loc entry exists that is less than 30 min later or more than 67 hours later for CC or more than 144 hrs later for Med
Related:	Boarding Loc, ER Delay
Firmness:	soft check
Timing:	complete
App:	CCMDB.accdb
Coding:	query s_tmp_Boarding_Loc_ER_delay_reasonable
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	2022-04-14
Backlogged:	No

• Cargo

• SMW

• Categories:  

• form:

This query validates the ER Delay.

Log

• 2024-04-24

There are many false positives due to ICU delays shorter than 30 mins. Do we want to change anything about that threshold? Discussed with Julie and Lisa today but can't remember the outcome. Ttenbergen 10:58, 2024 April 24 (CDT)

• SMW

• Cargo

• Categories

• 2023-11-26 - confirmed that this query derives program in a way that should still work after Change to having each collector collect both programs on the same laptop
• 2022-04-27 - further increased threshold for Med to 144 because we were still seeing to many false positives
• 2022-04-21 - updated the threshold to new mean+3sd as provided by Julie: 73hrs for Med and 67hrs for CC
• 2022-04-14 Implemented