Schema reference / Tables / view MDX source

occupation_summary

Summary or persistent information about an individual's current and past jobs and/or roles.

Purpose. To record a summary or persistent information about an individual's current and past jobs and/or roles.

Source

Model	Leg	Role
`openEHR-EHR-EVALUATION.occupation_summary.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.	—
`description`	`text`	yes	Description	`/data[at0001]/items[at0002]`
`employment_status` `employment_status_code` `employment_status_system` `employment_status_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Employment status	`/data[at0001]/items[at0004]`
`comment`	`text`	yes	Comment	`/data[at0001]/items[at0006]`
`last_updated`	`timestamptz`	yes	Last updated	`/protocol[at0007]/items[at0009]`

Constraints

check ((employment_status_code is null and employment_status_system is null and employment_status_valueset_id is null) or (employment_status is not null and employment_status_code is not null and employment_status_system is not null and employment_status_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
`employment_status_valueset_id, employment_status_code, employment_status_system, employment_status`	`valueset_code`	restrict

Referenced by

occupation_summary_occupation_episode via occupation_summary_id

Indexes

occupation_summary_form_id_idx on form_id

Child tables

1 table hang off occupation_summary, one row per repetition.

`occupation_summary_occupation_episode`

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

Column	Type	Null	Description	Source
`id`	`uuid primary key`	no	Primary key.	—
`occupation_summary_id`	`uuid` → `occupation_summary`	no	—	—
`position`	`integer`	no	Order of this row within its parent, from zero.	—
`occupation_record_id`	`uuid`	no	Occupation episode	`/data[at0001]/items[at0003]`

Unique

occupation_summary_id, position
occupation_summary_id, occupation_record_id

References

Columns	Target	On delete
`occupation_summary_id`	`occupation_summary`	cascade
`occupation_record_id`	`occupation_record`	no action

Indexes

occupation_summary_occupation_episode_occupation_record_id_idx on occupation_record_id