Many researchers have implemented the Observational Medical Outcomes Partnership (OMOP) Common Data Model (CDM) and Standard Vocabularies (http://imeds.reaganudall.org/Vocabularies). The purpose of this document is to provide the research community with a set of queries that will simplify access to most common vocabulary questions which operate in Version 4.0 of the OMOP CDM and Standard Vocabularies.
The queries are designed to work in a CDM environment. The queries were tested on an Oracle database. While the queries are "generic", they may require minor syntax modifications to work on other Relational Databases.