L ICD10 APACHE Dx query

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)