Schema reference / Tables / view MDX source
inspired_oxygen
The amount of oxygen being delivered, or to be delivered, to the patient given as a fraction, percentage or indirectly as a flow rate.
The amount of oxygen being delivered, or to be delivered, to the patient given as a fraction, percentage or indirectly as a flow rate.
Purpose. To record the amount of oxygen available in the air the subject inspires at the time of observation, or the amount of oxygen that is to be delivered, if part of an order.
Source
| Model | Leg | Role |
|---|---|---|
openEHR-EHR-CLUSTER.inspired_oxygen.v1 | openEHR | defines this table |
Columns
| Column | Type | Null | Description | Source |
|---|---|---|---|---|
id | uuid primary key | no | Primary key. | — |
flow_rate_magnitudeflow_rate_units | quantitynumeric, text | yes | Flow rate | /items[at0051] |
fi_o2_numeratorfi_o2_denominator | numeric, numericnumeric, numeric | yes | FiO₂ | /items[at0052] |
percent_o2_numeratorpercent_o2_denominator | numeric, numericnumeric, numeric | yes | Percent O₂ | /items[at0053] |
on_air | boolean | yes | On air | /items[at0057] |
method_of_oxygen_delivery | text | yes | Method of oxygen delivery | /items[at0054] |
Constraints
check ((flow_rate_magnitude is null and flow_rate_units is null) or (flow_rate_magnitude is not null and flow_rate_units is not null))
check (flow_rate_magnitude is null or (flow_rate_units = 'ml/min' and flow_rate_magnitude between 0 and 50000) or (flow_rate_units = 'l/min' and flow_rate_magnitude between 0 and 50))
check ((fi_o2_numerator is null and fi_o2_denominator is null) or (fi_o2_numerator is not null and fi_o2_denominator is not null))
check (fi_o2_denominator is null or fi_o2_denominator <> 0)
check (fi_o2_denominator is null or fi_o2_denominator = 1)
check (fi_o2_numerator is null or fi_o2_numerator between 0 and 1)
check ((percent_o2_numerator is null and percent_o2_denominator is null) or (percent_o2_numerator is not null and percent_o2_denominator is not null))
check (percent_o2_denominator is null or percent_o2_denominator <> 0)
check (percent_o2_denominator is null or percent_o2_denominator = 100)
check (percent_o2_numerator is null or percent_o2_numerator between 0 and 100)Referenced by
pulse_oximetryviainspired_oxygenrespirationviainspired_oxygen