From:                                                       Athena <pallas@ohdsi.org>

Sent:                                                         Sunday, March 6, 2022 8:39 PM

To:                                                            John Gresh

Subject:                                                   OMOP Vocabularies. Your download link

 

Link for downloading the Standardized Vocabularies

Vocabularies release version: v5.0 04-FEB-22

omop-terminology-download-2022-03-06 Vocabularies:

ICD10CM

-

International Classification of Diseases, Tenth Revision, Clinical Modification (NCHS)

NUCC

-

National Uniform Claim Committee Health Care Provider Taxonomy Code Set (NUCC)

Revenue Code

-

UB04/CMS1450 Revenue Codes (CMS)

LOINC

-

Logical Observation Identifiers Names and Codes (Regenstrief Institute)

SNOMED

-

Systematic Nomenclature of Medicine - Clinical Terms (IHTSDO)

Gender

-

OMOP Gender

NDC

-

National Drug Code (FDA and manufacturers)

RxNorm Extension

-

RxNorm Extension (OHDSI)

SPL

-

Structured Product Labeling (FDA)

RxNorm

-

RxNorm (NLM)

ICD9Proc

-

International Classification of Diseases, Ninth Revision, Clinical Modification, Volume 3 (NCHS)

ATC

-

WHO Anatomic Therapeutic Chemical Classification

Ethnicity

-

OMOP Ethnicity

CPT4

-

Current Procedural Terminology version 4 (AMA)

MEDRT

-

Medication Reference Terminology MED-RT (VA)

HCPCS

-

Healthcare Common Procedure Coding System (CMS)

CMS Place of Service

-

Place of Service Codes for Professional Claims (CMS)

Currency

-

International Currency Symbol (ISO 4217)

Medicare Specialty

-

Medicare provider/supplier specialty codes (CMS)

Race

-

Race and Ethnicity Code Set (USBC)

ICD9CM

-

International Classification of Diseases, Ninth Revision, Clinical Modification, Volume 1 and 2 (NCHS)

ABMS

-

Provider Specialty (American Board of Medical Specialties)

NDFRT

-

National Drug File - Reference Terminology (VA)

OMOP Extension

-

OMOP Extension (OHDSI)

Please download and load the Standardized Vocabularies as following:

  1. Click on this link to download the zip file. Typical file sizes, depending on the number of vocabularies selected, are between 30 and 250 MB.
  2. Unpack.
  3. Reconstitute CPT-4. See below for details.
  4. If needed, create the tables.
  5. Load the unpacked files into the tables.

Important: All vocabularies are fully represented in the downloaded files with the exception of CPT-4: OHDSI does not have a distribution license to ship CPT-4 codes together with the descriptions. Therefore, we provide you with a utility that downloads the descriptions separately and merges them together with everything else. After unpacking, simply open a command line in the directory you unpacked all the files into and run "java -Dumls-apikey=xxx -jar cpt4.jar 5". Please replace "xxx" with UMLS API KEY.

The control files can be found here. They are provided in the folders Oracle/, PostgreSQL/ and SQL Server/ for the respective SQL dialect. The loading scripts are inside the subfolder VocabImport/.

If you hit problems please use the OHDSI Forum pages, and somebody will help you. You will need to register.

Regards,
Odysseus Data Services, Inc.