1. Describe the issue/topic?
DRUG_ERA.DRUG_EXPOSURE_COUNT - there is no ETL convention listed.
2. What do we know about this topic? What has been discussed?
There is standardized code that is already building the DRUG_ERAS.
http://ohdsi.github.io/CommonDataModel/cdm53.html#DRUG_ERA
https://ohdsi.github.io/CommonDataModel/sqlScripts.html#drug_eras
3. What are recommendations for how to handle this issue/topic?
We recommend add the following summary text to the ETL convention
The count of grouped DRUG_EXPOSURE records that were included in the DRUG_ERA row.
4. What next steps should be taken?
Open a GitHub issue so Clair can add it to GitHub.io site for 5.3 & 5.4.
1. Describe the issue/topic?
The description for DRUG_EXPOSURE.QUANTITY is hard to understand.
2. What do we know about this topic? What has been discussed?
What is currently written on the DRUG_EXPOSURE.QUANTITY column
3. What are recommendations for how to handle this issue/topic?
First bring tablets to the top of the description:
For clinical drugs with fixed dose forms (tablets etc.) the quantity is the total number of units/tablets/capsules prescribed or dispensed. The quantity can be a partial number, but then only 1/2 or 1/3, not 0.01.
We could not come to an understanding of what to do when the dose form is not a tablet and we think the current description is not sufficient in that. Also including the link to the drug dose calculations isn’t really helping understanding what the quantity is.
4. What next steps should be taken?
We can start by reordering the text that is currently in the column so that tablets is at the top.
There is more discussion needed on how to handle non-tablet. Maybe leveraging the Darwin work around DRUG_EXPOSURE Characterization.