Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Updating to newer CDM versions + upload R script available #67

Open
schuemie opened this issue Sep 17, 2021 · 1 comment
Open

Updating to newer CDM versions + upload R script available #67

schuemie opened this issue Sep 17, 2021 · 1 comment

Comments

@schuemie
Copy link
Member

I wrote an R script for upload the Synpuf data into CDM v5.2.2. There are some new conventions for CDMs that the ETL script doesn't yet follow. My script fixes those, but it would be nicer if they were moved into the ETL script. These are the issues I found:

  1. Per-domain cost tables should be merged in to a single cost table. My script currently just ignores the cost tables
  2. All DATE fields should also get a DATE_TIME field, by just copying the date, and setting time to midnight
  3. The DRUG_EXPOSURE_END_DATE field must be populated. This can simply be done by adding the DAYS_SUPPLY to the DRUG_EXPOSURE_START_DATE.

I guess 1 is harder, but 2 and 3 are pretty trivial.

For even newer versions I think we need to start using the new TYPE_CONCEPT_ID and STATUS_CONCEPT_ID codes and fields.

@schuemie
Copy link
Member Author

  1. populate the CDM_SOURCE table.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant