Query L ICD10 Charlson component points: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
mNo edit summary
 
Line 3: Line 3:
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.  
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.  


{{DJ |
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."
* I am puzzled by the Having clause:  
 
Shouldn't that be Comorbid and Admit? It's been however it is for some time, and the wiki page doesn't explain why it would be "acquired". I am flagging this question on that page, lets discuss or document further on there.  
**see below which is from [[Charlson Comorbidities in ICD10 codes ]]}}


== Log ==
== 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 ]]
* 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 ]]
**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.
 
== Related articles ==  
== Related articles ==  
{{Related Articles}}
{{Related Articles}}


[[Category:Charlson Comorbid Diagnosis]]
[[Category:Charlson Comorbid Diagnosis]]

Latest revision as of 15:50, 2024 March 11

Query L ICD10 Charlson component points 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: