Query check tmp AHC: Difference between revisions

(4 intermediate revisions by the same user not shown)

Line 13:

== Consistency Checks ==

* must have an entry ~~to send~~

for each matching allied health discipline

* ~~dttms~~ within admission

* at all times

** 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?

}}

~~{{DJ| others? }}~~

== Log ==

@@ Line 13: / Line 13: @@
 == Consistency Checks ==
-* must have an entry to send
+for each matching allied health discipline
-* dttms within admission
+* at all times
+** 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?
 }}
-{{DJ| others? }}
 == Log ==