|
|
| (24 intermediate revisions by 4 users not shown) |
| 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. |
|
| |
|
| {{TT |
| | All *CAU entries for incomplete pts were changed to *ward entries, and the *CAU entries in [[S dispo table]] were retired. |
| * Emailed Collectors to change the remaining entries to local ward instead. Waiting to hear back now. [[User:Ttenbergen|Ttenbergen]] 17:03, 2021 April 1 (CDT) | |
| * need to consider what to do with records that are in Boarding Loc.
| |
| }}
| |
|
| |
|
| | | 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. |
| {{DiscussTask |
| |
| * 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.
| |
| | |
| 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)
| |
| }}
| |
| {{Collapsable
| |
| | always= See sql to see boarding loc CAUs in CFE
| |
| | full=
| |
| SELECT L_TmpV2.*, L_TmpV2.Item
| |
| FROM L_TmpV2
| |
| WHERE (((L_TmpV2.Item) Like "*CAU"));
| |
| }}
| |
| | |
| {{Collapsable
| |
| | always= See sql to see pre-admit, previous and dispo CAUs in CFE
| |
| | full= 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
| |
| | |
| {{Discuss | who = Julie |
| |
| * do we want to do this?
| |
| }}
| |
| | |
| == 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.
| |
| | |
| {{Discuss | who = Julie |
| |
| * do we need to do anything to get collectors to fill this out right? Or to deal with back-data? [[User:Ttenbergen|Ttenbergen]] 14:40, 2021 March 11 (CST)
| |
| }}
| |
|
| |
|
| == Related articles == | | == Related articles == |