Query s tmp Boarding Loc date item: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (removed links to accept and arrive dttm) |
Ttenbergen (talk | contribs) m (→Log) |
||
Line 16: | Line 16: | ||
== Log == | == Log == | ||
* 2022-05-18 restored the PatID field which had been accidentally removed. | |||
* 2022-03-31 | * 2022-03-31 | ||
** 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 |
Revision as of 09:47, 2022 May 18
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-05-18 restored the PatID field which had been accidentally removed.
- 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: |