Charlson Comorbidity scoring in pre-ICD10 codes

From CCMDB Wiki
Revision as of 17:45, 2023 February 1 by Ttenbergen (talk | contribs)
Jump to navigation Jump to search

This page explains how the Charlson Comorbidity Index score is derived for data prior to Conversion from our old diagnosis schema to ICD10/CCI.

Short version

To get the Charlson comorbid points for a patient, use query pre_ICD10_Charlson_Score

Long version

Points are not included in the listings because the score depends on the combination of diagnoses. For example, if a patient has two diagnoses from the same Charlson component, they are only counted once. Also, if a patient has diagnoses from a lesser and more severe component of the same type (e.g. Diabetes without and with complications), only the higher one counts.

  1. S_charlson_dxs table - the subset of S_AllDiagnoses table that would contribute to a charlson score
  2. query s_como - query to combine S_charlson_dxs table and S_AllDiagnoses table
  3. query Charlson_Comorbid_Score_Admit_detail
  4. [[query Charlson_Comorbid_Score_Como_detail
  5. [[query Charlson_Comorbid_Score
  6. [[query Charlson_Comorbid_Score__detail

Related articles

Related articles: