ER Wait: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 38: | Line 38: | ||
=== ER Wait and from-ER consistency === | === ER Wait and from-ER consistency === | ||
* uses the following queries | * uses the following queries | ||
** s_tmp_ER_Wait_has_tmp_not_from_ER | ** s_tmp_ER_Wait_has_tmp_not_from_ER - error if ER wait entry but is not from ER | ||
** s_tmp_ER_Wait_from_ER_no_ER_Wait | ** s_tmp_ER_Wait_from_ER_no_ER_Wait - error if from ER but has no ER wait entry | ||
** s_tmp_ER_Wait_chronological | ** s_tmp_ER_Wait_chronological - error if tmp date/time is null or is <= admit date/time | ||
** s_tmp_ER_Wait_long_delay - gives error if delay is > 3 days | ** s_tmp_ER_Wait_long_delay - gives error if delay is > 3 days | ||