|
|
| Line 27: |
Line 27: |
| 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". | | 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
| | Done [[User:PTorres|PTorres]] 17:24, 2022 June 21 (CDT) |
| | 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
| |
| }} | | }} |
|
| |
|