Query s tmp Boarding Loc ER delay reasonable

From CCMDB Wiki
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
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.


  • 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: