Query s tmp Boarding Loc date item

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

 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.