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 1: | Line 1: | ||
{{Data Integrity Check | {{Data Integrity Check | ||
|DIC_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 | |DIC_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 | ||
|DIC_related_concepts=Boarding Loc; ER Delay | |DIC_related_concepts=Boarding Loc; ER Delay | ||
|DIC_firmness=soft check | |DIC_firmness=soft check |
Revision as of 10:41, 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.
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
Related articles: |