Query check tmp Boarding Loc Service first same: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m Ttenbergen moved page Query s tmp Boarding Loc Service first same to Query check tmp Boarding Loc Service first same without leaving a redirect |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 4: | Line 4: | ||
|DIC_firmness=hard check | |DIC_firmness=hard check | ||
|DIC_timing=complete | |DIC_timing=complete | ||
|DIC_coding= query | |DIC_coding= query check_tmp_Boarding_Loc_Service_first_same | ||
|DIC_implementation_date=2021-04-29 | |DIC_implementation_date=2021-04-29 | ||
|DIC_status=implemented | |DIC_status=implemented | ||
| Line 13: | Line 13: | ||
== Log == | == Log == | ||
2021-04-29 - | 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? | ||
== Related articles == | == Related articles == | ||
Revision as of 09:33, 29 April 2021
| 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 |
Uses convenience queries query L_First_Boarding_Loc and query L_First_Service
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?