Service Sending to ICU: Difference between revisions

Line 39: Line 39:
* If that record has "enter" or "" as item, you can't checkbox tmp
* If that record has "enter" or "" as item, you can't checkbox tmp


=== currently impossible ===
* Query ''s_tmp_Service_Sending_to_ICU_duplicate'' - error if more than one entry per patient Ttenbergen 15:35, 2015 June 22 (CDT)
* Query ''s_tmp_Service_Sending_to_ICU_duplicate'' - error if more than one entry per patient Ttenbergen 15:35, 2015 June 22 (CDT)
* Query ''s_tmp_Service_Sending_to_ICU'' - Error if:
** not admitted from inpatient location (([[S AdmitDischarge table|S AdmitDischarge]].inpatient = true)) but has "Srv to ICU" entry
** admitted from inpatient location and one of
*** no "Srv to ICU" entry
*** has "Srv to ICU" = "z_not applicable" and no comment
Right now our consistency check would not allow someone from other hosp via ER. We won't be able to do this check until we have [[Pre-admit Inpatient Institution field]]. I will take that check out for now. Ttenbergen 11:50, 2015 June 24 (CDT) {{discussion}}


== SAS Program ==
== SAS Program ==