Skip to main content Link Search Menu Expand Document (external link)

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    

EHDEN ETL UKB v0.1 | Copyright © The Hyve