Charlson Comorbidity scoring in ICD10 codes: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 10: | Line 10: | ||
# '''[[s_ICD10_Charlson_Como_patterns table]]''' contains matchable values and ranges of ICD10 codes assigned to Charlson comorbid groups; this was implemented as a set of ranges and matches rather than an absolute table to allow for future addition of ICD10 codes to fit into the Charlson calculation seamlessly and transparently, and most importantly, hands-off. | # '''[[s_ICD10_Charlson_Como_patterns table]]''' contains matchable values and ranges of ICD10 codes assigned to Charlson comorbid groups; this was implemented as a set of ranges and matches rather than an absolute table to allow for future addition of ICD10 codes to fit into the Charlson calculation seamlessly and transparently, and most importantly, hands-off. | ||
# '''[[s_ICD10_Charlson_Como_conditions table]]''' contains the Charlson comorbid groups, their scores, and where applicable, groupings to show when one element takes precedence over another (e.g. if a pt has both cancer and metastatic cancer, only the score for metastatic cancer applies). | # '''[[s_ICD10_Charlson_Como_conditions table]]''' contains the Charlson comorbid groups, their scores, and where applicable, groupings to show when one element takes precedence over another (e.g. if a pt has both cancer and metastatic cancer, only the score for metastatic cancer applies). | ||
# '''[[query s_ICD10_Charlson_Comorbids]]''' is the subset of diagnoses in [[s_ICD10 table]] that map to a match or range in [[s_ICD10_Charlson_Como_patterns table]]; it also includes the points from [[s_ICD10_Charlson_Como_conditions table]] | |||
# '''[[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 == | ||