Query check previous location vs service inconsistent: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) No edit summary |
||
| Line 19: | Line 19: | ||
:: FROM (L_Log INNER JOIN s_dispo AS s_dispo_previous ON L_Log.Previous_Location = s_dispo_previous.dispo_ID) INNER JOIN s_previous_service ON L_Log.Previous_Service = s_previous_service.previous_service_ID | :: FROM (L_Log INNER JOIN s_dispo AS s_dispo_previous ON L_Log.Previous_Location = s_dispo_previous.dispo_ID) INNER JOIN s_previous_service ON L_Log.Previous_Service = s_previous_service.previous_service_ID | ||
:: WHERE | :: WHERE | ||
::: (((s_dispo_previous.Hospital)<>"HSC") AND ((s_previous_service.previous_service)<>"Medicine" And (s_previous_service.previous_service)<>"Family Medicine") AND ((s_dispo_previous.loc_type)="Ward") AND ((s_dispo_previous.s_location)=True)) | ::: (((s_dispo_previous.Hospital)<>"HSC") AND ((s_previous_service.previous_service)<>"Medicine" And (s_previous_service.previous_service)<>"Family Medicine") AND ((s_dispo_previous.loc_type)="Ward") AND ((s_dispo_previous.s_location)=True)) | ||
::: OR (((s_dispo_previous.Ward)<>" | ::: OR (((s_dispo_previous.Ward)<>"CICU" And (s_dispo_previous.Ward)<>"ACCU" And (s_dispo_previous.Ward)<>"ICCS") AND ((s_previous_service.previous_service)<>"Critical Care") AND ((s_dispo_previous.loc_type)="ICU") AND ((s_dispo_previous.s_location)=True)) | ||
::: OR (((s_dispo_previous.Hospital)="HSC") AND ((s_previous_service.previous_service)<>"Medicine" And (s_previous_service.previous_service)<>"Nephrology") AND ((s_dispo_previous.loc_type)="Ward") AND ((s_dispo_previous.s_location)=True)) | ::: OR (((s_dispo_previous.Hospital)="HSC") AND ((s_previous_service.previous_service)<>"Medicine" And (s_previous_service.previous_service)<>"Nephrology") AND ((s_dispo_previous.loc_type)="Ward") AND ((s_dispo_previous.s_location)=True)) | ||
::: OR (( | ::: OR (((s_dispo_previous.Ward)="ACCU") AND ((s_previous_service.previous_service)<>"Critical Care" And (s_previous_service.previous_service)<>"Cardiology") AND ((s_dispo_previous.loc_type)="ICU") AND ((s_dispo_previous.s_location)=True)) | ||
::: OR (((s_dispo_previous.Ward)="ICCS") AND ((s_previous_service.previous_service)<>"Cardiac surgery") AND ((s_dispo_previous.loc_type)="ICU") AND ((s_dispo_previous.s_location)=True)); | ::: OR (((s_dispo_previous.Ward)="ICCS") AND ((s_previous_service.previous_service)<>"Cardiac surgery") AND ((s_dispo_previous.loc_type)="ICU") AND ((s_dispo_previous.s_location)=True)) | ||
::: OR (((s_dispo_previous.Ward)="CICU") AND ((s_previous_service.previous_service)<>"Cardiac Sciences") AND ((s_dispo_previous.loc_type)="ICU") AND ((s_dispo_previous.s_location)=True)); | |||
== Log == | |||
2021-01-05 - expect CICU to use newly added option "Cardiac Sciences" | |||
== Related articles == | == Related articles == | ||