Query s tmp Boarding Loc date item: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m (Ttenbergen moved page Check Borrow Loc date item to Query s tmp Borrow Loc date item without leaving a redirect: consistent naming of tmp queries) |
(No difference)
|
Revision as of 16:01, 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 Check_Borrow_Loc_date_item |
Uses L Problem table: | not relevant for this app |
Status: | implemented |
Implementation Date: | 2020/06/03 |
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 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: |