L ICD10 APACHE Comorbids query: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
 
Line 2: Line 2:


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 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 ==

Latest revision as of 09:47, 2022 June 30

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: