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

From CCMDB Wiki
Jump to navigation Jump to search
m (→‎has to either have location and time or "no borrow" checked: project is done, so question about cross check no longer relevant)
Line 22: Line 22:
=== has to either have location and time or "no borrow" checked ===
=== has to either have location and time or "no borrow" checked ===
all in header...
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) ===
=== can't have "no borrow" in item but have (start_dt, start_tm) ===

Revision as of 18:44, 2020 May 5

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

or

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

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

all in header...

can't have "no borrow" in item but have (start_dt, start_tm)

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_s_tmp_Borrow_sensible_DtTm_vs_no_borrow&oldid=143993"