CCMDB Wiki

Query cardiac arrest throughout admission: Difference between revisions

← Older edit
mNo edit summary
 
(4 intermediate revisions by 2 users not shown)
Line 7: Line 7:
|DIC_status=needs review
|DIC_status=needs review
|DIC_LProblem=yes
|DIC_LProblem=yes
|DIC_app=Centralized data front end.accdb
|DIC_backlogged=No
|DIC_backlogged=No
}}
}}
{{Discuss |
{{Todo
* One more question. The definition says "admitted to ICU". Should it really only be ones who arrive on ICU? Or should someone who arrives on Med with a primary admit of cardiac arrest from another place where we collect also have this check? I can't think of a scenario where this would happen, but if it did, should they be included in this check? [[User:Ttenbergen|Ttenbergen]] 10:59, 2023 July 13 (CDT)
| who = Allan, Julie, Lisa, Tina
** discussed, yes, this should be even if the are admitted to Med, as long as continuous admission. [[User:Ttenbergen|Ttenbergen]] 14:57, 2023 July 13 (CDT)
| todo_added = 2024-10-02
}}
| todo_action = 2024-10-02
| question = 
* Lisa flagged that, if we do this for Cardiac Arrest, we should really do it for other dxs as well. And if we did that, it could result in a lot of work since it would need to be mediated by Pagasa for now. So we decided to see where the SF implementation goes and review the definition of this check once we have a centralized tool where the data collector would not need to mediate this. [[User:Ttenbergen|Ttenbergen]] 15:43, 2023 July 13 (CDT)
** Now that SF is on hold, leave this as a to do?[[User:Lkaita|Lisa Kaita]] 14:42, 2024 October 2 (CDT)
*** I am OK with turning this into a to-do if SF is on hold for the forseeable future. [[User:Ttenbergen|Ttenbergen]] 12:46, 2024 October 3 (CDT)}}  


== Definition ==
== Definition ==
For any patient who  
For any patient who  
* is admitted to the CC program and  
* is admitted to our database and  
* has a {{ICD10WithCode|Cardiac arrest}} as [[Primary Admit Diagnosis]] and  
* has a {{ICD10WithCode|Cardiac arrest}} as [[Primary Admit Diagnosis]] and  
* [[Previous Location]] is a ward or medical ICU where we collect from [[#Med/ICU]]
* [[Previous Location]] is a ward or medical ICU where we collect from ([[#Med/ICU]])
the most recently previous Med or ICU admission record should  
the most recently previous admission record should  
* have a {{ICD10WithCode|Cardiac arrest}} as either [[Admit Diagnosis]] or [[Acquired Diagnosis]]
* have a {{ICD10WithCode|Cardiac arrest}} as either [[Admit Diagnosis]] or [[Acquired Diagnosis]]




=== Med/ICU ===
=== Med/ICU ===
"GH-CC", "GH-Med", "HSC_IICU", "HSC_Med", "HSC_MICU", "HSC_SICU", "STB_ACCU", "STB_CICU", "STB_Med", "STB_MICU"
[[Previous Location]] in ("GH-CC", "GH-Med", "HSC_IICU", "HSC_Med", "HSC_MICU", "HSC_SICU", "STB_ACCU", "STB_CICU", "STB_Med", "STB_MICU")


These would not be hard coded but instead be defined as ''the lines in [[s_dispo table]] that are active and have previous_location = true and have [real_collection] > ""
These would not be hard coded but instead be defined as ''the lines in [[s_dispo table]] that are active and have previous_location = true and have [real_collection] > ""
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_cardiac_arrest_throughout_admission"