Query s tmp Boarding Loc date item: Difference between revisions
Ttenbergen (talk | contribs) →first boarding loc question: I update query check_tmp_Boarding_Loc_Service_first_same to check Accept DtTm as well |
Ttenbergen (talk | contribs) m →Log |
||
| (5 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{Data Integrity Check | {{Data Integrity Check | ||
|DIC_summary=Validates entries for [[Boarding Loc]] | |DIC_summary=Validates entries for [[Boarding Loc]] | ||
|DIC_related_concepts=Boarding Loc; | |DIC_related_concepts=Boarding Loc; service tmp entry; Dispo DtTm | ||
|DIC_firmness=hard check | |DIC_firmness=hard check | ||
|DIC_timing=complete | |DIC_timing=complete | ||
| Line 16: | Line 16: | ||
== Log == | == Log == | ||
2020-11-06 removed requirement "Date_var and Time_var must not be before | * 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-05-18 - restored the PatID field which had been accidentally removed. | |||
* 2022-03-31 - | |||
** removed "no borrow" references since we have not used those in a long time | |||
** removed some old distinction between Med and CC that is no longer relevant | |||
** updated to use first [[Service tmp entry]] instead of "Accept DtTm" | |||
* 2020-11-06 - removed requirement "Date_var and Time_var must not be before "Arrive DtTm" until we can work out [[#first boarding loc question]] | |||
== Related articles == | == Related articles == | ||