Query s tmp Boarding Loc date item: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m →Log |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 1: | Line 1: | ||
{{Data Integrity Check | {{Data Integrity Check | ||
|DIC_summary=Validates entries for [[Boarding Loc]] | |DIC_summary=Validates entries for [[Boarding Loc]] | ||
|DIC_related_concepts=Boarding Loc; | |DIC_related_concepts=Boarding Loc; service tmp entry; Dispo DtTm | ||
|DIC_firmness=hard check | |DIC_firmness=hard check | ||
|DIC_timing=complete | |DIC_timing=complete | ||
| Line 19: | Line 19: | ||
** removed "no borrow" references since we have not used those in a long time | ** removed "no borrow" references since we have not used those in a long time | ||
** removed some old distinction between Med and CC that is no longer relevant | ** removed some old distinction between Med and CC that is no longer relevant | ||
** updated to use first [[Service tmp entry]] instead of [[Accept DtTm]] | |||
* 2020-11-06 removed requirement "Date_var and Time_var must not be before [[Arrive DtTm]]" until we can work out [[#first boarding loc question]] | * 2020-11-06 removed requirement "Date_var and Time_var must not be before [[Arrive DtTm]]" until we can work out [[#first boarding loc question]] | ||
Revision as of 13:02, 31 March 2022
| Data Integrity Checks | |
| Summary: | Validates entries for Boarding Loc |
| Related: | Boarding Loc, service tmp entry, Dispo DtTm |
| Firmness: | hard check |
| Timing: | complete |
| App: | CCMDB.accdb |
| Coding: | query s_tmp_Boarding_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 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.
Log
- 2022-03-31
- removed "no borrow" references since we have not used those in a long time
- removed some old distinction between Med and CC that is no longer relevant
- updated to use first Service tmp entry instead of Accept DtTm
- 2020-11-06 removed requirement "Date_var and Time_var must not be before Arrive DtTm" until we can work out #first boarding loc question
Related articles
| Related articles: |