Query check tmp BedHeld: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m Text replacement - "cross check " to "cross check " |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 14: | Line 14: | ||
* 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-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 | ||