Query check tmp AHC: Difference between revisions

(12 intermediate revisions by 2 users not shown)

Line 1:

{{Data Integrity Check

|DIC_summary=For patients with [[Previous Location]] ER at same site there should be a [[Boarding Loc]] ER.

|DIC_related_concepts=Project AHC; Site; SentDtTm; ~~Admit_DtTm~~; ~~Dispo_DtTm~~

|DIC_related_concepts=Project AHC; Site; SentDtTm; Admit DtTm; Dispo DtTm

|DIC_firmness=hard check

|DIC_timing=complete

|DIC_coding=query ''check_tmp_AHC''

~~|DIC_implementation_date=~~

|DIC_status=needs review

|DIC_status=

|DIC_app=CCMDB.accdb

|DIC_backlogged=

|DIC_backlogged=No

}}

Cross-checks for [[Project AHC]].

== Consistency Checks ==

* ~~dttms~~ within admission

for each matching allied health discipline

* ~~dttms~~ must be ~~chronological for groupings linked by int_var~~

* at all times

* if there is an ~~option~~ entry ~~the~~ consult ~~can not~~ be "~~never addressed~~"

** must have an entry for each allied health discipline

** if there is a date, it must be within the admission

*** nz(date, now()) + nz(time, .9999) must be after admission

*** nz(date, date()) + nz(time, 0) must be before nz(dispo_dttm, now)

** '''not yet done''' - if item "not consulted" there must not be a date or time, and there must not be an AH_C_<the allied health team> entry for consult received

* at complete time

** if there is a time there has to be a date

** if item in ("referral received", "Late consult received") then it must have the checkbox checked ("no dttm") or a date

{{DL|

** item must not be "not entered"

* I implemented this one and 40 records in my test data have a "not entered" in complete data. Did I misunderstand the instructions?

}}

{{DL|

* if there is referral sent there must be a referral received entry and a consult dealt with entry[[User:Lkaita|Lisa Kaita]] 11:31, 7 August 2025 (CDT)

** pt could die in between? consult could go missing? In a way those would be really the ones we would want to know about, no? I suppose we could make it a soft check... [[User:Ttenbergen|Ttenbergen]] 16:26, 19 August 2025 (CDT)

** this almost sounds like the opposite of how I would have understood the current instructions. I would have thought those to mean to only enter "consult received" if there was no good data for consult sent. How do we actually want to use this?

}}

== Log ==

@@ Line 1: / Line 1: @@
+{{DISPLAYTITLE:Query check_tmp_AHC}}
 {{Data Integrity Check
 |DIC_summary=For patients with [[Previous Location]] ER at same site there should be a [[Boarding Loc]] ER.
-|DIC_related_concepts=Project AHC; Site; SentDtTm; Admit_DtTm; Dispo_DtTm
+|DIC_related_concepts=Project AHC; Site; SentDtTm; Admit DtTm; Dispo DtTm
 |DIC_firmness=hard check
+|DIC_timing=complete
 |DIC_coding=query ''check_tmp_AHC''
-|DIC_implementation_date=
+|DIC_status=needs review
-|DIC_status=
 |DIC_app=CCMDB.accdb
-|DIC_backlogged=
+|DIC_backlogged=No
 }}
 Cross-checks for [[Project AHC]].
 == Consistency Checks ==
-* dttms within admission
+for each matching allied health discipline
-* dttms must be chronological for groupings linked by int_var
+* at all times
-* if there is an option entry the consult can not be "never addressed"
+** must have an entry for each allied health discipline
-{{DL| others? }}
+** if there is a date, it must be within the admission
-{{DJ| others? }}
+*** nz(date, now()) + nz(time, .9999) must be after admission
+*** nz(date, date()) + nz(time, 0) must be before nz(dispo_dttm, now)
+** '''not yet done''' - if item "not consulted" there must not be a date or time, and there must not be an AH_C_<the allied health team> entry for consult received
+* at complete time
+** if there is a time there has to be a date
+** if item in ("referral received", "Late consult received") then it must have the checkbox checked ("no dttm") or a date
+{{DL|
+** item must not be "not entered"
+* I implemented this one and 40 records in my test data have a "not entered" in complete data. Did I misunderstand the instructions?
+}}
+{{DL|
+* if there is referral sent there must be a referral received entry and a consult dealt with entry[[User:Lkaita|Lisa Kaita]] 11:31, 7 August 2025 (CDT)
+** pt could die in between? consult could go missing? In a way those would be really the ones we would want to know about, no? I suppose we could make it a soft check... [[User:Ttenbergen|Ttenbergen]] 16:26, 19 August 2025 (CDT)
+** this almost sounds like the opposite of how I would have understood the current instructions. I would have thought those to mean to only enter "consult received" if there was no good data for consult sent. How do we actually want to use this?
+}}
 == Log ==