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) mNo edit summary |
||
| Line 4: | Line 4: | ||
|DIC_firmness=hard check | |DIC_firmness=hard check | ||
|DIC_timing=complete | |DIC_timing=complete | ||
|DIC_coding= | |DIC_coding= query Check_Borrow_Loc_date_item | ||
|DIC_implementation_date=2020/06/03 | |DIC_implementation_date=2020/06/03 | ||
|DIC_status=implemented | |DIC_status=implemented | ||
Revision as of 15:59, 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: |