respiration

The characteristics of spontaneous breathing by an individual.

The characteristics of spontaneous breathing by an individual.

Purpose. To record the characteristics of spontaneous breathing by an individual.

Source

ModelLegRole
openEHR-EHR-OBSERVATION.respiration.v2openEHRdefines this table

Columns

ColumnTypeNullDescriptionSource
iduuid primary keynoPrimary key.
form_iduuidformnoThe form this entry was recorded on.
form_block_iduuidyesThe block within the form, when the entry is bound to one.
presence
presence_code
presence_system
presence_valueset_id
coded text
text, text, text, text
yesPresence/data[at0001]/events[at0002]/data[at0003]/items[at0062]
rate_magnitude
rate_units
quantity
numeric, text
yesRate/data[at0001]/events[at0002]/data[at0003]/items[at0004]
regularity
regularity_code
regularity_system
regularity_valueset_id
coded text
text, text, text, text
yesRegularity/data[at0001]/events[at0002]/data[at0003]/items[at0005]
depth
depth_code
depth_system
depth_valueset_id
coded text
text, text, text, text
yesDepth/data[at0001]/events[at0002]/data[at0003]/items[at0016]
clinical_descriptiontextyesClinical description/data[at0001]/events[at0002]/data[at0003]/items[at0024]
clinical_interpretation
clinical_interpretation_code
clinical_interpretation_system
clinical_interpretation_valueset_id
coded text
text, text, text, text
yesClinical interpretation/data[at0001]/events[at0002]/data[at0003]/items[at0009]
commenttextyesComment/data[at0001]/events[at0002]/data[at0003]/items[at0070]
body_position
body_position_code
body_position_system
body_position_valueset_id
coded text
text, text, text, text
yesBody position/data[at0001]/events[at0002]/state[at0022]/items[at0065]
confounding_factorstextyesConfounding factors/data[at0001]/events[at0002]/state[at0022]/items[at0056]
inspired_oxygenuuidyesInspired oxygen/data[at0001]/events[at0002]/state[at0022]/items[at0055]

Constraints

check ((presence_code is null and presence_system is null and presence_valueset_id is null and presence is null) or (presence is not null and presence_code is not null and presence_system is not null and presence_valueset_id is not null))
check ((rate_magnitude is null and rate_units is null) or (rate_magnitude is not null and rate_units is not null))
check (rate_magnitude is null or (rate_units = '/min' and rate_magnitude between 0 and 200))
check ((regularity_code is null and regularity_system is null and regularity_valueset_id is null and regularity is null) or (regularity is not null and regularity_code is not null and regularity_system is not null and regularity_valueset_id is not null))
check ((depth_code is null and depth_system is null and depth_valueset_id is null and depth is null) or (depth is not null and depth_code is not null and depth_system is not null and depth_valueset_id is not null))
check ((clinical_interpretation_code is null and clinical_interpretation_system is null and clinical_interpretation_valueset_id is null) or (clinical_interpretation is not null and clinical_interpretation_code is not null and clinical_interpretation_system is not null and clinical_interpretation_valueset_id is not null))
check ((body_position_code is null and body_position_system is null and body_position_valueset_id is null and body_position is null) or (body_position is not null and body_position_code is not null and body_position_system is not null and body_position_valueset_id is not null))

Unique

References

ColumnsTargetOn delete
form_idformcascade
form_id, form_block_idform_blockcascade
presence_valueset_id, presence_code, presence_system, presencevalueset_coderestrict
regularity_valueset_id, regularity_code, regularity_system, regularityvalueset_coderestrict
depth_valueset_id, depth_code, depth_system, depthvalueset_coderestrict
clinical_interpretation_valueset_id, clinical_interpretation_code, clinical_interpretation_system, clinical_interpretationvalueset_coderestrict
body_position_valueset_id, body_position_code, body_position_system, body_positionvalueset_coderestrict
inspired_oxygeninspired_oxygenno action

Indexes

Value sets

Value setCodes
org.openehr::openEHR-EHR-OBSERVATION.respiration.v2/body_position5
org.openehr::openEHR-EHR-OBSERVATION.respiration.v2/depth4
org.openehr::openEHR-EHR-OBSERVATION.respiration.v2/presence2
org.openehr::openEHR-EHR-OBSERVATION.respiration.v2/regularity2