L ICD10 APACHE Comorbids query

From CCMDB Wiki
Jump to navigation Jump to search

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

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

The query is used by the Created_APACHE_Chronic query to generate the Chronic Health APACHE.

Related Articles

Related articles: