First of all, thank you for creating this dataset 👍🏻:
We (@mrueda @palilsonjmr) have been using your synthetic dataset to test an OMOP-CDM instance and have encountered an issue with the consistency of the visit_occurrence_id associated with each person_id.
Specifically, we have noticed a discrepancy between the visit_occurrence_id for each person_id in the _VISITOCCURRENCE table and the visit_occurrence_id for the same person_id appearing in other tables (CONDITION_OCCURRENCE, DRUG_EXPOSURE, MEASUREMENT, OBSERVATION, and PROCEDURE_OCCURRENCE).
For example, person_id = 1 has only 1 visit_occurrence_id (85) in the _VISITOCCURRENCE table, but in the MEASUREMENT table, this person_id has multiple visit_occurrence_id (22, 41, 42, 43, 45, ...).
Hello,
First of all, thank you for creating this dataset 👍🏻:
We (@mrueda @palilsonjmr) have been using your synthetic dataset to test an OMOP-CDM instance and have encountered an issue with the consistency of the
visit_occurrence_idassociated with eachperson_id.Specifically, we have noticed a discrepancy between the
visit_occurrence_idfor eachperson_idin the _VISITOCCURRENCE table and thevisit_occurrence_idfor the sameperson_idappearing in other tables (CONDITION_OCCURRENCE, DRUG_EXPOSURE, MEASUREMENT, OBSERVATION, andPROCEDURE_OCCURRENCE).For example,
person_id = 1has only 1visit_occurrence_id(85) in the _VISITOCCURRENCE table, but in the MEASUREMENT table, thisperson_idhas multiplevisit_occurrence_id(22, 41, 42, 43, 45, ...).Are you guys aware of this issue?
Best,
Manu