|
|
| (7 intermediate revisions by 3 users not shown) |
| Line 16: |
Line 16: |
|
| |
|
| 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. | | 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 ==
| |
| We have some remaining data where CAU is the [[Previous Location]] but not the [[Pre-admit Inpatient Institution]]. Julie said:
| |
| <quote><site> CAU has [[S dispo.loc type]] WARD in [[s_dispo table]] which implies included when reporting <site> ward. your question on inconsistencies - we can correct but not priority. Still fine as is when reporting. </quote>
| |
| {{Todo
| |
| | who = Pagasa
| |
| | question =
| |
| * Please update the 10 Pre-admit inpt location for the records in the query below to be the same as the CAU in the previous location. After that is done, please clear out this section. [[User:Ttenbergen|Ttenbergen]] 12:04, 2022 February 11 (CST)
| |
| | todo_added = 2022-02-11
| |
| }}
| |
|
| |
| {{Collapsable
| |
| | always= Query to find profiles with Previous Loc and Pre-admit Inpt Location not CAU
| |
| | full=
| |
| SELECT L_Log.D_ID, s_dispo.location_name AS pre_admit, s_dispo_1.location_name AS previous
| |
| 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) Not Like "*CAU") AND ((s_dispo_1.location_name) Like "*CAU"));
| |
| }}
| |
|
| |
| == 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".
| |
| {{Discuss|
| |
| * was part of another discussion, broke it out here.
| |
| ** <site> CAU has [[S dispo.loc type]] WARD in [[s_dispo table]] which implies included when reporting <site> ward. your question on inconsistencies - we can correct but not priority. Still fine as is when reporting. However the Previous service entries which is Medicine have to be changed to Family Medicine. if you have made it inactive 2021 then no more onwards, correct? --[[User:JMojica|JMojica]] 17:13, 2022 January 26 (CST)
| |
| *** If I understand this right, then the records that have a CAU as [[Previous Location]] or [[Pre-admit Inpatient Institution]], and have [[Previous Service]] equal to "Medicine", should have that previous service changed to "Family Medicine". I made a query to find these, and realized that there are "previous service" other than FM and Med - are those a concern? See below. Do we want to change thes other non-family-medicine values to Family Medicine as well? [[User:Ttenbergen|Ttenbergen]] 11:43, 2022 February 11 (CST)
| |
| *** Flagging this for GRA - could you confirm that changing these actually makes sense? No sense making things consistent if it makes them wrong. [[User:Ttenbergen|Ttenbergen]] 11:59, 2022 February 11 (CST)
| |
| }}
| |
|
| |
| {{Collapsable
| |
| | always= Query to find profiles with Previous Loc CAU and Previous Service not Family Medicine
| |
| | full=
| |
| 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;
| |
| }}
| |
|
| |
|
| == Related articles == | | == Related articles == |
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.
Related articles