travel_screening

Series of questions and associated answers used to screen for movement to or from one or more geographic locations outside of the individual’s usual place of residence.

Series of questions and associated answers used to screen for movement to or from one or more geographic locations outside of the individual’s usual place of residence.

Purpose. To create a framework for recording answers to pre-defined screening questions about movement to or from one or more geographic locations outside of the individual’s usual place ofresidence.

Source

Columns

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

Referenced by

• travel_screening_specific_travel via travel_screening_id

Indexes

• travel_screening_form_id_idx on form_id

Child tables

1 table hang off travel_screening, one row per repetition.

travel_screening_specific_travel

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

Constraints

check ((travel_activity_code is null and travel_activity_system is null and travel_activity_valueset_id is null) or (travel_activity is not null and travel_activity_code is not null and travel_activity_system is not null and travel_activity_valueset_id is not null))

Unique

• travel_screening_id, position

References

Value sets