---
title: "revised_cardiac_risk_index"
description: "The Revised Cardiac Risk Index (RCRI) is a preoperative prediction tool to estimate the perioperative risk of major cardiac complications during non-cardiac surgery."
---

The Revised Cardiac Risk Index (RCRI) is a preoperative prediction tool to estimate the perioperative risk of major cardiac complications during non-cardiac surgery.

**Purpose.** To record the result for each component parameter, and their total sum and estimated risk for the Revised Cardiac Risk Index (RCRI).

## Source

| Model | Leg | Role |
|---|---|---|
| `openEHR-EHR-OBSERVATION.revised_cardiac_risk_index.v1` | 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. | — |
| `ischemic_heart_disease`<br />`ischemic_heart_disease_code`<br />`ischemic_heart_disease_system`<br />`ischemic_heart_disease_numeric`<br />`ischemic_heart_disease_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Ischemic heart disease | `/data[at0001]/events[at0002]/data[at0003]/items[at0007]` |
| `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[at0010]` |
| `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[at0013]` |
| `diabetes_mellitus_on_insulin`<br />`diabetes_mellitus_on_insulin_code`<br />`diabetes_mellitus_on_insulin_system`<br />`diabetes_mellitus_on_insulin_numeric`<br />`diabetes_mellitus_on_insulin_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Diabetes mellitus on insulin | `/data[at0001]/events[at0002]/data[at0003]/items[at0016]` |
| `elevated_serum_creatinine`<br />`elevated_serum_creatinine_code`<br />`elevated_serum_creatinine_system`<br />`elevated_serum_creatinine_numeric`<br />`elevated_serum_creatinine_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Elevated serum creatinine | `/data[at0001]/events[at0002]/data[at0003]/items[at0004]` |
| `high_risk_surgery`<br />`high_risk_surgery_code`<br />`high_risk_surgery_system`<br />`high_risk_surgery_numeric`<br />`high_risk_surgery_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | High risk surgery | `/data[at0001]/events[at0002]/data[at0003]/items[at0022]` |
| `total_score` | `integer` | yes | Total score | `/data[at0001]/events[at0002]/data[at0003]/items[at0026]` |
| `estimated_risk`<br />`estimated_risk_code`<br />`estimated_risk_system`<br />`estimated_risk_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Estimated risk | `/data[at0001]/events[at0002]/data[at0003]/items[at0027]` |

## Constraints

```sql
check ((ischemic_heart_disease_code is null and ischemic_heart_disease_system is null and ischemic_heart_disease_numeric is null and ischemic_heart_disease is null) or (ischemic_heart_disease_valueset_id is not null and ischemic_heart_disease_code is not null and ischemic_heart_disease_system is not null and ischemic_heart_disease_numeric is not null and ischemic_heart_disease 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 ((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 ((diabetes_mellitus_on_insulin_code is null and diabetes_mellitus_on_insulin_system is null and diabetes_mellitus_on_insulin_numeric is null and diabetes_mellitus_on_insulin is null) or (diabetes_mellitus_on_insulin_valueset_id is not null and diabetes_mellitus_on_insulin_code is not null and diabetes_mellitus_on_insulin_system is not null and diabetes_mellitus_on_insulin_numeric is not null and diabetes_mellitus_on_insulin is not null))
check ((elevated_serum_creatinine_code is null and elevated_serum_creatinine_system is null and elevated_serum_creatinine_numeric is null and elevated_serum_creatinine is null) or (elevated_serum_creatinine_valueset_id is not null and elevated_serum_creatinine_code is not null and elevated_serum_creatinine_system is not null and elevated_serum_creatinine_numeric is not null and elevated_serum_creatinine is not null))
check ((high_risk_surgery_code is null and high_risk_surgery_system is null and high_risk_surgery_numeric is null and high_risk_surgery is null) or (high_risk_surgery_valueset_id is not null and high_risk_surgery_code is not null and high_risk_surgery_system is not null and high_risk_surgery_numeric is not null and high_risk_surgery is not null))
check (total_score is null or total_score between 0 and 6)
check ((estimated_risk_code is null and estimated_risk_system is null and estimated_risk_valueset_id is null and estimated_risk is null) or (estimated_risk is not null and estimated_risk_code is not null and estimated_risk_system is not null and estimated_risk_valueset_id 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 |
| `ischemic_heart_disease_valueset_id, ischemic_heart_disease_code, ischemic_heart_disease_system, ischemic_heart_disease, ischemic_heart_disease_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 |
| `cerebrovascular_disease_valueset_id, cerebrovascular_disease_code, cerebrovascular_disease_system, cerebrovascular_disease, cerebrovascular_disease_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `diabetes_mellitus_on_insulin_valueset_id, diabetes_mellitus_on_insulin_code, diabetes_mellitus_on_insulin_system, diabetes_mellitus_on_insulin, diabetes_mellitus_on_insulin_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `elevated_serum_creatinine_valueset_id, elevated_serum_creatinine_code, elevated_serum_creatinine_system, elevated_serum_creatinine, elevated_serum_creatinine_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `high_risk_surgery_valueset_id, high_risk_surgery_code, high_risk_surgery_system, high_risk_surgery, high_risk_surgery_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `estimated_risk_valueset_id, estimated_risk_code, estimated_risk_system, estimated_risk` | [`valueset_code`](/docs/tables/valueset_code) | restrict |

## Indexes

- `revised_cardiac_risk_index_form_id_idx` on `form_id`

## Value sets

| Value set | Codes |
|---|---|
| `org.openehr::openEHR-EHR-OBSERVATION.revised_cardiac_risk_index.v1/cerebrovascular_disease` | 2 |
| `org.openehr::openEHR-EHR-OBSERVATION.revised_cardiac_risk_index.v1/congestive_heart_failure` | 2 |
| `org.openehr::openEHR-EHR-OBSERVATION.revised_cardiac_risk_index.v1/diabetes_mellitus_on_insulin` | 2 |
| `org.openehr::openEHR-EHR-OBSERVATION.revised_cardiac_risk_index.v1/elevated_serum_creatinine` | 2 |
| `org.openehr::openEHR-EHR-OBSERVATION.revised_cardiac_risk_index.v1/estimated_risk` | 4 |
| `org.openehr::openEHR-EHR-OBSERVATION.revised_cardiac_risk_index.v1/high_risk_surgery` | 2 |
| `org.openehr::openEHR-EHR-OBSERVATION.revised_cardiac_risk_index.v1/ischemic_heart_disease` | 2 |