Query L ICD10 Charlson component points: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
(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 )
Line 8: Line 8:
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.  
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.  
}}
}}
HAVING (((L_ICD10_Charlson_dxs.Dx_Type)="Comorbid" Or (L_ICD10_Charlson_dxs.Dx_Type)="Acquired"));
 
== 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 ==  

Revision as of 00:18, 2024 February 15

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.


  • 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.

  • SMW


  • Cargo


  • Categories

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: