--- title: "qsofa_score" description: "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." --- 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`](/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. | — | | `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 ```sql 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`](/docs/tables/form) | cascade | | `form_id, form_block_id` | [`form_block`](/docs/tables/form_block) | cascade | | `respiratory_rate_valueset_id, respiratory_rate_code, respiratory_rate_system, respiratory_rate, respiratory_rate_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict | | `blood_pressure_valueset_id, blood_pressure_code, blood_pressure_system, blood_pressure, blood_pressure_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict | | `mental_status_valueset_id, mental_status_code, mental_status_system, mental_status, mental_status_numeric` | [`valueset_code`](/docs/tables/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 |