Query L ICD10 Charlson component points: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) 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 == | ||
Revision as of 10:04, 12 February 2024
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.
|
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"));