Schema reference / Tables / view MDX source

problem_screening

Series of questions and associated answers used to screen for issues, problems or diagnoses.

Purpose. To create a framework for recording answers to pre-defined screening questions about issues, problems or diagnoses.

Source

Model	Leg	Role
`openEHR-EHR-OBSERVATION.problem_screening.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.	—
`screening_purpose` `screening_purpose_code` `screening_purpose_system` `screening_purpose_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Screening purpose	`/data[at0001]/events[at0002]/data[at0003]/items[at0034]`
`any_problems_or_diagnoses`	`boolean`	yes	Any problems or diagnoses?	`/data[at0001]/events[at0002]/data[at0003]/items[at0028]`
`description`	`text`	yes	Description	`/data[at0001]/events[at0002]/data[at0003]/items[at0043]`

Constraints

check ((screening_purpose_code is null and screening_purpose_system is null and screening_purpose_valueset_id is null) or (screening_purpose is not null and screening_purpose_code is not null and screening_purpose_system is not null and screening_purpose_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
`screening_purpose_valueset_id, screening_purpose_code, screening_purpose_system, screening_purpose`	`valueset_code`	restrict

Referenced by

problem_screening_specific_problem_or_diagnosis via problem_screening_id

Indexes

problem_screening_form_id_idx on form_id

Child tables

2 tables hang off problem_screening, one row per repetition.

`problem_screening_specific_problem_or_diagnosis`

Child table — one row per repetition, deleted with its parent.

Column	Type	Null	Description	Source
`id`	`uuid primary key`	no	Primary key.	—
`problem_screening_id`	`uuid` → `problem_screening`	no	—	—
`position`	`integer`	no	Order of this row within its parent, from zero.	—
`problem_diagnosis_name` `problem_diagnosis_name_code` `problem_diagnosis_name_system` `problem_diagnosis_name_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Problem/diagnosis name	`/data[at0001]/events[at0002]/data[at0003]/items[at0022]/items[at0004]`
`presence`	`boolean`	yes	Presence?	`/data[at0001]/events[at0002]/data[at0003]/items[at0022]/items[at0005]`
`timing`	`timestamptz`	yes	Timing	`/data[at0001]/events[at0002]/data[at0003]/items[at0022]/items[at0040]`
`comment`	`text`	yes	Comment	`/data[at0001]/events[at0002]/data[at0003]/items[at0022]/items[at0025]`

Constraints

check ((problem_diagnosis_name_code is null and problem_diagnosis_name_system is null and problem_diagnosis_name_valueset_id is null) or (problem_diagnosis_name is not null and problem_diagnosis_name_code is not null and problem_diagnosis_name_system is not null and problem_diagnosis_name_valueset_id is not null))

Unique

problem_screening_id, position

References

Columns	Target	On delete
`problem_screening_id`	`problem_screening`	cascade
`problem_diagnosis_name_valueset_id, problem_diagnosis_name_code, problem_diagnosis_name_system, problem_diagnosis_name`	`valueset_code`	restrict

Referenced by

problem_screening_specific_problem_or_diagnosis_addition_3d2464 via problem_screening_specific_problem_or_diagnosis_id

`problem_screening_specific_problem_or_diagnosis_addition_3d2464`

Child table — one row per repetition, deleted with its parent.

Column	Type	Null	Description	Source
`id`	`uuid primary key`	no	Primary key.	—
`problem_screening_specific_problem_or_diagnosis_id`	`uuid` → `problem_screening_specific_problem_or_diagnosis`	no	—	—
`position`	`integer`	no	Order of this row within its parent, from zero.	—
`organization_id`	`uuid`	no	Additional details	`/data[at0001]/events[at0002]/data[at0003]/items[at0022]/items[at0039]`

Unique

problem_screening_specific_problem_or_diagnosis_id, position
problem_screening_specific_problem_or_diagnosis_id, organization_id

References

Columns	Target	On delete
`problem_screening_specific_problem_or_diagnosis_id`	`problem_screening_specific_problem_or_diagnosis`	cascade
`organization_id`	`organization`	no action

Indexes

problem_screening_specific_problem_or_diagnosis_addition_b137d0 on organization_id