Query L ICD10 Charlson component points: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) 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 |
No edit summary |
||
| Line 7: | Line 7: | ||
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. | ||
}} | **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]] | ||
Revision as of 13:47, 11 March 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.
|
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
- 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.