|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 73 hrs later for Med|
|Related:||Boarding Loc, ER Delay|
|Uses L Problem table:||not relevant for this app|
This query validates the ER Delay.
- 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