Query L ICD10 Charlson component points: Difference between revisions

(6 intermediate revisions by 2 users not shown)

Line 1:

{{PAGENAME}} is part of [[Charlson Comorbidity scoring in ICD10 codes]], ~~see there~~ for ~~how~~ it's ~~used~~.

{{PAGENAME}} in [[Centralized data front end.accdb]] is part of [[Charlson Comorbidity scoring in ICD10 codes]].

Specifically the query aggregates only the highest points per grouping, e.g. if a pt has both mild and moderate liver disease only the higher should be scored.

As per [[Charlson Comorbidities in ICD10 codes]]: "BOTH for simplicity AND to have a measure that is consistent with the way it is usually computed, we have chosen to use the Quan's specific ICD-10 codes, regardless of whether they're listed Comorbid Diagnoses, Admit Diagnoses or Acquired Diagnoses."

== Log ==

* 2024-02-14 - removed clause ''HAVING (((L_ICD10_Charlson_dxs.Dx_Type)="Comorbid" Or (L_ICD10_Charlson_dxs.Dx_Type)="Acquired"));'' to consider all diagnosis types, consistent with [[Charlson Comorbidities in ICD10 codes ]]

== Related articles ==

[[Category:Charlson Comorbid Diagnosis]]

@@ Line 1: / Line 1: @@
-{{PAGENAME}} is part of [[Charlson Comorbidity scoring in ICD10 codes]], see there for how it's used.
+{{PAGENAME}} in [[Centralized data front end.accdb]] is part of [[Charlson Comorbidity scoring in ICD10 codes]].
+Specifically the query aggregates only the highest points per grouping, e.g. if a pt has both mild and moderate liver disease only the higher should be scored.
+As per [[Charlson Comorbidities in ICD10 codes]]: "BOTH for simplicity AND to have a measure that is consistent with the way it is usually computed, we have chosen to use the Quan's specific ICD-10 codes, regardless of whether they're listed Comorbid Diagnoses, Admit Diagnoses or Acquired Diagnoses."
+== Log ==
+* 2024-02-14 - removed clause ''HAVING (((L_ICD10_Charlson_dxs.Dx_Type)="Comorbid" Or (L_ICD10_Charlson_dxs.Dx_Type)="Acquired"));'' to consider all diagnosis types, consistent with [[Charlson Comorbidities in ICD10 codes ]]
+== Related articles ==
+{{Related Articles}}
 [[Category:Charlson Comorbid Diagnosis]]