Query s tmp Boarding Loc ER delay reasonable
Jump to navigation
Jump to search
| 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 |
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
Related articles
| Related articles: |