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

• Cargo

• SMW

• Categories:  

• form:

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

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