Query check tmp BedHeld: Difference between revisions

(14 intermediate revisions by the same user not shown)

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

|DIC_timing=complete

|DIC_coding= query ''~~XXXXX~~''

|DIC_coding=query ''check_tmp_BedHeld''

|DIC_implementation_date=

|DIC_implementation_date=2023-05-02

|DIC_status=

|DIC_status=implemented

|DIC_app=CCMDB.accdb

|DIC_backlogged=No

}}

* dttm entry is always required

~~Required checks as per Julie:~~

* for item in ("'''AMA (AWOL)'''", "'''Procedure'''"), [[BedHeldEnd DtTm]] must always be after [[Dispo DtTm]]

# for AMA AWOL ~~or procedure~~, ~~bed held end 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 ~~bed held end dttm~~ = ~~dispo dttm~~ and AMA, should be AMA protocol.

* for item in ("'''AMA (AWOL)'''", "'''AMA (Protocol)'''"), [[Dispo]] needs to be "AMA" and vice versa

~~# If~~ item= AMA ~~protocol~~ , ~~the dttm entry is still required.~~

* if record has [[Dispo]]="AMA (left against medical advice)" there must be a [[BedHeldEnd DtTm]] entry

~~Also:~~

* For the two AMA ~~entries~~, [[Dispo]] needs to be "AMA"

== Log ==

* 2023-01-11 Discussed at ~~Task~~ and decided to not have a cross check for "procedure" against "[[Dispo]]"

* 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-01-10 Julie identified needed checks

* 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

== Related articles ==

@@ 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
 |DIC_timing=complete
-|DIC_coding= query ''XXXXX''
+|DIC_coding=query ''check_tmp_BedHeld''
-|DIC_implementation_date=
+|DIC_implementation_date=2023-05-02
-|DIC_status=
+|DIC_status=implemented
 |DIC_app=CCMDB.accdb
+|DIC_backlogged=No
 }}
+* dttm entry is always required
-Required checks as per Julie:
+* for item in ("'''AMA (AWOL)'''", "'''Procedure'''"), [[BedHeldEnd DtTm]] must always be after [[Dispo DtTm]]
-# for AMA AWOL or procedure, bed held end 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 bed held end dttm = dispo dttm and AMA, should be AMA protocol.
+* for item in ("'''AMA (AWOL)'''",  "'''AMA (Protocol)'''"), [[Dispo]] needs to be "AMA" and vice versa
-# If item= AMA protocol , the dttm entry is still required.
+* if record has [[Dispo]]="AMA (left against medical advice)" there must be a [[BedHeldEnd DtTm]] entry
-Also:
-* For the two AMA entries, [[Dispo]] needs to be "AMA"
 == Log ==
-* 2023-01-11 Discussed at Task and decided to not have a cross check for "procedure" against "[[Dispo]]"
+* 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-01-10 Julie identified needed checks
+* 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
 == Related articles ==