PASAR_ETL_Spec

Table name: drug_exposure

Reading from intra_op__drug_drug

Destination Field Source field Logic Comment field
drug_exposure_id id
infusion_startdatetime
  Autogenerated running id by ascending order of startdatetime and id
person_id anon_case_no Joined with PERSON.PERSON_SOURCE_VALUE for PERSON.PERSON_ID  
drug_concept_id drug_name
concentration
Need mapping table from Vocab team
 
drug_exposure_start_date infusion_startdatetime    
drug_exposure_start_datetime infusion_startdatetime    
drug_exposure_end_date operation_enddate    
drug_exposure_end_datetime      
verbatim_end_date      
drug_type_concept_id     32879 for Registry
stop_reason      
refills      
quantity volume    
days_supply     If source data is from intra_op, drug is assumed to be given intra operation, day supply is likely be 1.
sig      
route_concept_id      
lot_number      
provider_id      
visit_occurrence_id session_id    
visit_detail_id      
drug_source_value drug_name    
drug_source_concept_id      
route_source_value      
dose_unit_source_value      

Reading from intra_op__drug_fluids

Destination Field Source field Logic Comment field
drug_exposure_id id
fluid_startdate
fluid_starttime
  Autogenerated running id by ascending order of startdatetime and id
person_id anon_case_no Joined with PERSON.PERSON_SOURCE_VALUE for PERSON.PERSON_ID  
drug_concept_id fluid_name
drug_name
Need mapping table from Vocab team
 
drug_exposure_start_date fluid_startdate    
drug_exposure_start_datetime fluid_starttime
fluid_startdate
   
drug_exposure_end_date fluid_enddate    
drug_exposure_end_datetime fluid_endtime
fluid_enddate
   
verbatim_end_date      
drug_type_concept_id     32879 for Registry
stop_reason      
refills      
quantity fluid_volume_actual    
days_supply     If source data is from intra_op, drug is assumed to be given intra operation, day supply is likely be 1.
sig      
route_concept_id      
lot_number      
provider_id      
visit_occurrence_id session_id    
visit_detail_id      
drug_source_value drug_name
fluid_name
   
drug_source_concept_id      
route_source_value      
dose_unit_source_value      

Reading from intra_op__drug_med

Destination Field Source field Logic Comment field
drug_exposure_id id
medication_startdatetime
  Autogenerated running id by ascending order of startdatetime and id
person_id anon_case_no Joined with PERSON.PERSON_SOURCE_VALUE for PERSON.PERSON_ID  
drug_concept_id drug_name
medication_name
Need mapping table from Vocab team
Need mapping table from Vocab team
 
drug_exposure_start_date medication_startdate    
drug_exposure_start_datetime medication_startdatetime    
drug_exposure_end_date operation_enddate    
drug_exposure_end_datetime      
verbatim_end_date      
drug_type_concept_id     32879 for Registry
stop_reason      
refills      
quantity dosage_individual    
days_supply     If source data is from intra_op, drug is assumed to be given intra operation, day supply is likely be 1.
sig      
route_concept_id      
lot_number      
provider_id      
visit_occurrence_id session_id    
visit_detail_id      
drug_source_value medication_name
drug_name
   
drug_source_concept_id      
route_source_value      
dose_unit_source_value