|
|
| (5 intermediate revisions by 2 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".
| |
|
| |
| {{Todo
| |
| | who = Pagasa
| |
| | question =
| |
| The following query shows profiles that have inconsistent previous service and previous location for CAUs.
| |
| 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;
| |
|
| |
| The following query will update these to "Family Medicine" as they should be:
| |
| UPDATE ((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 SET s_previous_service.previous_service = "Family Medicine"
| |
| 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"));
| |
|
| |
| Could you please run the first query, which should list 60-some records, then the second query to fix them, and then the first again to make sure they are gone? Thanks!
| |
| | todo_added = 2022-02-17
| |
| | todo_action =
| |
| }}
| |
|
| |
|
| == Related articles == | | == Related articles == |