Schema reference / Tables / view MDX source
pulse
The rate and associated attributes for a pulse or heart beat.
The rate and associated attributes for a pulse or heart beat.
Purpose. To record details about the rate and associated attributes for a pulse or heart beat.
Source
| Model | Leg | Role |
|---|---|---|
openEHR-EHR-OBSERVATION.pulse.v2 | 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. | — |
event_type | text | yes | null represents any_event | — |
presencepresence_codepresence_systempresence_valueset_id | coded texttext, text, text, text | yes | Presence | /data[at0002]/events[at0003]/data[at0001]/items[at1005] |
rate_magnituderate_units | quantitynumeric, text | yes | Rate | /data[at0002]/events[at0003]/data[at0001]/items[at0004] |
regularityregularity_coderegularity_systemregularity_valueset_id | coded texttext, text, text, text | yes | Regularity | /data[at0002]/events[at0003]/data[at0001]/items[at0005] |
irregular_typeirregular_type_codeirregular_type_systemirregular_type_valueset_id | coded texttext, text, text, text | yes | Irregular type | /data[at0002]/events[at0003]/data[at0001]/items[at1055] |
charactercharacter_codecharacter_systemcharacter_valueset_id | coded texttext, text, text, text | yes | Character | /data[at0002]/events[at0003]/data[at0001]/items[at1030] |
clinical_description | text | yes | Clinical description | /data[at0002]/events[at0003]/data[at0001]/items[at1022] |
clinical_interpretationclinical_interpretation_codeclinical_interpretation_systemclinical_interpretation_valueset_id | coded texttext, text, text, text | yes | Clinical interpretation | /data[at0002]/events[at0003]/data[at0001]/items[at1023] |
comment | text | yes | Comment | /data[at0002]/events[at0003]/data[at0001]/items[at1059] |
positionposition_codeposition_systemposition_valueset_id | coded texttext, text, text, text | yes | Position | /data[at0002]/events[at0003]/state[at0012]/items[at0013] |
confounding_factors | text | yes | Confounding factors | /data[at0002]/events[at0003]/state[at0012]/items[at1018] |
methodmethod_codemethod_systemmethod_valueset_id | coded texttext, text, text, text | yes | Method | /protocol[at0010]/items[at1019] |
body_sitebody_site_codebody_site_systembody_site_valueset_id | coded texttext, text, text, text | yes | Body site | /protocol[at0010]/items[at1037] |
device | uuid | yes | Device | /protocol[at0010]/items[at1013] |
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 1000))
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 ((irregular_type_code is null and irregular_type_system is null and irregular_type_valueset_id is null and irregular_type is null) or (irregular_type is not null and irregular_type_code is not null and irregular_type_system is not null and irregular_type_valueset_id is not null))
check ((character_code is null and character_system is null and character_valueset_id is null) or (character is not null and character_code is not null and character_system is not null and character_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 ((position_code is null and position_system is null and position_valueset_id is null and position is null) or (position is not null and position_code is not null and position_system is not null and position_valueset_id is not null))
check ((method_code is null and method_system is null and method_valueset_id is null and method is null) or (method is not null and method_code is not null and method_system is not null and method_valueset_id is not null))
check ((body_site_code is null and body_site_system is null and body_site_valueset_id is null) or (body_site is not null and body_site_code is not null and body_site_system is not null and body_site_valueset_id is not null))Unique
form_block_id
References
| Columns | Target | On delete |
|---|---|---|
form_id | form | cascade |
form_id, form_block_id | form_block | cascade |
presence_valueset_id, presence_code, presence_system, presence | valueset_code | restrict |
regularity_valueset_id, regularity_code, regularity_system, regularity | valueset_code | restrict |
irregular_type_valueset_id, irregular_type_code, irregular_type_system, irregular_type | valueset_code | restrict |
character_valueset_id, character_code, character_system, character | valueset_code | restrict |
clinical_interpretation_valueset_id, clinical_interpretation_code, clinical_interpretation_system, clinical_interpretation | valueset_code | restrict |
position_valueset_id, position_code, position_system, position | valueset_code | restrict |
method_valueset_id, method_code, method_system, method | valueset_code | restrict |
body_site_valueset_id, body_site_code, body_site_system, body_site | valueset_code | restrict |
device | device | no action |
Indexes
pulse_form_id_idxonform_idpulse_device_idxondevice
Value sets
| Value set | Codes |
|---|---|
org.openehr::openEHR-EHR-OBSERVATION.pulse.v2/body_site | 12 |
org.openehr::openEHR-EHR-OBSERVATION.pulse.v2/irregular_type | 2 |
org.openehr::openEHR-EHR-OBSERVATION.pulse.v2/method | 4 |
org.openehr::openEHR-EHR-OBSERVATION.pulse.v2/position | 4 |
org.openehr::openEHR-EHR-OBSERVATION.pulse.v2/presence | 2 |
org.openehr::openEHR-EHR-OBSERVATION.pulse.v2/regularity | 2 |