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 8 hours later for CC or more than 44 hrs later for Med | |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 8 hours later for CC or more than 44 hrs later for Med | ||
|DIC_related_concepts=Boarding Loc | |DIC_related_concepts=Boarding Loc; ER Delay | ||
|DIC_firmness=soft check | |DIC_firmness=soft check | ||
|DIC_timing=complete | |DIC_timing=complete | ||
| Line 11: | Line 11: | ||
|DIC_backlogged=No | |DIC_backlogged=No | ||
}} | }} | ||
This query validates the [[ER Delay]]. | |||
== Log == | == Log == | ||
Revision as of 14:57, 14 April 2022
| 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 8 hours later for CC or more than 44 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
2022-04-14 Implementing
Related articles
| Related articles: |