OHDSI Home | Forums | Wiki | Github

Convert patient claim data to CDM

CDM Builders
#1

HI ALL

Anyone have experiences of converting patient claim data into the CDM?
We have some issues during conversion.

  1. Which kind of ‘concept_id’ is recommended for medications? RXNorm or NDC?
  2. Different from clinical data, the claim data only contains minimum set of information for claims. Some information is missing, such as the race, location, lab test. How to handle the missing data?

Thanks.

#2

IMEDS CCAE dataset is also an example of mostly claims data.
For drugs - RxNorm is, I think, a better choice for final drug terminology.

If you have missing data, you just leave them as they are - missing. No imputation. Eg., if you don’t know gender or date of birth, just don’t populate these columns (rows).

t