charlson_comorbidity_index

An assessment tool used to predict the risk of death from comorbid disease.

An assessment tool used to predict the risk of death from comorbid disease.

Purpose. To record the result for each component parameter of the Charlson Comorbidity Index (CCI) and its total sum, and to calculate the 10 year estimated survival.

Source

Columns

Constraints

check ((age_group_code is null and age_group_system is null and age_group_numeric is null and age_group is null) or (age_group_valueset_id is not null and age_group_code is not null and age_group_system is not null and age_group_numeric is not null and age_group is not null))
check ((myocardial_infarction_code is null and myocardial_infarction_system is null and myocardial_infarction_numeric is null and myocardial_infarction is null) or (myocardial_infarction_valueset_id is not null and myocardial_infarction_code is not null and myocardial_infarction_system is not null and myocardial_infarction_numeric is not null and myocardial_infarction is not null))
check ((congestive_heart_failure_code is null and congestive_heart_failure_system is null and congestive_heart_failure_numeric is null and congestive_heart_failure is null) or (congestive_heart_failure_valueset_id is not null and congestive_heart_failure_code is not null and congestive_heart_failure_system is not null and congestive_heart_failure_numeric is not null and congestive_heart_failure is not null))
check ((peripheral_vascular_disease_code is null and peripheral_vascular_disease_system is null and peripheral_vascular_disease_numeric is null and peripheral_vascular_disease is null) or (peripheral_vascular_disease_valueset_id is not null and peripheral_vascular_disease_code is not null and peripheral_vascular_disease_system is not null and peripheral_vascular_disease_numeric is not null and peripheral_vascular_disease is not null))
check ((cerebrovascular_disease_code is null and cerebrovascular_disease_system is null and cerebrovascular_disease_numeric is null and cerebrovascular_disease is null) or (cerebrovascular_disease_valueset_id is not null and cerebrovascular_disease_code is not null and cerebrovascular_disease_system is not null and cerebrovascular_disease_numeric is not null and cerebrovascular_disease is not null))
check ((dementia_code is null and dementia_system is null and dementia_numeric is null and dementia is null) or (dementia_valueset_id is not null and dementia_code is not null and dementia_system is not null and dementia_numeric is not null and dementia is not null))
check ((chronic_pulmonary_disease_code is null and chronic_pulmonary_disease_system is null and chronic_pulmonary_disease_numeric is null and chronic_pulmonary_disease is null) or (chronic_pulmonary_disease_valueset_id is not null and chronic_pulmonary_disease_code is not null and chronic_pulmonary_disease_system is not null and chronic_pulmonary_disease_numeric is not null and chronic_pulmonary_disease is not null))
check ((ulcer_disease_code is null and ulcer_disease_system is null and ulcer_disease_numeric is null and ulcer_disease is null) or (ulcer_disease_valueset_id is not null and ulcer_disease_code is not null and ulcer_disease_system is not null and ulcer_disease_numeric is not null and ulcer_disease is not null))
check ((liver_disease_code is null and liver_disease_system is null and liver_disease_numeric is null and liver_disease is null) or (liver_disease_valueset_id is not null and liver_disease_code is not null and liver_disease_system is not null and liver_disease_numeric is not null and liver_disease is not null))
check ((connective_tissue_disease_code is null and connective_tissue_disease_system is null and connective_tissue_disease_numeric is null and connective_tissue_disease is null) or (connective_tissue_disease_valueset_id is not null and connective_tissue_disease_code is not null and connective_tissue_disease_system is not null and connective_tissue_disease_numeric is not null and connective_tissue_disease is not null))
check ((diabetes_mellitus_code is null and diabetes_mellitus_system is null and diabetes_mellitus_numeric is null and diabetes_mellitus is null) or (diabetes_mellitus_valueset_id is not null and diabetes_mellitus_code is not null and diabetes_mellitus_system is not null and diabetes_mellitus_numeric is not null and diabetes_mellitus is not null))
check ((hemiplegia_code is null and hemiplegia_system is null and hemiplegia_numeric is null and hemiplegia is null) or (hemiplegia_valueset_id is not null and hemiplegia_code is not null and hemiplegia_system is not null and hemiplegia_numeric is not null and hemiplegia is not null))
check ((moderate_or_severe_renal_disease_code is null and moderate_or_severe_renal_disease_system is null and moderate_or_severe_renal_disease_numeric is null and moderate_or_severe_renal_disease is null) or (moderate_or_severe_renal_disease_valueset_id is not null and moderate_or_severe_renal_disease_code is not null and moderate_or_severe_renal_disease_system is not null and moderate_or_severe_renal_disease_numeric is not null and moderate_or_severe_renal_disease is not null))
check ((solid_tumor_code is null and solid_tumor_system is null and solid_tumor_numeric is null and solid_tumor is null) or (solid_tumor_valueset_id is not null and solid_tumor_code is not null and solid_tumor_system is not null and solid_tumor_numeric is not null and solid_tumor is not null))
check ((leukemia_code is null and leukemia_system is null and leukemia_numeric is null and leukemia is null) or (leukemia_valueset_id is not null and leukemia_code is not null and leukemia_system is not null and leukemia_numeric is not null and leukemia is not null))
check ((lymphoma_code is null and lymphoma_system is null and lymphoma_numeric is null and lymphoma is null) or (lymphoma_valueset_id is not null and lymphoma_code is not null and lymphoma_system is not null and lymphoma_numeric is not null and lymphoma is not null))
check ((aids_code is null and aids_system is null and aids_numeric is null and aids is null) or (aids_valueset_id is not null and aids_code is not null and aids_system is not null and aids_numeric is not null and aids is not null))
check ((estimated_10_year_survival_magnitude is null and estimated_10_year_survival_units is null) or (estimated_10_year_survival_magnitude is not null and estimated_10_year_survival_units is not null))

Unique

• form_block_id

References

Indexes

• charlson_comorbidity_index_form_id_idx on form_id

Value sets