Query cardiac arrest throughout admission

Data Integrity Checks
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.
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 "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? Ttenbergen 10:59, 2023 July 13 (CDT)

• SMW

• Cargo

• Categories

Definition

For any patient who

• is admitted to the CC program and
• has a Cardiac arrest (I46.9) as Primary Admit Diagnosis and
• Previous Location is a ward or medical ICU where we collect from #Med/ICU

the most recently previous Med or ICU admission record should

• have a Cardiac arrest (I46.9) as either Admit Diagnosis or Acquired Diagnosis

Med/ICU

"GH-CC", "GH-Med", "HSC_IICU", "HSC_Med", "HSC_MICU", "HSC_SICU", "STB_ACCU", "STB_CICU", "STB_Med", "STB_MICU"

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 HSC_IICU HSC_Med HSC_MICU HSC_SICU STB_ACCU STB_CICU STB_Med STB_MICU

• SMW

• Cargo

• Categories

Log

2023-07-12 - started conversation