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 →Log |
||
| (14 intermediate revisions by 2 users not shown) | |||
| 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 | ||
|DIC_coding= query | |DIC_coding= query s_tmp_Boarding_Loc_date_item | ||
|DIC_implementation_date=2020/06/03 | |DIC_implementation_date=2020/06/03 | ||
|DIC_status=implemented | |DIC_status=implemented | ||
| Line 11: | Line 11: | ||
|DIC_backlogged=No | |DIC_backlogged=No | ||
}} | }} | ||
* Date_var and Time_var must not be on or after Dispo 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 | * 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. | * When having a boarding location, both date and time must be present. Should not have missing time. | ||
== Log == | |||
* 2022-05-25 - changed the query to a complete only query so the items can initially be entered as per Cognos, and only changed to our corrected values on chart completion, to allow keeping the [[Boarding Loc]] records linked to their counterpart [[Cognos2 Units table]] records | |||
* 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 == | ||
Revision as of 11:15, 25 May 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-05-25 - changed the query to a complete only query so the items can initially be entered as per Cognos, and only changed to our corrected values on chart completion, to allow keeping the Boarding Loc records linked to their counterpart Cognos2 Units table records
- 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: |