Query cardiac arrest throughout admission: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
No edit summary
(7 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
|DIC_summary=Any patient who arrives on ICU from Med or another ICU with a [[#Cardiac Arrest]] dx should have one in their immediately preceeding Med or ICU record also.
|DIC_summary=Any patient who is admitted to ICU from Med or another ICU with a [[#Cardiac Arrest]] dx should have one in their immediately preceeding Med or ICU record also.
|DIC_related_concepts=Admit Diagnosis; Acquired Diagnosis / Complication; Previous Location field; Cardiac arrest; Dispo field
|DIC_related_concepts=Admit Diagnosis; Acquired Diagnosis / Complication; Previous Location field; Cardiac arrest; Dispo field
|DIC_firmness=hard check
|DIC_firmness=hard check
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 "arrives on 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
}}
| 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)}}  


== 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] > ""
{{Discuss |
I was about to hardcode these, but: shouldn't these correspond to lines in [[s_dispo table]] that are active and previous_location = true and have [real_collection]>"" ? But then I checked, and the lists are not the same! Here is the list I get from that query:
* GH-CC
* GH-Med
* '''HSC_CC'''
* HSC_IICU
* HSC_Med
* HSC_MICU
* HSC_SICU
* STB_ACCU
* STB_CICU
* STB_Med
* STB_MICU
}}


== Log ==
== Log ==

Revision as of 13:42, 2024 October 2

Data Integrity Checks
Summary: Any patient who is admitted to ICU from Med or another ICU with a #Cardiac Arrest dx should have one in their immediately preceeding Med or ICU record also.
Related: Admit Diagnosis, Acquired Diagnosis / Complication, Previous Location field, Cardiac arrest, Dispo field
Firmness: hard check
Timing: complete
App: Centralized data front end.accdb
Coding: NDC_cardiac_arrest_across_encounters
Uses L Problem table: yes
Status: needs review
Implementation Date: not entered
Backlogged: No
  • Cargo


  • SMW


  • Categories:  
  • form:

for Allan, Julie, Lisa, Tina

  • 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. Ttenbergen 15:43, 2023 July 13 (CDT) Now that SF is on hold, leave this as a to do?Lisa Kaita 14:42, 2024 October 2 (CDT)
  • added: 2024-10-02
  • action: 2024-10-02
  • Cargo


  • Categories

Definition

For any patient who

the most recently previous admission record should


Med/ICU

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] > ""

Log

2023-07-12 - started conversation

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_cardiac_arrest_throughout_admission&oldid=161820"