Table name: specimen
Reading from stem_table
Destination Field | Source field | Logic | Comment field |
specimen_id | id | | |
person_id | person_id | | |
specimen_concept_id | concept_id | 0 if concept_id is empty | |
specimen_type_concept_id | type_concept_id | | |
specimen_date | start_date | | |
specimen_datetime | start_datetime | | |
quantity | quantity | | |
unit_concept_id | unit_concept_id | | |
anatomic_site_concept_id | anatomic_site_concept_id | | |
disease_status_concept_id | disease_status_concept_id | | |
specimen_source_id | specimen_source_id | | |
specimen_source_value | source_value | | |
unit_source_value | unit_source_value | | |
anatomic_site_source_value | anatomic_site_source_value | | |
disease_status_source_value | disease_status_source_value | | |