I am writing a ETL script to fill the “drug_exposure” table, and got stuck on the quantity field.
The documentation (OMOP CDM v5.3) states that I need to first find the drug form, so if the drug is a pill, quantity should contain the number of pills prescribed, if it is a injection, the volume and so on.
The first doubt is: what are the accepted values of “relationship_id” ? I’m currently using the values:
(‘Has dose form’, ‘RxNorm dose form of’, ‘NDFRT dose form of’, ‘Has disp dose form’,
‘Disp dose form of’, ‘Has dose form unit’, ‘Has dose form group’, ‘Has basic dose form’,
‘Basic dose form of’, ‘RxNorm has dose form’, ‘NDFRT has dose form’ )
The second doubt is, there is more than 800 values in concept_class_id = “Dose Form”. Should I go one by one, deciding which ones are “pill-like” or “liquid”? I’m hoping there is another, easier, way.
thanks!