Schema reference / Tables / view MDX source

qsofa_score

Quick Sepsis-related Organ Failure Assessment (qSOFA) is a simplified version of the SOFA score, which is used outside intensive care units to quickly assess sepsis risk in adults.

Purpose. To record qSOFA answers and score.

Source

Model	Leg	Role
`openEHR-EHR-OBSERVATION.qsofa_score.v1`	openEHR	defines this table

Columns

Column	Type	Null	Description	Source
`id`	`uuid primary key`	no	Primary key.	—
`form_id`	`uuid` → `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.	—
`respiratory_rate` `respiratory_rate_code` `respiratory_rate_system` `respiratory_rate_numeric` `respiratory_rate_valueset_id`	coded text `text`, `text`, `text`, `numeric`, `text`	yes	Respiratory rate	`/data[at0001]/events[at0002]/data[at0003]/items[at0006]`
`blood_pressure` `blood_pressure_code` `blood_pressure_system` `blood_pressure_numeric` `blood_pressure_valueset_id`	coded text `text`, `text`, `text`, `numeric`, `text`	yes	Blood pressure	`/data[at0001]/events[at0002]/data[at0003]/items[at0007]`
`mental_status` `mental_status_code` `mental_status_system` `mental_status_numeric` `mental_status_valueset_id`	coded text `text`, `text`, `text`, `numeric`, `text`	yes	Mental status	`/data[at0001]/events[at0002]/data[at0003]/items[at0008]`
`q_sofa_score`	`integer`	yes	qSOFA score	`/data[at0001]/events[at0002]/data[at0003]/items[at0005]`
`comment`	`text`	yes	Comment	`/data[at0001]/events[at0002]/data[at0003]/items[at0004]`

Constraints

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 ((mental_status_code is null and mental_status_system is null and mental_status_numeric is null and mental_status is null) or (mental_status_valueset_id is not null and mental_status_code is not null and mental_status_system is not null and mental_status_numeric is not null and mental_status is not null))
check (q_sofa_score is null or q_sofa_score between 0 and 3)

Unique

form_block_id

References

Columns	Target	On delete
`form_id`	`form`	cascade
`form_id, form_block_id`	`form_block`	cascade
`respiratory_rate_valueset_id, respiratory_rate_code, respiratory_rate_system, respiratory_rate, respiratory_rate_numeric`	`valueset_code`	restrict
`blood_pressure_valueset_id, blood_pressure_code, blood_pressure_system, blood_pressure, blood_pressure_numeric`	`valueset_code`	restrict
`mental_status_valueset_id, mental_status_code, mental_status_system, mental_status, mental_status_numeric`	`valueset_code`	restrict

Indexes

qsofa_score_form_id_idx on form_id

Value sets

Value set	Codes
`org.openehr::openEHR-EHR-OBSERVATION.qsofa_score.v1/blood_pressure`	2
`org.openehr::openEHR-EHR-OBSERVATION.qsofa_score.v1/mental_status`	2
`org.openehr::openEHR-EHR-OBSERVATION.qsofa_score.v1/respiratory_rate`	2