Charlson Comorbidity scoring in pre-ICD10 codes: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) (Created page with "This page explains how the actual Charlson Comorbidity Index is derived from the pre-IDC10 dx codes need to link. === 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 pa...") |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 1: | Line 1: | ||
This page explains how the | 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 === | === Short version === | ||
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_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 Charlson_Comorbid_Score_Admit_detail]] | # [[query Charlson_Comorbid_Score_Admit_detail]] | ||
# [[query Charlson_Comorbid_Score_Como_detail | # [[query Charlson_Comorbid_Score_Como_detail |
Revision as of 17:45, 2023 February 1
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 Charlson_Comorbid_Score_Admit_detail
- [[query Charlson_Comorbid_Score_Como_detail
- [[query Charlson_Comorbid_Score
- [[query Charlson_Comorbid_Score__detail
Related articles
Related articles: |