Charlson Comorbidity scoring in ICD10 codes: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 14: | Line 14: | ||
# '''[[query L_ICD10_Charlson_component_points]]''' is an aggregate query which joins [[query L_ICD10_Charlson_dxs]] with the [[s_ICD10_Charlson_Como_conditions table]]; it keeps only the maximum score of each Charlson grouping | # '''[[query L_ICD10_Charlson_component_points]]''' is an aggregate query which joins [[query L_ICD10_Charlson_dxs]] with the [[s_ICD10_Charlson_Como_conditions table]]; it keeps only the maximum score of each Charlson grouping | ||
# '''[[query L_ICD10_Charlson_score]]''' sums up the points in [[query L_ICD10_Charlson_component_points]] for the actual score for record / [[D_ID]] | # '''[[query L_ICD10_Charlson_score]]''' sums up the points in [[query L_ICD10_Charlson_component_points]] for the actual score for record / [[D_ID]] | ||
This is then used by [[query Charlson_Score_pre_and_ICD10]] to provide continuous [[Charlson Comorbidity Index]] scoring. | |||
== Related articles == | == Related articles == | ||