revised_cardiac_risk_index

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

Columns

Constraints

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

Indexes

• revised_cardiac_risk_index_form_id_idx on form_id

Value sets