Query check tmp AHC: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 13: | Line 13: | ||
== Consistency Checks == | == Consistency Checks == | ||
* must have an entry to | for each matching allied health discipline | ||
* 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) | |||
** if item "not consulted" there must not be a date or time, and there must not be an AH_C_<the allied health team> | |||
* at complete time | |||
** if there is a time there has to be a date | |||
** 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 | |||
* dttms within admission | * 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. | ** if date is present and time is blank then the date must be within admission or on admit or on discharge date. | ||
* complete | |||
{{DL| | {{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) | * 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) | ||