Schema reference / Tables / view MDX source

impairment_summary

Summary information about loss, limitation, deficit, or alteration of a body function or body structure.

Purpose. To record summary information about a single impairment affecting a body function or body structure.

Source

Model	Leg	Role
`openEHR-EHR-EVALUATION.impairment_summary.v0`	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.	—
`impairment_name` `impairment_name_code` `impairment_name_system` `impairment_name_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Impairment name	`/data[at0001]/items[at0002]`
`clinical_description`	`text`	yes	Clinical description	`/data[at0001]/items[at0018]`
`severity` `severity_code` `severity_system` `severity_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Severity	`/data[at0001]/items[at0003]`
`impact`	`text`	yes	Impact	`/data[at0001]/items[at0009]`
`trajectory` `trajectory_code` `trajectory_system` `trajectory_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Trajectory	`/data[at0001]/items[at0010]`
`date_of_onset`	`date`	yes	Date of onset	`/data[at0001]/items[at0016]`
`date_of_resolution`	`date`	yes	Date of resolution	`/data[at0001]/items[at0017]`
`comment`	`text`	yes	Comment	`/data[at0001]/items[at0020]`
`last_updated`	`timestamptz`	yes	Last updated	`/protocol[at0021]/items[at0023]`

Constraints

check ((impairment_name_code is null and impairment_name_system is null and impairment_name_valueset_id is null) or (impairment_name is not null and impairment_name_code is not null and impairment_name_system is not null and impairment_name_valueset_id is not null))
check ((severity_code is null and severity_system is null and severity_valueset_id is null) or (severity is not null and severity_code is not null and severity_system is not null and severity_valueset_id is not null))
check ((trajectory_code is null and trajectory_system is null and trajectory_valueset_id is null) or (trajectory is not null and trajectory_code is not null and trajectory_system is not null and trajectory_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
`impairment_name_valueset_id, impairment_name_code, impairment_name_system, impairment_name`	`valueset_code`	restrict
`severity_valueset_id, severity_code, severity_system, severity`	`valueset_code`	restrict
`trajectory_valueset_id, trajectory_code, trajectory_system, trajectory`	`valueset_code`	restrict

Indexes

impairment_summary_form_id_idx on form_id

Value sets

Value set	Codes
`org.openehr::openEHR-EHR-EVALUATION.impairment_summary.v0/severity`	5
`org.openehr::openEHR-EHR-EVALUATION.impairment_summary.v0/trajectory`	5