Query s tmp Boarding Loc date item: Difference between revisions

(19 intermediate revisions by 2 users not shown)

Line 1:

{{Data Integrity Check

|DIC_summary=Validates entries for [[~~Borrow~~ Loc]]

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

|DIC_implementation_date=2020-06-03

|DIC_status=implemented

|DIC_LProblem=No

|DIC_app=CCMDB.accdb

|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 [[Borrow Loc]]
+|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_Boarding_Loc_date_item
+|DIC_implementation_date=2020-06-03
 |DIC_status=implemented
+|DIC_LProblem=No
 |DIC_app=CCMDB.accdb
+|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 ==