search

OHDSI / ETL-CDMBuilder

ETL-CDMBuilder is a repo containing a .NET Core application to perform ETL to OMOP CDM for multiple databases
Apache License 2.0
50 stars 32 forks source link

Mappings for device_cost and observation in Truven_CCAE_and_MDCR_ETL_CDM_V5.doc #11

Closed donohara closed 4 years ago

donohara commented 8 years ago

Is there a newer version of the Truven mapping specs that has the details for the device_cost table, and an update to the observation table section? Device_cost is empty, and observation looks like a previous CDM version.

Thanks!

ericaVoss commented 8 years ago

The most up-to-date version can be found here: https://github.com/OHDSI/ETL-CDMBuilder/blob/master/man/TRUVEN_CCAE_MDCR/Truven_CCAE_and_MDCR_ETL_CDM_V5.doc

We leave costs where they came in. So true procedure costs stay in PROCEDURE_COST and true drug costs stay in DRUG_COST. This will all go away when we go to just the one COST table end of this year early next year.

I see what you are saying on the OBSERVATION table. I will log a ticket on our side - I think the data is already moving from MEASUREMENT to OBSERVATION when needed but we didn't document it.