Query check tmp BedHeld

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
if record has Dispo="AMA (left against medical advice)" there must be a BedHeldEnd DtTm entry

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-01-11 - Discussed at JALT and decided to not have a cross check for "procedure" against "Dispo"
2023-01-10 - Julie identified needed checks