Clinical Assessment Unit: Difference between revisions
Ttenbergen (talk | contribs) m qui |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 21: | Line 21: | ||
<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> | <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 | {{Todo | ||
| who = | | who = Pagasa | ||
| question = | | 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 | | 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]] == | == Inconsistencies between [[Previous Location]] and [[Previous Service]] == | ||