Query check tmp Boarding Loc Service first same: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 13: | Line 13: | ||
Uses convenience queries ''query L_First_Boarding_Loc'' and ''query L_First_Service'' | Uses convenience queries ''query L_First_Boarding_Loc'' and ''query L_First_Service'' | ||
Discussed at task 2021-04-29 that this will remain complete only for now. | |||
== Log == | == Log == |
Revision as of 11:07, 2021 April 29
Data Integrity Checks | |
Summary: | Validates that the DtTm for the first Service tmp entry is the same as that for the first Boarding Loc entry |
Related: | Boarding Loc, Service tmp entry |
Firmness: | hard check |
Timing: | complete |
App: | CCMDB.accdb |
Coding: | query check_tmp_Boarding_Loc_Service_first_same |
Uses L Problem table: | not relevant for this app |
Status: | implemented |
Implementation Date: | 2021-04-29 |
Backlogged: | true |
We decided during Task Team Meeting - Rolling Agenda and Minutes 2021#ICU Database Task Group Meeting – April 22, 2021 that the first Service tmp entry DtTm should be the same as that for the first Boarding Loc entry. This cross check validates that.
Uses convenience queries query L_First_Boarding_Loc and query L_First_Service
Discussed at task 2021-04-29 that this will remain complete only for now.
Log
2021-04-29 - Implemented for RecordStatus = "complete" only because there were tons of errors that would prevent sending if I do it for all; do we want to shift to doing it for all?