Query s tmp Boarding Loc date item: Difference between revisions

(12 intermediate revisions by 2 users not shown)

Line 1:

{{Data Integrity Check

|DIC_summary=Validates entries for [[Boarding Loc]]

|DIC_related_concepts=Boarding Loc; ~~Service/Location; Arrive DtTm~~; Dispo DtTm

|DIC_related_concepts=Boarding Loc; service tmp entry; Dispo DtTm

|DIC_firmness=hard check

|DIC_timing=complete

|DIC_coding= query ~~s_tmp_Borrow_Loc_date_item~~

|DIC_coding= query s_tmp_Boarding_Loc_date_item

|DIC_implementation_date=2020/06/03

|DIC_status=implemented

Line 11:

|DIC_backlogged=No

}}

* Date_var and Time_var must not be before [[Arrive DtTm]]

* Date_var and Time_var must not be on or after Dispo DtTm

* Item should not be the same as the [[Service/Location]] for Medicine profile

* When having a boarding location, both date and time must be present. Should not have missing time.

== Log ==

* 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 ==

@@ Line 1: / Line 1: @@
 {{Data Integrity Check
 |DIC_summary=Validates entries for [[Boarding Loc]]
-|DIC_related_concepts=Boarding Loc; Service/Location; Arrive DtTm; Dispo DtTm
+|DIC_related_concepts=Boarding Loc; service tmp entry; Dispo DtTm
 |DIC_firmness=hard check
 |DIC_timing=complete
-|DIC_coding= query s_tmp_Borrow_Loc_date_item
+|DIC_coding= query s_tmp_Boarding_Loc_date_item
 |DIC_implementation_date=2020/06/03
 |DIC_status=implemented
@@ Line 11: / Line 11: @@
 |DIC_backlogged=No
 }}
-* Date_var and Time_var must not be before [[Arrive DtTm]]
 * Date_var and Time_var must not be on or after Dispo DtTm
 * Item should not be the same as the [[Service/Location]] for Medicine profile
 * When having a boarding location, both date and time must be present. Should not have missing time.
+== Log ==
+* 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 ==