Figure 1:

Workflow to ETL SDoH Observations from FlowSheets. 1) During exploration, the FlowSheets schema should allow for recognizing (A) templates (surveys tools), (B) individual measurements (survey questions), (C) measurement values (provided responses), (D) the visit encounter (instance of data collection), and (E) linkable to the OMOP person instances (subjects reference). 2) Triage the FlowSheet measurements into a mapping table with information about the data type and OMOP observation concept semantic equivalent. Retain the relationship between each measurement, unique measure value, and their equivalent value_as_concept_id in a separate table. 3) Join the tables, apply conversion logic, apply a filter for values occurring more than 10 instances (optional), then insert into the OMOP Observation table.