Schema reference / Tables / view MDX source

exclusion_specific

A statement of exclusion of a specific Problem/diagnosis, Family history, Medication, Procedure, Adverse reaction or other clinical item that is either not currently present, or h…

A statement of exclusion of a specific Problem/diagnosis, Family history, Medication, Procedure, Adverse reaction or other clinical item that is either not currently present, or have not been present in the past.

Purpose. To record a statement of exclusion about a specific Problem/diagnosis, Family history, Medication, Procedure, Adverse reaction or other clinical item that is either not currently present, or have not been present in the past.

Source

Model	Leg	Role
`openEHR-EHR-EVALUATION.exclusion_specific.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.	—
`exclusion_statement`	`text`	yes	Exclusion statement	`/data[at0001]/items[at0002]`
`excluded_concept` `excluded_concept_code` `excluded_concept_system` `excluded_concept_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Excluded concept	`/data[at0001]/items[at0003]`
`comment`	`text`	yes	Comment	`/data[at0001]/items[at0012]`

Constraints

check ((excluded_concept_code is null and excluded_concept_system is null and excluded_concept_valueset_id is null) or (excluded_concept is not null and excluded_concept_code is not null and excluded_concept_system is not null and excluded_concept_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
`excluded_concept_valueset_id, excluded_concept_code, excluded_concept_system, excluded_concept`	`valueset_code`	restrict

Indexes

exclusion_specific_form_id_idx on form_id