Query s tmp Boarding Loc ER delay reasonable: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 12: | Line 12: | ||
}} | }} | ||
This query validates the [[ER Delay]]. | This query validates the [[ER Delay]]. It is one source of many [[Duplicate error messages]]. | ||
== Log == | == Log == | ||
Revision as of 11:00, 2024 April 24
| 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. 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) |
- 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: |