L ICD10 APACHE Comorbids query: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Created page with "The L_ICD10_APACHE_Comorbids query generates a list of patients ICD10 diagnoses and which APACHE Comorbid Diagnoses they would contribute to. Uses data from: *L_ICD10..."
 
m Text replacement - "[[Category: " to "[[Category:"
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
The L_ICD10_APACHE_Comorbids query generates a list of patients ICD10 diagnoses and which [[APACHE Comorbid Diagnoses]] they would contribute to.  
The L_ICD10_APACHE_Comorbids query generates a list of patients ICD10 diagnoses and which [[APACHE Comorbid Diagnoses]] they would contribute to.  


Uses data from:
The query lists dx records in [[L_ICD10 table]] that have a counterpart in [[S_ICD10_APACHE_Comorbids query]] and have [[Dx_Type]] = "Comorbid".
*[[L_ICD10 table]]
*[[S_ICD10_APACHE_Comorbids query]]


   
The query is used by the [[Created_APACHE_Chronic query]] to generate the [[Chronic Health APACHE]].
[[Category: ICD10]]
 
[[Category: APACHE II]]
== Related Articles ==
{{Related Articles}}
 
[[Category:ICD10]]
[[Category:APACHE II]]

Latest revision as of 10:35, 30 July 2025

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: