ukbiobank-omop-etl

Resources and documentation for UK Biobank to OMOP CDM v5.3.1 conversion

View the Project on GitHub thehyve/ukbiobank-omop-etl

Table name: drug_exposure

Reading from stem_table

Destination Field Source field Logic Comment field
drug_exposure_id id    
person_id person_id    
drug_concept_id concept_id    
drug_exposure_start_date start_date    
drug_exposure_start_datetime start_datetime    
drug_exposure_end_date end_date    
drug_exposure_end_datetime end_datetime    
verbatim_end_date      
drug_type_concept_id type_concept_id    
stop_reason stop_reason    
refills refills    
quantity quantity    
days_supply days_supply    
sig sig    
route_concept_id route_concept_id    
lot_number lot_number    
provider_id provider_id    
visit_occurrence_id visit_occurrence_id    
visit_detail_id      
drug_source_value source_value    
drug_source_concept_id source_concept_id    
route_source_value route_source_value    
dose_unit_source_value dose_unit_source_value