specimen

A physical sample collected from, or related to, an individual for the purpose of investigation, examination or analysis.

A physical sample collected from, or related to, an individual for the purpose of investigation, examination or analysis.

Purpose. To record details about a physical sample collected from, or related to, an individual for the purpose of investigation, examination or analysis.

Source

Columns

Constraints

check ((specimen_type_code is null and specimen_type_system is null and specimen_type_valueset_id is null) or (specimen_type is not null and specimen_type_code is not null and specimen_type_system is not null and specimen_type_valueset_id is not null))
check (laboratory_specimen_identifier_system is null or laboratory_specimen_identifier_value is not null)
check (external_identifier_system is null or external_identifier_value is not null)
check ((sampling_context_code is null and sampling_context_system is null and sampling_context_valueset_id is null) or (sampling_context is not null and sampling_context_code is not null and sampling_context_system is not null and sampling_context_valueset_id is not null))
check ((collection_method_code is null and collection_method_system is null and collection_method_valueset_id is null) or (collection_method is not null and collection_method_code is not null and collection_method_system is not null and collection_method_valueset_id is not null))
check ((source_site_code is null and source_site_system is null and source_site_valueset_id is null) or (source_site is not null and source_site_code is not null and source_site_system is not null and source_site_valueset_id is not null))
check ((hazard_warning_code is null and hazard_warning_system is null and hazard_warning_valueset_id is null) or (hazard_warning is not null and hazard_warning_code is not null and hazard_warning_system is not null and hazard_warning_valueset_id is not null))
check ((collection_setting_code is null and collection_setting_system is null and collection_setting_valueset_id is null) or (collection_setting is not null and collection_setting_code is not null and collection_setting_system is not null and collection_setting_valueset_id is not null))
check (specimen_collector_identifier_system is null or specimen_collector_identifier_value is not null)
check (number_of_containers is null or number_of_containers >= 0)
check (parent_specimen_identifier_system is null or parent_specimen_identifier_value is not null)
check ((specimen_quality_issue_code is null and specimen_quality_issue_system is null and specimen_quality_issue_valueset_id is null) or (specimen_quality_issue is not null and specimen_quality_issue_code is not null and specimen_quality_issue_system is not null and specimen_quality_issue_valueset_id is not null))
check ((adequacy_for_testing_code is null and adequacy_for_testing_system is null and adequacy_for_testing_valueset_id is null) or (adequacy_for_testing is not null and adequacy_for_testing_code is not null and adequacy_for_testing_system is not null and adequacy_for_testing_valueset_id is not null))

References

Referenced by

• investigation_screening_specific_investigation_additiona_45e74e via specimen_id
• laboratory_test_result_specimen_detail via specimen_id
• specimen_structured_source_site via specimen_id
• specimen_specimen_collector_details via specimen_id
• specimen_container_details via specimen_id
• specimen_digital_representation via specimen_id
• specimen_container_contents via specimen_id
• specimen_summary_specimen_details via specimen_id

Child tables

4 tables hang off specimen, one row per repetition.

specimen_structured_source_site

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) = 1)

Unique

• specimen_id, position

References

Indexes

• specimen_structured_source_site_anatomical_location_id_idx on anatomical_location_id
• specimen_structured_source_site_anatomical_location_circ_21cf7d on anatomical_location_circle_id
• specimen_structured_source_site_anatomical_location_rela_ce854e on anatomical_location_relative_id

specimen_specimen_collector_details

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

Constraints

check (num_nonnulls(organization_id, person_id) = 1)

Unique

• specimen_id, position

References

Indexes

• specimen_specimen_collector_details_organization_id_idx on organization_id
• specimen_specimen_collector_details_person_id_idx on person_id

specimen_container_details

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

Unique

• specimen_id, position
• specimen_id, specimen_container_id

References

Indexes

• specimen_container_details_specimen_container_id_idx on specimen_container_id

specimen_digital_representation

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

Unique

• specimen_id, position
• specimen_id, attachment_id

References

Indexes

• specimen_digital_representation_attachment_id_idx on attachment_id

Value sets