Hello @alruod and welcome to OHDSI, the OMOP CDM and the journey to create reliable, real world evidence!
What you have done looks accurate from a high level, but it’s the details which really make or break a transformation. As long as you followed the rules found on our CDM conventions page and created the ETL in the correct manner from the Book of OHDSI instructions, I’d say you are off to a good start. If you haven’t already, you should unit test your transformation, select a characterization study from your source data to compare against the same characterization study run in the OMOP CDM and run the Data Quality Dashobard against your CDM.
For multi visit to OP at the same day with different care sites, we find it real after tracing the patient journey, the patient visit PHC then transfer to hospital.
Why is that? It’s a classic. Patient comes to the doctor, who measures a blood pressure of 200 over 140 and goes “We need to send you in right away”. In the evening, the patient is an inpatient case.