Claims conundrum: all NULLs in VISIT_OCCURRENCE_ID in drug exposure table

[Gowtham_Rao]

Linking these threads together.

Pharmacy claims -> Drug exposure. How to identify the dispensing/billing pharmacy

Assumption: pharmacy claim is not a visit. pharmacy claims may have a record in drug_exposure, but no record in visit_occurrence (no visit_occurrence_id for a given drug_exposure_id) In v5.2 of OMOP, there is no care_site or location_id or pharmacy_id to identify which pharmacy billed/dispensed the drug. There is a provider_id but that is for who prescribed the drug. provider_id - A foreign key to the provider in the provider table who initiated (prescribed or administered) the Drug Expos…

If pharmacy dispensation is a visit with visit_occurrence_id with a not null value, then we can capture the pharmacy on care_site table.