discrepancy in #records omop.visit_occurrence -> pcornet.encounter

OHDSI / OMOPV4_PCORNetV1_ETL

ETL script to transform data from OMOP v4 CDM to PCORNet V1 CDM

8 stars 7 forks source link

discrepancy in #records omop.visit_occurrence -> pcornet.encounter #4

Closed writetoritu closed 9 years ago

writetoritu commented 9 years ago

In the source-to-concept map table, we have duplicate value_as_concept values for the same standard_concepts. e.g. For 'Discharge status' - > 'AW', 'RS', 'NI' For Admitting source' - > 'RS', 'NI' As a result, this is creating multiple records for all encounters that have no information for both these observations.

We need to find the correct 'value_as_concept' values for 'RS', 'AW' for these observations, and add them to the source-to-concept mapping table.

writetoritu commented 9 years ago

thanks @toanong for fixing the codes. We are now getting same #records between the two tables.