We are in the process of mapping Epic’s Caboodle data warehouse to CDM. Any guidance on how to roll Hospital and Professional billing accounts will be helpful.
Background: Our idea is to populate only billed encounters into OMOP. But as expected, for many encounters there are two billing accounts generated (HB & PB). We are not sure how to roll them up. But at the time we do not want duplicate encounters in OMOP since we are sourcing from our BillingAccount tables.
Any direction will be appreciated.
Thank you,
Jawad
Rush University Medical Center