Query s tmp Boarding Loc no borrow but entry

From CCMDB Wiki
Revision as of 16:08, 2020 June 3 by Ttenbergen (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
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:
  • 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 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: