Schema reference / Tables / view MDX source

fluid_input

The amount of fluid ingested or administered to the individual.

Purpose. To record details of measured fluid input, often used as part of fluid balance calculation.

Source

Model	Leg	Role
`openEHR-EHR-OBSERVATION.fluid_input.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]`
`route` `route_code` `route_system` `route_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Route	`/data[at0001]/events[at0002]/data[at0003]/items[at0034]`
`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]`
`input_device`	`uuid`	yes	Input 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 ((route_code is null and route_system is null and route_valueset_id is null) or (route is not null and route_code is not null and route_system is not null and route_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
`route_valueset_id, route_code, route_system, route`	`valueset_code`	restrict
`method_valueset_id, method_code, method_system, method`	`valueset_code`	restrict
`input_device`	`device`	no action
`measurement_device`	`device`	no action

Indexes

fluid_input_form_id_idx on form_id
fluid_input_input_device_idx on input_device
fluid_input_measurement_device_idx on measurement_device

Value sets

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