|
|
| (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 == |