Query s tmp Borrow sensible DtTm vs no borrow: Difference between revisions

Latest revision as of 15:46, 2022 April 19

Data Integrity Checks
Summary:	Checks that data for Project Borrow arrive follows that project's
Related:	Project Borrow arrive
Firmness:	hard check
Timing:	complete
App:	CCMDB.accdb
Coding:	query s_tmp_Borrow_sensible_DtTm_vs_no_borrow
Uses L Problem table:	not relevant for this app
Status:	retired
Implementation Date:	2019/01/24
Backlogged:	true

Retired 2019-09-24 as part of moving to Boarding Loc.

If

or

then give a hard error. This can't be.

all in header...

@@ Line 6: / Line 6: @@
 |DIC_coding=query ''s_tmp_Borrow_sensible_DtTm_vs_no_borrow''
 |DIC_implementation_date=2019/01/24
-|DIC_status=implemented
+|DIC_status=retired
 |DIC_LProblem=No
 |DIC_app=CCMDB.accdb
 }}
+Retired 2019-09-24 as part of moving to [[Boarding Loc]].
 === (start_dt, start_tm) outside of admission time ===
 If
-* (start_dt, start_tm) < [[Arrive_DtTm]]
+* (start_dt, start_tm) < Arrive_DtTm
 or
 * [[Dispo_DtTm]] <'''=''' (start_dt, start_tm)
@@ Line 19: / Line 22: @@
 === has to either have location and time or "no borrow" checked ===
 all in header...
-{{Discuss|
-* This cross check does not seem to require a check box to send completed chart ** confirmed, check is disabled in VBA with comment "2019-01-24 disabled for now because too many errors". I think we were concerned at the time because of high workload and fresh ICD10/CCI and didn't want to analyze and fix then. We will need to review what this should be to get an acceptable number of errors only.}}
 === can't have "no borrow" in item but have (start_dt, start_tm) ===
 == Related articles ==
 {{Related Articles}}
 [[Category:Tmp check‎‎‎]]