Clinical Assessment Unit: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Line 45: Line 45:


== pre-admit inpt... ==
== pre-admit inpt... ==
A quick review of the data shows that collectors are using CAUs even now. Possibly more concerningly, when CAU is the [[Previous location]] , about 5% coded the pre-admit location as NA/Not applicable, the rest coded it as same CAU, except for a few who are mixing CAU and ER in these.  
A quick review of the data shows that collectors are using CAUs even now. Possibly more concerningly, when CAU is the [[Previous Location]] , about 5% coded the pre-admit location as NA/Not applicable, the rest coded it as same CAU, except for a few who are mixing CAU and ER in these.  


{{Discuss | who = Julie |
{{Discuss | who = Julie |

Revision as of 15:54, 2021 March 11

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)

Do we actually need to differentiate these from wards?

Email between Julie and Tina Jan 2021; Julie does not recall any requests for info about CAUs as distinct from wards. So, we could retire the CAU entries in s_dispo table and ask collectors to start using <site>_ward.

  • as per Julie: "I have checked the database and there are also CAU entries at GRA and STB in pre-admit institution, previous loc and dispo (GRA_CAU, STB_CAU). Do they move location too? Can we ask the DC? If so, make it generic _ward.
  • In the tmp Boarding Loc, there are 12 cases GH-CAU – so it looks like Internal med is borrowing CAU Bed. What to do here – change to GRA boarding?
    • I am not sure if the more recent entries for boarding loc would now list the actual location or still site-CAU.
  • SMW


  • Cargo


  • Categories
See sql to see boarding loc CAUs in CFE   

SELECT L_TmpV2.*, L_TmpV2.Item FROM L_TmpV2 WHERE (((L_TmpV2.Item) Like "*CAU"));

See sql to see pre-admit, previous and dispo CAUs in CFE   

SELECT L_Log.D_ID, s_dispo_1.location_name AS pre_admit, s_dispo.location_name AS previous, s_dispo_2.location_name AS dispo, L_Log.Accept_DtTm, L_Log.Arrive_DtTm, L_Log.Dispo_DtTm FROM ((L_Log INNER JOIN s_dispo ON L_Log.Previous_Location = s_dispo.dispo_ID) INNER JOIN s_dispo AS s_dispo_2 ON L_Log.Dispo = s_dispo_2.dispo_ID) INNER JOIN s_dispo AS s_dispo_1 ON L_Log.Pre_admit_Inpatient_Institution = s_dispo_1.dispo_ID WHERE (((s_dispo.location_name) Like "*CAU")) OR (((s_dispo_1.location_name) Like "*CAU")) OR (((s_dispo_2.location_name) Like "*CAU"));

If we wanted to stop these we would need to

  • tell collectors to change all pre-admit, previous, dispo, and boarding loc to site-ward
  • wait till that's done
  • retire the entries in s_dispo, s_tmp and on wiki
  • possibly reconcile the old entries to site-ward as well
  • do we want to do this?
  • SMW


  • Cargo


  • Categories

pre-admit inpt...

A quick review of the data shows that collectors are using CAUs even now. Possibly more concerningly, when CAU is the Previous Location , about 5% coded the pre-admit location as NA/Not applicable, the rest coded it as same CAU, except for a few who are mixing CAU and ER in these.

  • do we need to do anything to get collectors to fill this out right? Or to deal with back-data? Ttenbergen 14:40, 2021 March 11 (CST)
  • SMW


  • Cargo


  • Categories

Related articles

Related articles: