Hello, everyone.
My name is Eun Kyoung Ahn, research fellow, Prof. Rae Woong Park’s team of Ajou university School of medicine in Korea.
We try to update our database (AUSOM) which is an EMR database of a tertiary hospital, into CDM version. 4.0.
About the “drug_type_concept_id” column of Drug_Exposure table, there are 11 concepts on the CONCEPT table. And we want to choose two concepts among them.
This is my opinion,
- ‘inpatient administration (38000180)’ for inpatient, including emergency room visited person
- ‘prescription dispensed in pharmacy (38000175)’ for out-patient
If anyone has better choice at this case, your advice would be appreciated.
Total list of concepts for drug exposure type is below;
38000175 Prescription dispensed in pharmacy
38000176 Prescription dispensed through mail order
38000177 Prescription written
38000178 Medication list entry
38000179 Physician administered drug (identified as procedure)
38000180 Inpatient administration
38000181 Drug era - 0 days persistence window
38000182 Drug era - 30 days persistence window
43542356 Physician administered drug (identified from EHR problem list)
43542357 Physician administered drug (identified from referral record)
43542358 Physician administered drug (identified from EHR observation)
Thank you.