Query s tmp Borrow sensible DtTm vs no borrow: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
|||
Line 19: | Line 19: | ||
=== 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 }} | {{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 17:07, 2019 July 3
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: | 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 |
(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...
can't have "no borrow" in item but have (start_dt, start_tm)
Related articles
Related articles: |