Query s tmp Boarding Loc no borrow but entry: Difference between revisions

Latest revision as of 12:17, 2021 October 5

Data Integrity Checks
Summary:	Validates entries for Boarding Loc
Related:	Boarding Loc, Service/Location
Firmness:	hard check
Timing:	complete
App:	CCMDB.accdb
Coding:	query s_tmp_Boarding_Loc_no_borrow_but_entry
Uses L Problem table:	not relevant for this app
Status:	retired
Implementation Date:	2020/06/03
Backlogged:	No

"no borrow" entry is no longer used; used to be: "Item should be either "no borrow" or with boarding item but must not have both"

2021-10-05 - retired query since "no borrow" is no longer used.

@@ 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/Location;
 |DIC_firmness=hard check
 |DIC_timing=complete
 |DIC_coding= query s_tmp_Boarding_Loc_no_borrow_but_entry
 |DIC_implementation_date=2020/06/03
-|DIC_status=implemented
+|DIC_status=retired
 |DIC_LProblem=
 |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
+* "no borrow" entry is no longer used; used to be: "Item should be either "no borrow" or with boarding item but must not have both"
-* 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 ==
+-10-05 - retired query since "no borrow" is no longer used.
 == Related articles ==