Clinical Assessment Unit: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 27: | Line 27: | ||
Discussed at Task; these are now family medicine, we will start to just collect these as <local> ward. [[User:Ttenbergen|Ttenbergen]] 13:50, 2021 March 24 (CDT) | Discussed at Task; these are now family medicine, we will start to just collect these as <local> ward. [[User:Ttenbergen|Ttenbergen]] 13:50, 2021 March 24 (CDT) | ||
}} | }} | ||
As of 2021-04-22, there are 5 incomplete records at the GRA that still use GRA_CAU. | |||
{{Collapsable | {{Collapsable | ||
| always= See sql to see boarding loc CAUs in CFE | | always= See sql to see dispo or boarding loc CAUs in CFE | ||
| full= | | full= | ||
SELECT L_Log.D_ID, s_dispo.location_name AS pre_admit, s_dispo_1.location_name AS previous, s_dispo_2.location_name AS SL, s_dispo_3.location_name AS dispo, tmp_CAU.Item, L_Log.Accept_DtTm, L_Log.Arrive_DtTm, L_Log.Dispo_DtTm, L_Log.RecordStatus | |||
FROM ((((L_Log LEFT JOIN s_dispo ON L_Log.Pre_admit_Inpatient_Institution = s_dispo.dispo_ID) LEFT JOIN s_dispo AS s_dispo_1 ON L_Log.Previous_Location = s_dispo_1.dispo_ID) LEFT JOIN s_dispo AS s_dispo_2 ON L_Log.Service_Location = s_dispo_2.dispo_ID) LEFT JOIN s_dispo AS s_dispo_3 ON L_Log.Dispo = s_dispo_3.dispo_ID) LEFT JOIN (SELECT L_TmpV2.* FROM L_TmpV2 WHERE (((L_TmpV2.Item) Like "*CAU"))) AS tmp_CAU ON L_Log.D_ID = tmp_CAU.D_ID | |||
WHERE (((s_dispo.location_name) Like "*CAU")) OR (((s_dispo_1.location_name) Like "*CAU")) OR (((s_dispo_2.location_name) Like "*CAU")) OR (((s_dispo_3.location_name) Like "*CAU")); | |||
FROM ((L_Log | |||
WHERE (((s_dispo.location_name) Like "*CAU")) OR (((s_dispo_1.location_name) Like "*CAU")) OR (((s_dispo_2.location_name) Like "*CAU")); | |||
}} | }} | ||