L ICD10 APACHE Dx query: Difference between revisions

Revision as of 21:20, 2018 November 24

The L_ICD10_APACHE_Comorbids query generates a list of patients ICD10 diagnoses and which APACHE Acute Diagnoses they would contribute to.

The query lists dx records in L_ICD10 table that have a counterpart in S_ICD10_APACHE_Dx query and have Dx_Type = "Admit".

Template:Discussion still waiting to hear if acquires should be included... Ttenbergen 17:23, 2018 February 25 (CST)

	You and Allan discussed what should be on the list. At some point we will need to integrate the result into this query. Did you end up including Acquireds? Since the first 24hrs might include them, but they might happen later, and the difference is not clear from Dx_Date? Ttenbergen 20:20, 2018 November 24 (CST)

@@ Line 1: / Line 1: @@
 The L_ICD10_APACHE_Comorbids query generates a list of patients ICD10 diagnoses and which [[APACHE Acute Diagnoses]] they would contribute to.
-The query lists dx records in [[L_ICD10 table]] that have a counterpart in [[S_ICD10_APACHE_Dx query]] and have [[Dx_Type]] = "Admit".  {{discussion}} still waiting to hear if acquires should be included... Ttenbergen 17:23, 2018 February 25 (CST)
+The query lists dx records in [[L_ICD10 table]] that have a counterpart in [[S_ICD10_APACHE_Dx query]] and have [[Dx_Type]] = "Admit".
+{{discussion}} still waiting to hear if acquires should be included... Ttenbergen 17:23, 2018 February 25 (CST)
+{{Discuss | who = Julie | question = * You and Allan discussed what should be on the list. At some point we will need to integrate the result into this query. Did you end up including Acquireds? Since the first 24hrs might include them, but they might happen later, and the difference is not clear from [[Dx_Date]]? Ttenbergen 20:20, 2018 November 24 (CST)}}
 == Related Articles ==