Entering Survey Question and Response with v6.0 - new fields missing from DDL?

mqunell8 · March 1, 2021, 11:33pm

Hello Everyone. We have multiple surveys we will be mapping into OMOP, and hope to use the method documented in the v6.0 spec - create an entry in the Survey table, and map question and answer pairs into individual observations in the Observation table. The 6.0 spec specifies updates needed to the Observation table in order to link Q&A pairs back to a particular survey - however the published DDL in GitHub is missing these. There seems to be a disconnect.

For example, the 6.0 spec says to add to the Observation table
DOMAIN_ID,
DOMAIN_OCCURRENCE_ID

But the DDL at https://github.com/OHDSI/CommonDataModel is missing both.

Can you clarify the expected practice?
Thanks

quinnt · March 3, 2021, 4:43pm

Hello @mqunell8,

Perhaps @clairblacketer can provide us with the definitive answer, but it was my understanding that the following are the two columns you’re looking for:

OMOP Column	How to populate for a survey
`observation.observation_event_id`	Load with the `survey_conduct_id` value
`observation.obs_event_field_concept_id`	Load with `concept_id` = 1147833

In other words, obs_event_field_concept_id points to an OMOP CDM metadata record that specifies which column is referenced in your observation_event_id column.

mqunell8 · March 3, 2021, 5:26pm

Thanks Tim. I’m a bit confused. According to the published spec

observation.domain =‘Survey’ (identifies this observation as part of a survey)
observation.domain_occurrence_id=survey_conduct.survey_conduct_id (the key that links this observation to a particular instance of a completed survey)

The question text itself maps to the observation_concept_id
The response text itself maps to the observation_value_as_concept_id

quinnt · March 3, 2021, 6:00pm

Where is this published specification?

The official OMOP CDM data dictionary entry for the observation table is here: https://ohdsi.github.io/CommonDataModel/cdm60.html#OBSERVATION

It does not include those two columns you cited:

observation.domain
observation.domain_occurrence_id

mqunell8 · March 3, 2021, 6:15pm

pages 59 & 60 which refer to the Survey table, and how it should link to the observation table.