imaging_exam_result

The result of an imaging examination performed on an individual, using radiological techniques.

The result of an imaging examination performed on an individual, using radiological techniques.

Purpose. To record the findings on imaging examination of a specified body structure or region and their interpretation, using radiological techniques.

Source

Columns

Constraints

check ((study_name_code is null and study_name_system is null and study_name_valueset_id is null) or (study_name is not null and study_name_code is not null and study_name_system is not null and study_name_valueset_id is not null))
check ((modality_code is null and modality_system is null and modality_valueset_id is null) or (modality is not null and modality_code is not null and modality_system is not null and modality_valueset_id is not null))
check ((target_body_site_code is null and target_body_site_system is null and target_body_site_valueset_id is null) or (target_body_site is not null and target_body_site_code is not null and target_body_site_system is not null and target_body_site_valueset_id is not null))
check ((overall_result_status_code is null and overall_result_status_system is null and overall_result_status_valueset_id is null) or (overall_result_status is not null and overall_result_status_code is not null and overall_result_status_system is not null and overall_result_status_valueset_id is not null))
check ((imaging_quality_code is null and imaging_quality_system is null and imaging_quality_valueset_id is null) or (imaging_quality is not null and imaging_quality_code is not null and imaging_quality_system is not null and imaging_quality_valueset_id is not null))
check ((imaging_differential_diagnosis_code is null and imaging_differential_diagnosis_system is null and imaging_differential_diagnosis_valueset_id is null) or (imaging_differential_diagnosis is not null and imaging_differential_diagnosis_code is not null and imaging_differential_diagnosis_system is not null and imaging_differential_diagnosis_valueset_id is not null))
check ((imaging_diagnosis_code is null and imaging_diagnosis_system is null and imaging_diagnosis_valueset_id is null) or (imaging_diagnosis is not null and imaging_diagnosis_code is not null and imaging_diagnosis_system is not null and imaging_diagnosis_valueset_id is not null))
check ((position_code is null and position_system is null and position_valueset_id is null) or (position is not null and position_code is not null and position_system is not null and position_valueset_id is not null))
check (study_instance_identifier_system is null or study_instance_identifier_value is not null)
check (report_identifier_system is null or report_identifier_value is not null)
check ((study_status_code is null and study_status_system is null and study_status_valueset_id is null) or (study_status is not null and study_status_code is not null and study_status_system is not null and study_status_valueset_id is not null))
check ((technique_code is null and technique_system is null and technique_valueset_id is null) or (technique is not null and technique_code is not null and technique_system is not null and technique_valueset_id is not null))
check (num_nonnulls(distribution_list_organization, distribution_list_person) <= 1)

Unique

• form_block_id

References

Referenced by

• imaging_exam_result_structured_target_body_site via imaging_exam_result_id
• imaging_exam_result_structured_imaging_findings via imaging_exam_result_id
• imaging_exam_result_report_representation via imaging_exam_result_id
• imaging_exam_result_stabilising_appliance via imaging_exam_result_id
• imaging_exam_result_imaging_service via imaging_exam_result_id
• imaging_exam_result_device via imaging_exam_result_id
• imaging_exam_result_comparison_study_details via imaging_exam_result_id
• imaging_exam_result_examination_request_details via imaging_exam_result_id

Indexes

• imaging_exam_result_form_id_idx on form_id
• imaging_exam_result_distribution_list_organization_idx on distribution_list_organization
• imaging_exam_result_distribution_list_person_idx on distribution_list_person

Child tables

9 tables hang off imaging_exam_result, one row per repetition.

imaging_exam_result_structured_target_body_site

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

Unique

• imaging_exam_result_id, position
• imaging_exam_result_id, anatomical_location_id

References

Indexes

• imaging_exam_result_structured_target_body_site_anatomic_8f6f59 on anatomical_location_id

imaging_exam_result_structured_imaging_findings

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

Constraints

check (num_nonnulls(imaging_exam_id, imaging_exam_cervix_id, imaging_exam_fallopian_tube_id, imaging_exam_foetus_id, imaging_exam_gestational_sac_id, imaging_exam_hip_joint_id, imaging_exam_ovary_id, imaging_exam_rectouterine_pouch_id) = 1)

Unique

• imaging_exam_result_id, position

References

Indexes

• imaging_exam_result_structured_imaging_findings_imaging__13aaab on imaging_exam_id
• imaging_exam_result_structured_imaging_findings_imaging__d4c509 on imaging_exam_cervix_id
• imaging_exam_result_structured_imaging_findings_imaging__19f0ab on imaging_exam_fallopian_tube_id
• imaging_exam_result_structured_imaging_findings_imaging__82f9b5 on imaging_exam_foetus_id
• imaging_exam_result_structured_imaging_findings_imaging__8e77c2 on imaging_exam_gestational_sac_id
• imaging_exam_result_structured_imaging_findings_imaging__362201 on imaging_exam_hip_joint_id
• imaging_exam_result_structured_imaging_findings_imaging__250b35 on imaging_exam_ovary_id
• imaging_exam_result_structured_imaging_findings_imaging__d3c126 on imaging_exam_rectouterine_pouch_id

imaging_exam_result_report_representation

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

Unique

• imaging_exam_result_id, position
• imaging_exam_result_id, attachment_id

References

Indexes

• imaging_exam_result_report_representation_attachment_id_idx on attachment_id

imaging_exam_result_stabilising_appliance

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

Unique

• imaging_exam_result_id, position
• imaging_exam_result_id, device_id

References

Indexes

• imaging_exam_result_stabilising_appliance_device_id_idx on device_id

imaging_exam_result_imaging_service

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

Unique

• imaging_exam_result_id, position
• imaging_exam_result_id, organization_id

References

Indexes

• imaging_exam_result_imaging_service_organization_id_idx on organization_id

imaging_exam_result_device

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

Unique

• imaging_exam_result_id, position
• imaging_exam_result_id, device_id

References

Indexes

• imaging_exam_result_device_device_id_idx on device_id

imaging_exam_result_comparison_study_details

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

Constraints

check (study_identifier_system is null or study_identifier_value is not null)

Unique

• imaging_exam_result_id, position

References

imaging_exam_result_examination_request_details

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

Constraints

check (receiver_order_identifier_system is null or receiver_order_identifier_value is not null)
check (requester_order_identifier_system is null or requester_order_identifier_value is not null)

Unique

• imaging_exam_result_id, position

References

Referenced by

• imaging_exam_result_examination_request_details_requester via imaging_exam_result_examination_request_details_id

imaging_exam_result_examination_request_details_requester

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

Constraints

check (num_nonnulls(organization_id, person_id) = 1)

Unique

• imaging_exam_result_examination_request_details_id, position

References

Indexes

• imaging_exam_result_examination_request_details_requeste_bee8fb on organization_id
• imaging_exam_result_examination_request_details_requeste_5a8303 on person_id

Value sets