Critical terminology
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 Athena lookup table