Query cardiac arrest throughout admission: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
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 |
{{Discuss |
* 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)
* 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)
** 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)
}}
}}


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

Revision as of 14:43, 2023 July 13

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:
  • 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)
  • SMW


  • 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: