| 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.
Log
- 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