Query s tmp Boarding Loc date item

From CCMDB Wiki
Revision as of 15:56, 2020 June 3 by Ttenbergen (talk | contribs) (Created page with "{{Data Integrity Check |DIC_summary=Validates entries for Borrow Loc |DIC_related_concepts=Boarding Loc, Service/Location, Arrive DtTm, Dispo DtTm |DIC_fir...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
Data Integrity Checks
Summary: Validates entries for Borrow Loc
Related: [[Boarding Loc, Service/Location, Arrive DtTm, Dispo DtTm]]
Firmness: hard check
Timing: complete
App: CCMDB.accdb
Coding: not entered
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: not entered
Backlogged: true
  • Cargo


  • SMW
 Property "DICRelatedConcepts" (as page type) with input value "Boarding Loc]], Service/Location, Arrive DtTm, [[Dispo DtTm" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process.
  • 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: