Query check tmp AHC: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) No edit summary |
||
| Line 19: | Line 19: | ||
*** nz(date, now()) + nz(time, .9999) must be after admission | *** nz(date, now()) + nz(time, .9999) must be after admission | ||
*** nz(date, date()) + nz(time, 0) must be before nz(dispo_dttm, now) | *** 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 | * at complete time | ||