Query s tmp Borrow sensible DtTm vs no borrow

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:	implemented
Implementation Date:	2019/01/24
Backlogged:	true

• Cargo

• SMW

• Categories: 

• form:

(start_dt, start_tm) outside of admission time

If

• (start_dt, start_tm) < Arrive_DtTm

or

• Dispo_DtTm <= (start_dt, start_tm)

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

has to either have location and time or "no borrow" checked

all in header...

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.

• SMW

• Cargo

• Categories