Query cardiac arrest throughout admission: Difference between revisions

Revision as of 11:33, 2023 July 13

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

	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)

For any patient who

the most recently previous Med or ICU admission record should

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

2023-07-12 - started conversation

@@ Line 23: / Line 23: @@
 === Med/ICU ===
-GH-Med, HSC_Med, STB_Med, GH-CC, HSC_MICU, HSC_SICU,  HSC_IICU, STB_MICU, STB_CICU, STB_ACCU.
+"GH-CC", "GH-Med", "HSC_IICU", "HSC_Med", "HSC_MICU", "HSC_SICU", "STB_ACCU", "STB_CICU", "STB_Med", "STB_MICU"
+{{Discussion |
+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 ==