|
|
| (20 intermediate revisions by 4 users not shown) |
| Line 15: |
Line 15: |
| All *CAU entries for incomplete pts were changed to *ward entries, and the *CAU entries in [[S dispo table]] were retired. | | All *CAU entries for incomplete pts were changed to *ward entries, and the *CAU entries in [[S dispo table]] were retired. |
|
| |
|
| {{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 you care if we keep the old entries around, or do you want them converted to plain *Ward entries to show up differently in any reporting you do? If fine as is then we should set this page (and the local equivalents) to Legacy. If you want to convert, we can do that and then delete the old CAU pages.
| |
| | |
| }}
| |
| | |
| == 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 == |