|
|
| (21 intermediate revisions by 4 users not shown) |
| Line 13: |
Line 13: |
| 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. |
| Changing existing values for incomplete L_Log entries:
| |
| * 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) | |
| ** 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 |
| | 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. |
| * do we want to do this?
| |
| }}
| |
| | |
| == reconsidering of [[Boarding Loc]] entries ==
| |
| {{TT |
| |
| 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]]
| |
| }}
| |
| | |
| == Currrent state in CFE ==
| |
| {{Collapsable
| |
| | always= See sql to see dispo or boarding loc CAUs in CFE
| |
| | full=
| |
| 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.
| |
| | |
| {{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 == |