Query s tmp Boarding Loc no borrow but entry: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
(Created page with "{{Data Integrity Check |DIC_summary=Validates entries for Boarding Loc |DIC_related_concepts=Boarding Loc; Service/Location; Arrive DtTm; Dispo DtTm |DIC_firmness=hard che...")
 
mNo edit summary
Line 11: Line 11:
|DIC_backlogged=No
|DIC_backlogged=No
}}
}}
* Date_var and Time_var must not be before [[Arrive DtTm]]
 
* Date_var and Time_var must not be on or after Dispo DtTm
* Item should be either "no borrow" or with boarding item  but must not have both
* Item should not be the same as the [[Service/Location]] for Medicine profile
* When having a boarding location, both date and time must be present. Should not have missing time.


== Related articles ==  
== Related articles ==  

Revision as of 16:09, 2020 June 3

Data Integrity Checks
Summary: Validates entries for Boarding Loc
Related: Boarding Loc, Service/Location, Arrive DtTm, Dispo DtTm
Firmness: hard check
Timing: complete
App: CCMDB.accdb
Coding: query s_tmp_Boarding_Loc_no_borrow_but_entry
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2020/06/03
Backlogged: No
  • Cargo


  • SMW


  • Categories: 
  • form:
  • Item should be either "no borrow" or with boarding item but must not have both

Related articles

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