OHDSI Home | Forums | Wiki | Github

Data issues while converting Claims data

CDM Builders
#1

We are trying to convert a claims dataset to OMOP and we are facing some issues. Could you please help us with the following.

  1. A person is mapped to multiple locations in source dataset, should we create multiple or single IDs in OMOP Person table.
  2. In the source dataset, we have a few providers for whom NPI is not present (only Provider Name is present). Should we store such provider records in OMOP Provider table?
  3. In the source dataset, we have a few care sites for whom NPI is not present ( the only name is present). Should we store such care site records in OMOP Care Site table?
    4.In the source data, we have multiple care sites mapped to a single zip. For such records should we create multiple or single location Ids in OMOP location table. Right now we have taken the grain of location table as a zip i.e. only single ID will be generated but not sure what address in that case.
#3

@Megha_Maheshwari
Though we released the whole process and the ETL code for Korean claim data, it’s in Korean… Sorry about this.
There are some ETL code for claim database are released:

Does the person have history for location? Then, those history can be stored in location_history.

@mvanzandt, we discussed about this in the first F2F Themis meeting. And you said that you stored the latest location to the person table as long as I remembered. Did we achieve consensus about this?

t