OHDSI Home | Forums | Wiki | Github

Visit_concept_id for pharmacy claim data

Hello, everyone.
My name is Hojun Park, Ph.D course student, Prof. Rae Woong Park’s team of Ajou university School of medicine in Korea.

We try to construct Korean national claim database into CDM version 5.
The database includes many data sets about pharmacy visitation.

We want to insert the data to [VISIT_OCCURRENCE] table, but there are four visit-domain concepts on the [CONCEPT] table.

CONCEPT_ID   CONCEPT_NAME   DOMAIN_ID
42898160          Long Term Care      Visit
9203                  Emergency Room   Visit
9202                  Outpatient               Visit
9201                  Inpatient                  Visit

There is no concept about pharmacy visitation.

Are there some ways to insert the pharmacy visitation data to [VISIT_OCCURRENCE] table?
Could OHDSI add a concept_id to the next version of [CONCEPT] table for pharmacy visitation?

Thanks,
Hojun

@Ho_Jun_Park,

Typically we don’t associate a pharmacy visitation as a visit. DRUG_EXPOSURE that are just picked up from a pharmacy can have NULL for VISIT_OCCURRENCE_ID. You will use the TYPE field in DRUG_EXPOSURE to highlight that this was of type 38000175-Prescription dispensed in pharmacy.

But if you are seeing a specific reason for needing it please let us know more details!

t