Query check tmp Boarding Loc Service first same: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 17: Line 17:


== Log ==
== Log ==
2021-05-03 - updated ''query L_First_Boarding_Loc'' and ''query L_First_Service'' which had used "first" where they should have used "min"
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?  
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?  



Revision as of 14:12, 2021 May 3

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


  • SMW


  • Categories: 
  • form:

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-05-03 - updated query L_First_Boarding_Loc and query L_First_Service which had used "first" where they should have used "min" 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: