THIS IS OUTDATED. All documentation is now on the github wiki. Please refer there or to the CDM working group for more information
The CONCEPT_CLASS table is a reference table, which includes a list of the classifications used to differentiate Concepts within a given Vocabulary. This reference table is populated with a single record for each Concept Class:
Field | Required | Type | Description |
---|---|---|---|
concept_class_id | Yes | varchar(20) | A unique key for each class. |
concept_class_name | Yes | varchar(255) | The name describing the Concept Class, e.g. “Clinical Finding”, “Ingredient”, etc. |
concept_class_concept_id | Yes | integer | A foreign key that refers to an identifier in the CONCEPT table for the unique Concept Class the record belongs to. |
concept_class previously | concept_class_id Version 5 |
---|---|
Administrative concept | Admin Concept |
Admitting Source | Admitting Source |
Anatomical Therapeutic Chemical Classification | ATC |
Anatomical Therapeutic Chemical Classification | ATC |
APC | Procedure |
Attribute | Attribute |
Biobank Flag | Biobank Flag |
Biological function | Biological Function |
Body structure | Body Structure |
Brand Name | Brand Name |
Branded Drug | Branded Drug |
Branded Drug Component | Branded Drug Comp |
Branded Drug Form | Branded Drug Form |
Branded Pack | Branded Pack |
CCS_DIAGNOSIS | Condition |
CCS_PROCEDURES | Procedure |
Chart Availability | Chart Availability |
Chemical Structure | Chemical Structure |
Clinical Drug | Clinical Drug |
Clinical Drug Component | Clinical Drug Comp |
Clinical Drug Form | Clinical Drug Form |
Clinical finding | Clinical Finding |
Clinical Pack | Clinical Pack |
Concept Relationship | Concept Relationship |
Condition Occurrence Type | Condition Occur Type |
Context-dependent category | Context-dependent |
CPT-4 | Procedure |
Currency | Currency |
Death Type | Death Type |
Device Type | Device Type |
Discharge Disposition | Discharge Dispo |
Discharge Status | Discharge Status |
Domain | Domain |
Dose Form | Dose Form |
DRG | Diagnostic Category |
Drug Exposure Type | Drug Exposure Type |
Drug Interaction | Drug Interaction |
Encounter Type | Encounter Type |
Enhanced Therapeutic Classification | ETC |
Enrollment Basis | Enrollment Basis |
Environment or geographical location | Location |
Ethnicity | Ethnicity |
Event | Event |
Gender | Gender |
HCPCS | Procedure |
Health Care Provider Specialty | Provider Specialty |
HES specialty | Provider Specialty |
High Level Group Term | HLGT |
High Level Term | HLT |
Hispanic | Hispanic |
ICD-9-Procedure | Procedure |
Indication or Contra-indication | Ind / CI |
Ingredient | Ingredient |
LOINC Code | Measurement |
LOINC Multidimensional Classification | Meas Class |
Lowest Level Term | LLT |
MDC | Diagnostic Category |
Measurement Type | Meas Type |
Mechanism of Action | Mechanism of Action |
Model component | Model Comp |
Morphologic abnormality | Morph Abnormality |
MS-DRG | Diagnostic Category |
Namespace concept | Namespace Concept |
Note Type | Note Type |
Observable entity | Observable Entity |
Observation Period Type | Obs Period Type |
Observation Type | Observation Type |
OMOP DOI cohort | Drug Cohort |
OMOP HOI cohort | Condition Cohort |
OPCS-4 | Procedure |
Organism | Organism |
Patient Status | Patient Status |
Pharmaceutical / biologic product | Pharma/Biol Product |
Pharmaceutical Preparations | Pharma Preparation |
Pharmacokinetics | PK |
Pharmacologic Class | Pharmacologic Class |
Physical force | Physical Force |
Physical object | Physical Object |
Physiologic Effect | Physiologic Effect |
Place of Service | Place of Service |
Preferred Term | PT |
Procedure | Procedure |
Procedure Occurrence Type | Procedure Occur Type |
Qualifier value | Qualifier Value |
Race | Race |
Record artifact | Record Artifact |
Revenue Code | Revenue Code |
Sex | Gender |
Social context | Social Context |
Special concept | Special Concept |
Specimen | Specimen |
Staging and scales | Staging / Scales |
Standardized MedDRA Query | SMQ |
Substance | Substance |
System Organ Class | SOC |
Therapeutic Class | Therapeutic Class |
UCUM | Unit |
UCUM Canonical | Canonical Unit |
UCUM Custom | Unit |
UCUM Standard | Unit |
Undefined | Undefined |
UNKNOWN | Undefined |
VA Class | Drug Class |
VA Drug Interaction | Drug Interaction |
VA Product | Drug Product |
Visit | Visit |
Visit Type | Visit Type |