Query s tmp Boarding Loc date item

From CCMDB Wiki
Revision as of 15:58, 2020 June 3 by Ttenbergen (talk | contribs)
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:
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: