Charlson Comorbidity scoring in ICD10 codes: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 13: | Line 13: | ||
# '''[[query L_ICD10_Charlson_dxs]]''' lists only the subset of the dxs coded in the [[L_ICD10 table]] that are also in [[query s_ICD10_Charlson_Comorbids]] | # '''[[query L_ICD10_Charlson_dxs]]''' lists only the subset of the dxs coded in the [[L_ICD10 table]] that are also in [[query s_ICD10_Charlson_Comorbids]] | ||
# '''[[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 | # '''[[query L_ICD10_Charlson_score]]''' sums up the points in [[query L_ICD10_Charlson_component_points]] for the actual score for record / [[D_ID]] | ||
== Related articles == | == Related articles == | ||