Query check tmp Boarding Loc Service first same: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m Text replacement - "cross check " to "cross check " |
||
| (5 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{Data Integrity Check | {{Data Integrity Check | ||
|DIC_summary=Validates that the DtTm for the first [[Service tmp entry]] is the same as that for the first [[Boarding Loc]] entry | |DIC_summary=Validates that the DtTm for the first [[Service tmp entry]] is the same as that for the first [[Boarding Loc]] entry | ||
|DIC_related_concepts=Boarding Loc; Service tmp entry | |DIC_related_concepts=Boarding Loc; Service tmp entry | ||
|DIC_firmness=hard check | |DIC_firmness=hard check | ||
|DIC_timing=complete | |DIC_timing=complete | ||
|DIC_coding= query check_tmp_Boarding_Loc_Service_first_same | |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 10: | Line 10: | ||
}} | }} | ||
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 [[Created_FirstLocation query]] and [[Created_FirstService query]] | Uses convenience queries [[Created_FirstLocation query]] and [[Created_FirstService query]] | ||
| Line 17: | Line 17: | ||
== Log == | == Log == | ||
* 2022-02-09 - included check for | * 2022-05-25 - changed the query to a complete only query so the items can initially be entered as per Cognos, and only changed to our corrected values on chart completion, to allow keeping the [[Boarding Loc]] records linked to their counterpart [[Cognos2 Units table]] records* 2022-04-14 - removed ''Accept DtTm'' in preparation for retiring this concept | ||
* 2022-02-14 - excluded [[RecordStatus]] <>"sent" And <>"deleted" | |||
* 2022-02-09 - included check for ''Accept DtTm'' being same as well | |||
* 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-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-05-03 - updated [[Created_FirstLocation query]] and [[Created_FirstService query]] which had used "first" where they should have used "min" | * 2021-05-03 - updated [[Created_FirstLocation query]] and [[Created_FirstService query]] which had used "first" where they should have used "min" | ||