Query check tmp BedHeld: Difference between revisions

No edit summary
No edit summary
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
* 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
* 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)