OHDSI Home | Forums | Wiki | Github

How to Dose_era generate for CDM5.3?

CDM Builders
#1

Hello,

We are currently converting EHR data to CDM v5.3.

There was a question about Dose_era during the creation of the derived table.

When creating the dose_era table, the effective_drug_dose column is used.
However, ‘effective_drug_dose’ column has been removed from the drug_exposure table when updating to CDM v5.3.

It does not apply to the SQL code that generates the dose_era table provided by github.

Who’s there making update ‘dose_era’ code for version 5.3?

If I want to update using existing code.
According to the ‘dose_era’ table description in the cdm specification, can I use the the ‘amount_value’ column in ‘drug_strength’ instead of ‘effective_drug_dose’ column in an existing ‘Dose_era’ query?

#2

@Dahye_Shin:

Ha!! You are the first one. And in an Open Source project, if you need something - it’s your job. :smile:

But we would be very interested in doing it together, so we can publish a generic SQL for those. Let me now if that is interesting.

t