Charlson Comorbidity scoring in pre-ICD10 codes: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 7: | Line 7: | ||
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. | 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. | ||
# '''[[S_charlson_dxs table]]''' - the subset of [[S_AllDiagnoses table]] that would contribute to a | # '''[[S_charlson_dxs table]]''' - the subset of [[S_AllDiagnoses table]] that would contribute to a Charlson score | ||
# '''[[query s_como]]''' - query to combine [[S_charlson_dxs table]] and [[S_AllDiagnoses table]] | # '''[[query s_como]]''' - query to combine [[S_charlson_dxs table]] and [[S_AllDiagnoses table]] | ||
# [[query | # '''[[query L_ICD10_Charlson_dxs]]''' - to list only those dxs from [[L_ICD10 table]] that contribute to the Charlson score | ||
# [[query | # '''[[query L_ICD10_Charlson_component_points]]''' - to derive the max score per component | ||
# [[query | # '''[[query L_ICD10_Charlson_score]]''' - to sum up the scores | ||
This is then used by [[query Charlson_Score_pre_and_ICD10]] to provide continuous [[Charlson Comorbidity Index]] scoring. | |||
== Related articles == | == Related articles == |
Revision as of 10:56, 2023 February 2
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.
- S_charlson_dxs table - the subset of S_AllDiagnoses table that would contribute to a Charlson score
- query s_como - query to combine S_charlson_dxs table and S_AllDiagnoses table
- query L_ICD10_Charlson_dxs - to list only those dxs from L_ICD10 table that contribute to the Charlson score
- query L_ICD10_Charlson_component_points - to derive the max score per component
- query L_ICD10_Charlson_score - to sum up the scores
This is then used by query Charlson_Score_pre_and_ICD10 to provide continuous Charlson Comorbidity Index scoring.
Related articles
Related articles: |