crb_65

An assessment score used within a community or primary care setting to estimate the severity of community-acquired pneumonia.

An assessment score used within a community or primary care setting to estimate the severity of community-acquired pneumonia.

Purpose. To record the results for each component parameter and their total sum for the CRB-65 score.

Source

Columns

Constraints

check ((confusion_code is null and confusion_system is null and confusion_numeric is null and confusion is null) or (confusion_valueset_id is not null and confusion_code is not null and confusion_system is not null and confusion_numeric is not null and confusion is not null))
check ((respiratory_rate_code is null and respiratory_rate_system is null and respiratory_rate_numeric is null and respiratory_rate is null) or (respiratory_rate_valueset_id is not null and respiratory_rate_code is not null and respiratory_rate_system is not null and respiratory_rate_numeric is not null and respiratory_rate is not null))
check ((blood_pressure_code is null and blood_pressure_system is null and blood_pressure_numeric is null and blood_pressure is null) or (blood_pressure_valueset_id is not null and blood_pressure_code is not null and blood_pressure_system is not null and blood_pressure_numeric is not null and blood_pressure is not null))
check ((age_code is null and age_system is null and age_numeric is null and age is null) or (age_valueset_id is not null and age_code is not null and age_system is not null and age_numeric is not null and age is not null))
check (total_score is null or total_score between 0 and 4)
check ((grade_code is null and grade_system is null and grade_valueset_id is null and grade is null) or (grade is not null and grade_code is not null and grade_system is not null and grade_valueset_id is not null))

Unique

• form_block_id

References

Indexes

• crb_65_form_id_idx on form_id

Value sets