Clinical Assessment Unit

Clinical Assessment Units are wards to which emergency department decants patients who are are waiting on acquisition of resources (diagnostics and consults) for 24 hrs or more before they are safely returned to community. At some time these were considered part of the ER, but as of 2020-10 they are all Family Medicine. Special collection instructions applied at some point, but now they are simply one of the many units we don't collect on.

Site Specific information

How these are collected differs at the different sites. See for more info:

WRHA ER models of care plan article

WRHA Models of ER Care article (2017-10-02)

Retirement of s_dispo entries

We used to collect the CAUs as separate locations from local wards because they used to be managed by the ER, and so could have contained EMIPs. As of 2021 they are all managed by Family Medicine, and so for our considerations are just another hospital ward where we don't collect, coded as e.g. HSC_Ward.

All *CAU entries for incomplete pts were changed to *ward entries, and the *CAU entries in S dispo table were retired.

On discussion with Julie it was decided to keep the s_dispo entries around and not convert them. The loc type is Ward in s_dispo which is enough when reporting - usually being combined as <site> ward.

Inconsistencies between previous and pre-admit

We have some remaining data where CAU is the Previous Location but not the Pre-admit Inpatient Institution. Julie said: <quote><site> CAU has S dispo.loc type WARD in s_dispo table which implies included when reporting <site> ward. your question on inconsistencies - we can correct but not priority. Still fine as is when reporting. </quote>

	Please update the 10 Pre-admit inpt location for the records in the query below to be the same as the CAU in the previous location. After that is done, please clear out this section. Ttenbergen 12:04, 2022 February 11 (CST)	added: 2022-02-11 action: no action date

Query to find profiles with Previous Loc and Pre-admit Inpt Location not CAU
SELECT L_Log.D_ID, s_dispo.location_name AS pre_admit, s_dispo_1.location_name AS previous 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) INNER JOIN s_previous_service ON L_Log.Previous_Service = s_previous_service.previous_service_ID WHERE (((s_dispo.location_name) Not Like "CAU") AND ((s_dispo_1.location_name) Like "CAU"));

Inconsistencies between Previous Location and Previous Service

Julie requested that, when a pt has a CAU as Previous Location or Pre-admit Inpatient Institution, profiles that have "Medicine" as Previous Service should have this changed to "Family Medicine".

	was part of another discussion, broke it out here. <site> CAU has S dispo.loc type WARD in s_dispo table which implies included when reporting <site> ward. your question on inconsistencies - we can correct but not priority. Still fine as is when reporting. However the Previous service entries which is Medicine have to be changed to Family Medicine. if you have made it inactive 2021 then no more onwards, correct? --JMojica 17:13, 2022 January 26 (CST) If I understand this right, then the records that have a CAU as Previous Location or Pre-admit Inpatient Institution, and have Previous Service equal to "Medicine", should have that previous service changed to "Family Medicine". I made a query to find these, and realized that there are "previous service" other than FM and Med - are those a concern? See below. Do we want to change thes other non-family-medicine values to Family Medicine as well? Ttenbergen 11:43, 2022 February 11 (CST) Flagging this for GRA - could you confirm that changing these actually makes sense? No sense making things consistent if it makes them wrong. Ttenbergen 11:59, 2022 February 11 (CST) I don't remember exactly when but we haven't been using CAU as a location for quite some time, and for those coming to medicine from CAU we've been using Family Medicine as their Previous Service. That's not to say human error can't occur, but I can speak for both Mindy and myself and say that anyone coming to medicine from CAU is entered as Family Medicine for Previous Service, and "GH-Ward" for previous location. If there's any errors let us know and we'll correct them, otherwise I'm fairly certain that this is how we've been doing CAU entries for some time now. Surbanski 13:54, 2022 February 11 (CST)

Query to find profiles with Previous Loc CAU and Previous Service not Family Medicine
SELECT L_Log.D_ID, s_dispo.location_name AS pre_admit, s_dispo_1.location_name AS previous, s_previous_service.previous_service 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) INNER JOIN s_previous_service ON L_Log.Previous_Service = s_previous_service.previous_service_ID WHERE (((s_dispo.location_name) Like "CAU") AND ((s_previous_service.previous_service)<>"Family Medicine")) OR (((s_dispo_1.location_name) Like "CAU") AND ((s_previous_service.previous_service)<>"Family Medicine")) ORDER BY s_previous_service.previous_service;