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 |
||
| (5 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
{{PAGENAME}} in [[Centralized data front end.accdb]] | {{PAGENAME}} 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 == | ||
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