Query check tmp Boarding Loc Service first same: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 12: | Line 12: | ||
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. | 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 | Uses convenience queries [[Created_FirstLocation query]] and [[Created_FirstService query]] | ||
Discussed at task 2021-04-29 that this will remain complete only for now. | Discussed at task 2021-04-29 that this will remain complete only for now. | ||
== Log == | == Log == | ||
2021-05-03 - updated | * 2021-10-07 - decided to shift this query to doing the check for complete and incomplete, since the [[Statistician]] does use this data for incomplete profiles | ||
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-05-03 - updated [[Created_FirstLocation query]] and [[Created_FirstService query]] 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 == | ||