CCMDB Wiki

Clinical Assessment Unit: Difference between revisions

← Older editNewer edit →
m qui
Line 17: Line 17:
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.


== [[Boarding Loc]] entries ==
== Inconsistencies between previous and pre-admit ==
With [[Change of GRA location names from "our" names to EPR/Cognos names]] and patients boarding in CAU, there are some [[Boarding Loc]] of "GH-CAU". This should not really cause any problems, just documenting it here.  
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 = Tina 
| question = 
* make query of these and get them fixed
| todo_added = 2022-02-11
| todo_action = 2022-02-11
}}


{{Collapsable
== Inconsistencies between [[Previous Location]] and [[Previous Service]] ==
| always= SQL
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".
| full=
{{Discuss|
SELECT L_TmpV2.*
* was part of another discussion, broke it out here.
FROM L_TmpV2
** <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)
WHERE (((L_TmpV2.Project)="Boarding Loc") AND ((L_TmpV2.Item)="GH-CAU"));
*** 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)
}}


== Currrent state in CFE ==
{{Collapsable  
{{Collapsable  
| always= See sql to see dispo or boarding loc CAUs in CFE
| always= Query to find profiles with Previous Loc CAU and Previous Service not Family Medicine
| full=
| full=
Query:
  SELECT L_Log.D_ID, s_dispo.location_name AS pre_admit, s_dispo_1.location_name AS previous, s_previous_service.previous_service
  SELECT L_Log.D_ID, s_dispo.location_name AS pre_admit, s_dispo_1.location_name AS previous, s_dispo_2.location_name AS SL, s_dispo_3.location_name AS dispo, tmp_CAU.Item, L_Log.Accept_DtTm, L_Log.Arrive_DtTm, L_Log.Dispo_DtTm, L_Log.RecordStatus
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
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) LEFT JOIN s_dispo AS s_dispo_2 ON L_Log.Service_Location = s_dispo_2.dispo_ID) LEFT JOIN s_dispo AS s_dispo_3 ON L_Log.Dispo = s_dispo_3.dispo_ID) LEFT JOIN (SELECT L_TmpV2.* FROM L_TmpV2 WHERE (((L_TmpV2.Item) Like "*CAU")))  AS tmp_CAU ON L_Log.D_ID = tmp_CAU.D_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"))
WHERE (((s_dispo.location_name) Like "*CAU")) OR (((s_dispo_1.location_name) Like "*CAU")) OR (((s_dispo_2.location_name) Like "*CAU")) OR (((s_dispo_3.location_name) Like "*CAU"));
ORDER BY s_previous_service.previous_service;
}}
 
== pre-admit inpt... ==
A quick review of the data shows that collectors are using CAUs even now. Possibly more concerningly, when CAU is the [[Previous Location]] , about 5% coded the pre-admit location as NA/Not applicable, the rest coded it as same CAU, except for a few who are mixing CAU and ER in these.
 
{{Discuss | who = Tina |
* Do we need to correct these old inconsistencies? [[User:Ttenbergen|Ttenbergen]] 11:09, 2021 May 5 (CDT)
** <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]] = "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 [[#query 1]] below. [[User:Ttenbergen|Ttenbergen]] 11:43, 2022 February 11 (CST)
*** Juli
}}
}}
=== Query 1 ===


== Related articles ==
== Related articles ==
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Clinical_Assessment_Unit"