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. It is one source of many Duplicate error messages.

Log

• 2024-04-24 - There are many false positives due to ICU delays shorter than 30 mins. Lisa confirmed that we should keep the thresholds, collectors are not happy about how many times the soft check prompts them, at least 3 when checking off the box, and then a couple more when we complete the file. This is a matter of Duplicate error messages.
• 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