Clinical Assessment Unit: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
Line 10: Line 10:
[http://home.wrha.mb.ca/improvement/files/models-of-care-emergency-department.pdf WRHA Models of ER Care] article (2017-10-02)
[http://home.wrha.mb.ca/improvement/files/models-of-care-emergency-department.pdf WRHA Models of ER Care] article (2017-10-02)


== Do we actually need to differentiate these from wards? ==
== 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 [[EMIP]]s. 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.  
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 [[EMIP]]s. 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.  


Line 18: Line 18:
** As of 2021-04-22, there are 5 incomplete records at the GRA that still use GRA_CAU. Reviewed my sent emails and it appears I did ''not'' actually email anyone. Emailing the collectors at GRA. [[User:Ttenbergen|Ttenbergen]] 16:54, 2021 April 22 (CDT)
** As of 2021-04-22, there are 5 incomplete records at the GRA that still use GRA_CAU. Reviewed my sent emails and it appears I did ''not'' actually email anyone. Emailing the collectors at GRA. [[User:Ttenbergen|Ttenbergen]] 16:54, 2021 April 22 (CDT)
}}
}}
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 and on wiki
* possibly reconcile the old entries to site-ward as well


{{Discuss | who = Julie |
* do we want to do this?
}}
== reconsidering of [[Boarding Loc]] entries ==
{{TT |  
{{TT |  
Boarding Loc entries:  
Boarding Loc entries:  
* need to consider what to do with records that are in Boarding Loc; especially at GRA, these are listed as GH-CAU, and since we collect actual Cognos entries for boarding loc there, we should likely keep this. If so, we would need to keep the equivalent at other sites also.   
* need to consider what to do with records that are in Boarding Loc; especially at GRA, these are listed as GH-CAU, and since we collect actual Cognos entries for boarding loc there, we should likely keep this. If so, we would need to keep the equivalent at other sites also.   
* 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?
* 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? Need to review this compared to [[Change of GRA location names from "our" names to EPR/Cognos names]]
}}
}}


 
== Currrent state in CFE ==
 
{{Collapsable  
{{Collapsable  
| always= See sql to see dispo or boarding loc CAUs in CFE
| always= See sql to see dispo or boarding loc CAUs in CFE
Line 34: Line 43:
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"));
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"));
  }}
  }}
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 and on wiki
* possibly reconcile the old entries to site-ward as well
{{Discuss | who = Julie |
* do we want to do this?
}}


== pre-admit inpt... ==
== pre-admit inpt... ==

Revision as of 16:57, 2021 April 22

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.


Changing existing values for incomplete L_Log entries:

  • Emailed Collectors to change the remaining entries to local ward instead. Waiting to hear back now. Ttenbergen 17:03, 2021 April 1 (CDT)
    • As of 2021-04-22, there are 5 incomplete records at the GRA that still use GRA_CAU. Reviewed my sent emails and it appears I did not actually email anyone. Emailing the collectors at GRA. Ttenbergen 16:54, 2021 April 22 (CDT)
  • added: no added date
  • action: no action date
  • Cargo


  • Categories

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 and on wiki
  • possibly reconcile the old entries to site-ward as well
  • do we want to do this?
  • SMW


  • Cargo


  • Categories

reconsidering of Boarding Loc entries

Boarding Loc entries:

  • need to consider what to do with records that are in Boarding Loc; especially at GRA, these are listed as GH-CAU, and since we collect actual Cognos entries for boarding loc there, we should likely keep this. If so, we would need to keep the equivalent at other sites also.
  • 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? Need to review this compared to Change of GRA location names from "our" names to EPR/Cognos names
  • added: no added date
  • action: no action date
  • Cargo


  • Categories

Currrent state in CFE

See sql to see dispo or boarding loc CAUs in CFE   

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"));

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: