Schema reference / Tables / view MDX source

capillary_refill

Measurement of the time taken for color to return to an external capillary bed after pressure is applied to cause blanching.

Purpose. To record findings related to the capillary refill time.

Source

Model	Leg	Role
`openEHR-EHR-OBSERVATION.capillary_refill.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.	—
`refill_time_magnitude` `refill_time_units`	quantity `numeric`, `text`	yes	Refill time	`/data[at0001]/events[at0002]/data[at0003]/items[at0009]`
`clinical_interpretation` `clinical_interpretation_code` `clinical_interpretation_system` `clinical_interpretation_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Clinical interpretation	`/data[at0001]/events[at0002]/data[at0003]/items[at0005]`
`comment`	`text`	yes	Comment	`/data[at0001]/events[at0002]/data[at0003]/items[at0040]`
`confounding_factors`	`text`	yes	Confounding factors	`/data[at0001]/events[at0002]/state[at0021]/items[at0023]`
`location_of_measurement` `location_of_measurement_code` `location_of_measurement_system` `location_of_measurement_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Location of measurement	`/protocol[at0019]/items[at0024]`
`structured_measurement_location_anatomical_location`	`uuid`	yes	—	—
`structured_measurement_location_anatomical_location_relative`	`uuid`	yes	—	—
`measurement_method`	`text`	yes	Measurement method	`/protocol[at0019]/items[at0041]`
`device`	`uuid`	yes	Device	`/protocol[at0019]/items[at0037]`

Constraints

check ((refill_time_magnitude is null and refill_time_units is null) or (refill_time_magnitude is not null and refill_time_units is not null))
check (refill_time_magnitude is null or (refill_time_units = 's' and refill_time_magnitude between 0 and 20))
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 ((location_of_measurement_code is null and location_of_measurement_system is null and location_of_measurement_valueset_id is null) or (location_of_measurement is not null and location_of_measurement_code is not null and location_of_measurement_system is not null and location_of_measurement_valueset_id is not null))
check (num_nonnulls(structured_measurement_location_anatomical_location, structured_measurement_location_anatomical_location_relative) <= 1)

Unique

form_block_id

References

Columns	Target	On delete
`form_id`	`form`	cascade
`form_id, form_block_id`	`form_block`	cascade
`clinical_interpretation_valueset_id, clinical_interpretation_code, clinical_interpretation_system, clinical_interpretation`	`valueset_code`	restrict
`location_of_measurement_valueset_id, location_of_measurement_code, location_of_measurement_system, location_of_measurement`	`valueset_code`	restrict
`structured_measurement_location_anatomical_location`	`anatomical_location`	no action
`structured_measurement_location_anatomical_location_relative`	`anatomical_location_relative`	no action
`device`	`device`	no action

Indexes

capillary_refill_form_id_idx on form_id
capillary_refill_structured_measurement_location_anatomi_832616 on structured_measurement_location_anatomical_location
capillary_refill_structured_measurement_location_anatomi_15f439 on structured_measurement_location_anatomical_location_relative
capillary_refill_device_idx on device

Value sets

Value set	Codes
`org.openehr::openEHR-EHR-OBSERVATION.capillary_refill.v1/clinical_interpretation`	3