Table name: drug_exposure
Reading from stem_table
| Destination Field | Source field | Logic | Comment field |
|---|---|---|---|
| drug_exposure_id | id | ||
| person_id | person_id | ||
| drug_exposure_start_date | start_date | ||
| drug_concept_id | concept_id | 0 if concept_id is empty | |
| drug_exposure_start_datetime | start_datetime | ||
| drug_exposure_end_date | end_date start_date | If end_date empty, use start_date | |
| drug_exposure_end_datetime | end_datetime start_datetime | If end_datetime empty, use start_datetime | |
| verbatim_end_date | |||
| drug_type_concept_id | type_concept_id | 32838 - ‘EHR prescription’; for covid19_gp records | |
| 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 |