Query cardiac arrest throughout admission

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:

Review after 2023-09-15 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

• is admitted to our database 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 admission record should

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

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