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

(2 intermediate revisions by the same user not shown)

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]]

Line 17:

== Log ==

* 2022-04-14 - removed [[Accept DtTm]] in preparation for retiring this concept

* 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

* 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-05-03 - updated [[Created_FirstLocation query]] and [[Created_FirstService query]] which had used "first" where they should have used "min"

@@ 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]]
@@ Line 17: / Line 17: @@
 == Log ==
-* 2022-04-14 - removed [[Accept DtTm]] in preparation for retiring this concept
+* 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
+* 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-05-03 - updated [[Created_FirstLocation query]] and [[Created_FirstService query]] which had used "first" where they should have used "min"