Inconsistencies between visit_occurrence_id within records and visit_occurence_id in table VISIT_OCCURRENCE

[mrueda]

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_id associated with each person_id.

Specifically, we have noticed a discrepancy between the visit_occurrence_id for each person_id in the VISIT_OCCURRENCE 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 VISIT_OCCURRENCE table, but in the MEASUREMENT table, this person_id has multiple visit_occurrence_id (22, 41, 42, 43, 45, ...).

Are you guys aware of this issue?

Best,

Manu