Query check tmp AHC: Difference between revisions

(One intermediate revision by the same user not shown)

Line 19:

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

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

** if item "not consulted" there must not be a date or time, and there must not be an AH_C_<the allied health team>

** '''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"

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

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

}}

* dttms within admission

** if date is present and time is blank then the date must be within admission or on admit or on discharge date.

* complete

{{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)

@@ Line 19: / Line 19: @@
 *** nz(date, now()) + nz(time, .9999) must be after admission
 *** nz(date, date()) + nz(time, 0) must be before nz(dispo_dttm, now)
-** if item "not consulted" there must not be a date or time, and there must not be an AH_C_<the allied health team>
+** '''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"
-** if item in ("referral received", "Late consult received") then it must have the checkbox checked ("no dttm") or a date
+* I implemented this one and 40 records in my test data have a "not entered" in complete data. Did I misunderstand the instructions?
+}}
-* dttms within admission
-** if date is present and time is blank then the date must be within admission or on admit or on discharge date.
-* complete
 {{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)