Critical terminology

Owned by Beatrix Krause (Unlicensed)
Last updated: May 26, 2021
2 min read

For your data query, you can access different data tables. Some information can be found across 2 or more data tables. For example, questions can be found in the “OBSERVATION” table. the “DS_SURVEY” table and the “CONCEPT” table. However, in your script, each of these tables refers to the question using a different terminology or ID.

 

Example:

The question “How confident are you filling out medical forms by yourself?” has the question ID 1585766 and the question code “OverallHealth_MedicalFormConfidence”. If we want to request information about this question from the DS_SURVEY table, our question ID is stored under “question_concept_id“:

Find your IDs and PHI here https://athena.ohdsi.org/search-terms/start

And see instructions here