Home

Integrating SEDoH variables into the OMOP CDM and the i2b2 web application

The process of enhancing an OMOP data warehouse and integrating with the i2b2 web application consists of these broad steps:

1. Input data preparation: Prepare a database view and export address data (attached to entities like patients) or geocoded addresses (See next step for required format)
2. Enhancement with SEDoH values: Run the Python script on the exported data to geocode addresses and enhance with the SEDoH variables
3. Preparation of SEDoH data for ingestion: Import data, match with the entities associated with the addresses, and merge with SEDoH concepts
4. Integration with the OMOP CDM: Setup OMOP CDM and import enhanced data into OMOP tables
5. Integration with the i2b2 web application: Setup i2b2 database and import enhanced data into i2b2 database