procedure

A clinical activity carried out for screening, investigative, diagnostic, curative, therapeutic, evaluative or palliative purposes.

A clinical activity carried out for screening, investigative, diagnostic, curative, therapeutic, evaluative or palliative purposes.

Purpose. To record information about the activities required to carry out a procedure, including the planning, scheduling, performance, suspension, cancellation, documentation and completion.

Source

Columns

Constraints

check ((procedure_name_code is null and procedure_name_system is null and procedure_name_valueset_id is null) or (procedure_name is not null and procedure_name_code is not null and procedure_name_system is not null and procedure_name_valueset_id is not null))
check ((indication_code is null and indication_system is null and indication_valueset_id is null) or (indication is not null and indication_code is not null and indication_system is not null and indication_valueset_id is not null))
check ((intent_code is null and intent_system is null and intent_valueset_id is null) or (intent is not null and intent_code is not null and intent_system is not null and intent_valueset_id is not null))
check ((urgency_code is null and urgency_system is null and urgency_valueset_id is null) or (urgency is not null and urgency_code is not null and urgency_system is not null and urgency_valueset_id is not null))
check ((impact_code is null and impact_system is null and impact_valueset_id is null) or (impact is not null and impact_code is not null and impact_system is not null and impact_valueset_id is not null))
check ((outcome_code is null and outcome_system is null and outcome_valueset_id is null) or (outcome is not null and outcome_code is not null and outcome_system is not null and outcome_valueset_id is not null))
check ((procedure_type_code is null and procedure_type_system is null and procedure_type_valueset_id is null) or (procedure_type is not null and procedure_type_code is not null and procedure_type_system is not null and procedure_type_valueset_id is not null))
check (requestor_order_identifier_system is null or requestor_order_identifier_value is not null)
check (receiver_order_identifier_system is null or receiver_order_identifier_value is not null)

Unique

• form_block_id

References

Referenced by

• procedure_procedure_detail via procedure_id
• procedure_multimedia via procedure_id

Indexes

• procedure_form_id_idx on form_id

Child tables

2 tables hang off procedure, one row per repetition.

procedure_procedure_detail

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

Constraints

check (num_nonnulls(anatomical_location_id, anatomical_location_circle_id, anatomical_location_relative_id, device_id) = 1)

Unique

• procedure_id, position

References

Indexes

• procedure_procedure_detail_anatomical_location_id_idx on anatomical_location_id
• procedure_procedure_detail_anatomical_location_circle_id_idx on anatomical_location_circle_id
• procedure_procedure_detail_anatomical_location_relative_id_idx on anatomical_location_relative_id
• procedure_procedure_detail_device_id_idx on device_id

procedure_multimedia

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

Unique

• procedure_id, position
• procedure_id, attachment_id

References

Indexes

• procedure_multimedia_attachment_id_idx on attachment_id