Query check tmp BedHeld: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m Text replacement - "cross check " to "cross check " |
||
| (5 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 ''check_tmp_BedHeld'' | |DIC_coding=query ''check_tmp_BedHeld'' | ||
|DIC_status= | |DIC_implementation_date=2023-05-02 | ||
|DIC_status=implemented | |||
|DIC_app=CCMDB.accdb | |DIC_app=CCMDB.accdb | ||
|DIC_backlogged=No | |DIC_backlogged=No | ||
}} | }} | ||
* dttm entry is always required | * dttm entry is always required | ||
* for item in ("'''AMA (AWOL)'''", "'''Procedure'''"), [[BedHeldEnd DtTm]] must always be after [[Dispo DtTm]] | * 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 | * 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 | * for item in ("'''AMA (AWOL)'''", "'''AMA (Protocol)'''"), [[Dispo]] needs to be "AMA" and vice versa | ||
* if record has [[Dispo]]="AMA (left against medical advice)" there must be a [[BedHeldEnd DtTm]] entry | |||
== Log == | == Log == | ||
* 2025-01-08 - updated [[query check_tmp_BedHeld]] to also flag if record has [[Dispo]]="AMA (left against medical advice)" but no [[BedHeldEnd DtTm]] entry | |||
* 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-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-11 - Discussed at JALT and decided to not have a [[cross check]] for "procedure" against "[[Dispo]]" | ||
* 2023-01-10 - Julie identified needed checks | * 2023-01-10 - Julie identified needed checks | ||