Clinical Assessment Unit: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
PTorres (talk | contribs)
PTorres (talk | contribs)
Line 27: Line 27:
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".  
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".  


{{Todo
{{  
| who = Pagasa 
Done [[User:PTorres|PTorres]] 17:24, 2022 June 21 (CDT)
| question =
The following query shows profiles that have inconsistent previous service and previous location for CAUs.
  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;


The following query will update these to "Family Medicine" as they should be:
UPDATE ((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 SET s_previous_service.previous_service = "Family Medicine"
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"));
Could you please run the first query, which should list 60-some records, then the second query to fix them, and then the first again to make sure they are gone? Thanks!
| todo_added = 2022-02-17
  }}
  }}



Revision as of 16:24, 21 June 2022

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

Done PTorres 17:22, 2022 June 21 (CDT) }}

Done PTorres 17:22, 2022 June 21 (CDT) }}

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".

{{ Done PTorres 17:24, 2022 June 21 (CDT)

}}

Related articles

Related articles: