Schema reference / Tables / view MDX source

fluid_output

The measurement of fluid lost or excreted from the body via any mechanism.

Purpose. To record details about measured fluids lost or excreted via any mechanism.

Source

Model	Leg	Role
`openEHR-EHR-OBSERVATION.fluid_output.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.	—
`fluid_name` `fluid_name_code` `fluid_name_system` `fluid_name_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Fluid name	`/data[at0001]/events[at0002]/data[at0003]/items[at0036]`
`source` `source_code` `source_system` `source_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Source	`/data[at0001]/events[at0002]/data[at0003]/items[at0041]`
`volume_magnitude` `volume_units`	quantity `numeric`, `text`	yes	Volume	`/data[at0001]/events[at0002]/data[at0003]/items[at0035]`
`comment`	`text`	yes	Comment	`/data[at0001]/events[at0002]/data[at0003]/items[at0032]`
`method` `method_code` `method_system` `method_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Method	`/protocol[at0008]/items[at0031]`
`output_device`	`uuid`	yes	Output device	`/protocol[at0008]/items[at0033]`
`measurement_device`	`uuid`	yes	Measurement device	`/protocol[at0008]/items[at0028]`

Constraints

check ((fluid_name_code is null and fluid_name_system is null and fluid_name_valueset_id is null) or (fluid_name is not null and fluid_name_code is not null and fluid_name_system is not null and fluid_name_valueset_id is not null))
check ((source_code is null and source_system is null and source_valueset_id is null) or (source is not null and source_code is not null and source_system is not null and source_valueset_id is not null))
check ((volume_magnitude is null and volume_units is null) or (volume_magnitude is not null and volume_units is not null))
check (volume_magnitude is null or (volume_units = 'ml' and volume_magnitude >= 0) or (volume_units = 'l' and volume_magnitude >= 0) or (volume_units = '[foz_us]' and volume_magnitude >= 0))
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))

Unique

form_block_id

References

Columns	Target	On delete
`form_id`	`form`	cascade
`form_id, form_block_id`	`form_block`	cascade
`fluid_name_valueset_id, fluid_name_code, fluid_name_system, fluid_name`	`valueset_code`	restrict
`source_valueset_id, source_code, source_system, source`	`valueset_code`	restrict
`method_valueset_id, method_code, method_system, method`	`valueset_code`	restrict
`output_device`	`device`	no action
`measurement_device`	`device`	no action

Indexes

fluid_output_form_id_idx on form_id
fluid_output_output_device_idx on output_device
fluid_output_measurement_device_idx on measurement_device

Value sets

Value set	Codes
`org.openehr::openEHR-EHR-OBSERVATION.fluid_output.v1/method`	2