---
title: "charlson_comorbidity_index"
description: "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

| Model | Leg | Role |
|---|---|---|
| `openEHR-EHR-OBSERVATION.charlson_comorbidity_index.v2` | openEHR | defines this table |

## Columns

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `form_id` | `uuid` → [`form`](/docs/tables/form) | no | The form this entry was recorded on. | — |
| `form_block_id` | `uuid` | yes | The block within the form, when the entry is bound to one. | — |
| `age_group`<br />`age_group_code`<br />`age_group_system`<br />`age_group_numeric`<br />`age_group_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Age group | `/data[at0001]/events[at0002]/data[at0003]/items[at0061]` |
| `myocardial_infarction`<br />`myocardial_infarction_code`<br />`myocardial_infarction_system`<br />`myocardial_infarction_numeric`<br />`myocardial_infarction_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Myocardial infarction | `/data[at0001]/events[at0002]/data[at0003]/items[at0012]` |
| `congestive_heart_failure`<br />`congestive_heart_failure_code`<br />`congestive_heart_failure_system`<br />`congestive_heart_failure_numeric`<br />`congestive_heart_failure_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Congestive heart failure | `/data[at0001]/events[at0002]/data[at0003]/items[at0009]` |
| `peripheral_vascular_disease`<br />`peripheral_vascular_disease_code`<br />`peripheral_vascular_disease_system`<br />`peripheral_vascular_disease_numeric`<br />`peripheral_vascular_disease_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Peripheral vascular disease | `/data[at0001]/events[at0002]/data[at0003]/items[at0006]` |
| `cerebrovascular_disease`<br />`cerebrovascular_disease_code`<br />`cerebrovascular_disease_system`<br />`cerebrovascular_disease_numeric`<br />`cerebrovascular_disease_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Cerebrovascular disease | `/data[at0001]/events[at0002]/data[at0003]/items[at0015]` |
| `dementia`<br />`dementia_code`<br />`dementia_system`<br />`dementia_numeric`<br />`dementia_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Dementia | `/data[at0001]/events[at0002]/data[at0003]/items[at0018]` |
| `chronic_pulmonary_disease`<br />`chronic_pulmonary_disease_code`<br />`chronic_pulmonary_disease_system`<br />`chronic_pulmonary_disease_numeric`<br />`chronic_pulmonary_disease_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Chronic pulmonary disease | `/data[at0001]/events[at0002]/data[at0003]/items[at0021]` |
| `ulcer_disease`<br />`ulcer_disease_code`<br />`ulcer_disease_system`<br />`ulcer_disease_numeric`<br />`ulcer_disease_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Ulcer disease | `/data[at0001]/events[at0002]/data[at0003]/items[at0024]` |
| `liver_disease`<br />`liver_disease_code`<br />`liver_disease_system`<br />`liver_disease_numeric`<br />`liver_disease_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Liver disease | `/data[at0001]/events[at0002]/data[at0003]/items[at0027]` |
| `connective_tissue_disease`<br />`connective_tissue_disease_code`<br />`connective_tissue_disease_system`<br />`connective_tissue_disease_numeric`<br />`connective_tissue_disease_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Connective tissue disease | `/data[at0001]/events[at0002]/data[at0003]/items[at0030]` |
| `diabetes_mellitus`<br />`diabetes_mellitus_code`<br />`diabetes_mellitus_system`<br />`diabetes_mellitus_numeric`<br />`diabetes_mellitus_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Diabetes mellitus | `/data[at0001]/events[at0002]/data[at0003]/items[at0033]` |
| `hemiplegia`<br />`hemiplegia_code`<br />`hemiplegia_system`<br />`hemiplegia_numeric`<br />`hemiplegia_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Hemiplegia | `/data[at0001]/events[at0002]/data[at0003]/items[at0036]` |
| `moderate_or_severe_renal_disease`<br />`moderate_or_severe_renal_disease_code`<br />`moderate_or_severe_renal_disease_system`<br />`moderate_or_severe_renal_disease_numeric`<br />`moderate_or_severe_renal_disease_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Moderate or severe renal disease | `/data[at0001]/events[at0002]/data[at0003]/items[at0039]` |
| `solid_tumor`<br />`solid_tumor_code`<br />`solid_tumor_system`<br />`solid_tumor_numeric`<br />`solid_tumor_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Solid tumor | `/data[at0001]/events[at0002]/data[at0003]/items[at0045]` |
| `leukemia`<br />`leukemia_code`<br />`leukemia_system`<br />`leukemia_numeric`<br />`leukemia_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Leukemia | `/data[at0001]/events[at0002]/data[at0003]/items[at0047]` |
| `lymphoma`<br />`lymphoma_code`<br />`lymphoma_system`<br />`lymphoma_numeric`<br />`lymphoma_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Lymphoma | `/data[at0001]/events[at0002]/data[at0003]/items[at0050]` |
| `aids`<br />`aids_code`<br />`aids_system`<br />`aids_numeric`<br />`aids_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | AIDS | `/data[at0001]/events[at0002]/data[at0003]/items[at0060]` |
| `cci_total_score` | `integer` | yes | CCI total score | `/data[at0001]/events[at0002]/data[at0003]/items[at0072]` |
| `estimated_10_year_survival_magnitude`<br />`estimated_10_year_survival_units` | quantity<br />`numeric`, `text` | yes | Estimated 10-year survival | `/data[at0001]/events[at0002]/data[at0003]/items[at0073]` |

## Constraints

```sql
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

