Query check tmp BedHeld: Difference between revisions

Latest revision as of 13: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

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

@@ Line 1: / Line 1: @@
 {{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_summary=Sanity check for [[BedHeldEnd DtTm]]
 |DIC_related_concepts=BedHeldEnd DtTm; Dispo DtTm
 |DIC_firmness=hard check