Query L ICD10 Charlson component points: Difference between revisions

mNo edit summary
mNo edit summary
Line 2: Line 2:


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 |
* 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.
}}
HAVING (((L_ICD10_Charlson_dxs.Dx_Type)="Comorbid" Or (L_ICD10_Charlson_dxs.Dx_Type)="Acquired"));


== Related articles ==  
== Related articles ==