Query cardiac arrest throughout admission: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
Line 26: Line 26:
"GH-CC", "GH-Med", "HSC_IICU", "HSC_Med", "HSC_MICU", "HSC_SICU", "STB_ACCU", "STB_CICU", "STB_Med", "STB_MICU"
"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 EQ true and have [real_collection] GT "" ? 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''' - '''make not active'''
* HSC_IICU
* HSC_Med
* HSC_MICU
* HSC_SICU
* STB_ACCU
* STB_CICU
* STB_Med
* STB_MICU
}}


== Log ==
== Log ==

Revision as of 15:38, 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: not entered
Coding: NDC_cardiac_arrest_across_encounters
Uses L Problem table: not relevant for this app
Status: needs review
Implementation Date: not entered
Backlogged: No
  • Cargo


  • SMW


  • Categories:

[[Category:{{{DIC_app}}}]] 

  • form:
  • 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? Ttenbergen 10:59, 2023 July 13 (CDT)
    • discussed, yes, this should be even if the are admitted to Med, as long as continuous admission. Ttenbergen 14:57, 2023 July 13 (CDT)
  • SMW


  • Cargo


  • Categories

Definition

For any patient who

the most recently previous Med or ICU admission record should


Med/ICU

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