inst/QueryLibrary/Aggregate/general/G13.md

In sib-swiss/dsQueryLibraryServer: OMOP query Library

G13: List available vocabularies

Description

This query returns list of available vocabularies.

Query

SELECT
  vocabulary_id,
  vocabulary_name,
  vocabulary_version
FROM @vocab.vocabulary 
;

Input

None

Output

| Field | Description | | --- | --- | | vocabulary_id | OMOP Vocabulary ID | | vocabulary_name | Vocabulary name | | vocabulary_version | Version number of the loaded vocabulary |

Example output record

| Field | Value | | --- | --- | | vocabulary_id | SNOMED | | vocabulary_name | Systematic Nomenclature of Medicine - Clinical Terms (IHTSDO) | | vocabulary_version | SnomedCT Release 20170131 |

Documentation

https://github.com/OHDSI/CommonDataModel/wiki/VOCABULARY

sib-swiss/dsQueryLibraryServer documentation built on Feb. 13, 2025, 8:07 p.m.