| Columns | Target | On delete |
|---|---|---|
| `form_id` | [`form`](/docs/tables/form) | cascade |
| `form_id, form_block_id` | [`form_block`](/docs/tables/form_block) | cascade |
| `age_group_valueset_id, age_group_code, age_group_system, age_group, age_group_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `myocardial_infarction_valueset_id, myocardial_infarction_code, myocardial_infarction_system, myocardial_infarction, myocardial_infarction_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `congestive_heart_failure_valueset_id, congestive_heart_failure_code, congestive_heart_failure_system, congestive_heart_failure, congestive_heart_failure_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `peripheral_vascular_disease_valueset_id, peripheral_vascular_disease_code, peripheral_vascular_disease_system, peripheral_vascular_disease, peripheral_vascular_disease_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `cerebrovascular_disease_valueset_id, cerebrovascular_disease_code, cerebrovascular_disease_system, cerebrovascular_disease, cerebrovascular_disease_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `dementia_valueset_id, dementia_code, dementia_system, dementia, dementia_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `chronic_pulmonary_disease_valueset_id, chronic_pulmonary_disease_code, chronic_pulmonary_disease_system, chronic_pulmonary_disease, chronic_pulmonary_disease_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `ulcer_disease_valueset_id, ulcer_disease_code, ulcer_disease_system, ulcer_disease, ulcer_disease_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `liver_disease_valueset_id, liver_disease_code, liver_disease_system, liver_disease, liver_disease_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `connective_tissue_disease_valueset_id, connective_tissue_disease_code, connective_tissue_disease_system, connective_tissue_disease, connective_tissue_disease_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `diabetes_mellitus_valueset_id, diabetes_mellitus_code, diabetes_mellitus_system, diabetes_mellitus, diabetes_mellitus_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `hemiplegia_valueset_id, hemiplegia_code, hemiplegia_system, hemiplegia, hemiplegia_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `moderate_or_severe_renal_disease_valueset_id, moderate_or_severe_renal_disease_code, moderate_or_severe_renal_disease_system, moderate_or_severe_renal_disease, moderate_or_severe_renal_disease_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `solid_tumor_valueset_id, solid_tumor_code, solid_tumor_system, solid_tumor, solid_tumor_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `leukemia_valueset_id, leukemia_code, leukemia_system, leukemia, leukemia_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `lymphoma_valueset_id, lymphoma_code, lymphoma_system, lymphoma, lymphoma_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `aids_valueset_id, aids_code, aids_system, aids, aids_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |

## Indexes

- `charlson_comorbidity_index_form_id_idx` on `form_id`

## Value sets

| Value set | Codes |
|---|---|
| `org.openehr::openEHR-EHR-OBSERVATION.charlson_comorbidity_index.v2/age_group` | 5 |
| `org.openehr::openEHR-EHR-OBSERVATION.charlson_comorbidity_index.v2/aids` | 2 |
| `org.openehr::openEHR-EHR-OBSERVATION.charlson_comorbidity_index.v2/cerebrovascular_disease` | 2 |
| `org.openehr::openEHR-EHR-OBSERVATION.charlson_comorbidity_index.v2/chronic_pulmonary_disease` | 2 |
| `org.openehr::openEHR-EHR-OBSERVATION.charlson_comorbidity_index.v2/congestive_heart_failure` | 2 |
| `org.openehr::openEHR-EHR-OBSERVATION.charlson_comorbidity_index.v2/connective_tissue_disease` | 2 |
| `org.openehr::openEHR-EHR-OBSERVATION.charlson_comorbidity_index.v2/dementia` | 2 |
| `org.openehr::openEHR-EHR-OBSERVATION.charlson_comorbidity_index.v2/diabetes_mellitus` | 3 |
| `org.openehr::openEHR-EHR-OBSERVATION.charlson_comorbidity_index.v2/hemiplegia` | 2 |
| `org.openehr::openEHR-EHR-OBSERVATION.charlson_comorbidity_index.v2/leukemia` | 2 |
| `org.openehr::openEHR-EHR-OBSERVATION.charlson_comorbidity_index.v2/liver_disease` | 3 |
| `org.openehr::openEHR-EHR-OBSERVATION.charlson_comorbidity_index.v2/lymphoma` | 2 |
| `org.openehr::openEHR-EHR-OBSERVATION.charlson_comorbidity_index.v2/moderate_or_severe_renal_disease` | 2 |
| `org.openehr::openEHR-EHR-OBSERVATION.charlson_comorbidity_index.v2/myocardial_infarction` | 2 |
| `org.openehr::openEHR-EHR-OBSERVATION.charlson_comorbidity_index.v2/peripheral_vascular_disease` | 2 |
| `org.openehr::openEHR-EHR-OBSERVATION.charlson_comorbidity_index.v2/solid_tumor` | 3 |
| `org.openehr::openEHR-EHR-OBSERVATION.charlson_comorbidity_index.v2/ulcer_disease` | 2 |