Query check tmp AHC: Difference between revisions

(7 intermediate revisions by 2 users not shown)

Line 13:

== Consistency Checks ==

* must have an entry ~~to send~~

for each matching allied health discipline

* ~~dttms~~ within admission

* at all times

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

** must have an entry for each allied health discipline

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

** 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 13: / Line 13: @@
 == Consistency Checks ==
-* must have an entry to send
+for each matching allied health discipline
-* dttms within admission
+* at all times
-* dttms must be chronological for groupings linked by int_var
+** must have an entry for each allied health discipline
-* if there is an option entry the consult can not be "never addressed"
+** if there is a date, it must be within the admission
-{{DL| others? }}
+*** nz(date, now()) + nz(time, .9999) must be after admission
-{{DJ| others? }}
+*** 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 ==