Query check tmp BedHeld: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) Created page with "{{Data Integrity Check |DIC_summary=Validates that the DtTm for the first Service tmp entry is the same as that for the first Boarding Loc entry |DIC_related_concepts=BedHeldEnd DtTm; Dispo DtTm |DIC_firmness=hard check |DIC_timing=complete |DIC_coding= query ''XXXXX'' |DIC_implementation_date= |DIC_status= |DIC_app=CCMDB.accdb }} Required checks as per Julie: # for AMA AWOL or procedure, bed held end dttm must always be after dispo dttm. # if bed held end dt..." |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (12 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{Data Integrity Check | {{Data Integrity Check | ||
|DIC_summary= | |DIC_summary=Sanity check for [[BedHeldEnd DtTm]] | ||
|DIC_related_concepts=BedHeldEnd DtTm; Dispo DtTm | |DIC_related_concepts=BedHeldEnd DtTm; Dispo DtTm | ||
|DIC_firmness=hard check | |DIC_firmness=hard check | ||
|DIC_timing=complete | |DIC_timing=complete | ||
|DIC_coding= query '' | |DIC_coding=query ''check_tmp_BedHeld'' | ||
|DIC_implementation_date= | |DIC_implementation_date=2023-05-02 | ||
|DIC_status= | |DIC_status=implemented | ||
|DIC_app=CCMDB.accdb | |DIC_app=CCMDB.accdb | ||
|DIC_backlogged=No | |||
}} | }} | ||
* dttm entry is always required | |||
* for item in ("'''AMA (AWOL)'''", "'''Procedure'''"), [[BedHeldEnd DtTm]] must always be after [[Dispo DtTm]] | |||
* if [[BedHeldEnd DtTm]] = [[Dispo DtTm]] and [[Dispo]] = '''"AMA (left against medical advice)"''', should be "'''AMA protocol'''" and vice versa | |||
* for item in ("'''AMA (AWOL)'''", "'''AMA (Protocol)'''"), [[Dispo]] needs to be "AMA" and vice versa | |||
== Log == | == Log == | ||
* 2023-01-10 Julie identified needed checks | * 2023-07-06 - the query is being called out of tmp checker, so it must be running now, considering question dealt with | ||
* 2023-05-02 - query defined and written but waiting to find out if this can be before complete or only after (emailed) | |||
* 2023-01-11 - Discussed at JALT and decided to not have a cross check for "procedure" against "[[Dispo]]" | |||
* 2023-01-10 - Julie identified needed checks | |||
== Related articles == | == Related articles == | ||
Latest revision as of 12:55, 2024 April 24
| Data Integrity Checks | |
| Summary: | Sanity check for BedHeldEnd DtTm |
| Related: | BedHeldEnd DtTm, Dispo DtTm |
| Firmness: | hard check |
| Timing: | complete |
| App: | CCMDB.accdb |
| Coding: | query check_tmp_BedHeld |
| Uses L Problem table: | not relevant for this app |
| Status: | implemented |
| Implementation Date: | 2023-05-02 |
| Backlogged: | No |
- dttm entry is always required
- for item in ("AMA (AWOL)", "Procedure"), BedHeldEnd DtTm must always be after Dispo DtTm
- if BedHeldEnd DtTm = Dispo DtTm and Dispo = "AMA (left against medical advice)", should be "AMA protocol" and vice versa
- for item in ("AMA (AWOL)", "AMA (Protocol)"), Dispo needs to be "AMA" and vice versa
Log
- 2023-07-06 - the query is being called out of tmp checker, so it must be running now, considering question dealt with
- 2023-05-02 - query defined and written but waiting to find out if this can be before complete or only after (emailed)
- 2023-01-11 - Discussed at JALT and decided to not have a cross check for "procedure" against "Dispo"
- 2023-01-10 - Julie identified needed checks
Related articles
| Related articles: |