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.mdb
Coding:	not entered
Uses L Problem table:	not relevant for this app
Status:	ready to implement
Implementation Date:	not entered
Backlogged:	true

• Cargo

• SMW

"CCMDB.mdb" is not in the list (SAP, not entered, Centralized data front end.accdb, DSM Labs Consistency check.accdb, CCMDB.accdb, TISS28.accdb) of allowed values for the "DICApp" property. 

• Categories:  

• form:

query s_tmp_Borrow_duplicates

query s_tmp_Borrow_sensible_DtTm_vs_no_borrow

Sensible DtTm vs no borrow

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