CONCEPT_CLASS table

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:

FieldRequiredTypeDescription
concept_class_idYesvarchar(20)A unique key for each class.
concept_class_nameYesvarchar(255)The name describing the Concept Class, e.g. “Clinical Finding”, “Ingredient”, etc.
concept_class_concept_idYesintegerA foreign key that refers to an identifier in the CONCEPT table for the unique Concept Class the record belongs to.

Conventions

concept_class previouslyconcept_class_id Version 5
Administrative conceptAdmin Concept
Admitting SourceAdmitting Source
Anatomical Therapeutic Chemical ClassificationATC
Anatomical Therapeutic Chemical ClassificationATC
APCProcedure
AttributeAttribute
Biobank FlagBiobank Flag
Biological functionBiological Function
Body structureBody Structure
Brand NameBrand Name
Branded DrugBranded Drug
Branded Drug ComponentBranded Drug Comp
Branded Drug FormBranded Drug Form
Branded PackBranded Pack
CCS_DIAGNOSISCondition
CCS_PROCEDURESProcedure
Chart AvailabilityChart Availability
Chemical StructureChemical Structure
Clinical DrugClinical Drug
Clinical Drug ComponentClinical Drug Comp
Clinical Drug FormClinical Drug Form
Clinical findingClinical Finding
Clinical PackClinical Pack
Concept RelationshipConcept Relationship
Condition Occurrence TypeCondition Occur Type
Context-dependent categoryContext-dependent
CPT-4Procedure
CurrencyCurrency
Death TypeDeath Type
Device TypeDevice Type
Discharge DispositionDischarge Dispo
Discharge StatusDischarge Status
DomainDomain
Dose FormDose Form
DRGDiagnostic Category
Drug Exposure TypeDrug Exposure Type
Drug InteractionDrug Interaction
Encounter TypeEncounter Type
Enhanced Therapeutic ClassificationETC
Enrollment BasisEnrollment Basis
Environment or geographical locationLocation
EthnicityEthnicity
EventEvent
GenderGender
HCPCSProcedure
Health Care Provider SpecialtyProvider Specialty
HES specialtyProvider Specialty
High Level Group TermHLGT
High Level TermHLT
HispanicHispanic
ICD-9-ProcedureProcedure
Indication or Contra-indicationInd / CI
IngredientIngredient
LOINC CodeMeasurement
LOINC Multidimensional ClassificationMeas Class
Lowest Level TermLLT
MDCDiagnostic Category
Measurement TypeMeas Type
Mechanism of ActionMechanism of Action
Model componentModel Comp
Morphologic abnormalityMorph Abnormality
MS-DRGDiagnostic Category
Namespace conceptNamespace Concept
Note TypeNote Type
Observable entityObservable Entity
Observation Period TypeObs Period Type
Observation TypeObservation Type
OMOP DOI cohortDrug Cohort
OMOP HOI cohortCondition Cohort
OPCS-4Procedure
OrganismOrganism
Patient StatusPatient Status
Pharmaceutical / biologic productPharma/Biol Product
Pharmaceutical PreparationsPharma Preparation
PharmacokineticsPK
Pharmacologic ClassPharmacologic Class
Physical forcePhysical Force
Physical objectPhysical Object
Physiologic EffectPhysiologic Effect
Place of ServicePlace of Service
Preferred TermPT
ProcedureProcedure
Procedure Occurrence TypeProcedure Occur Type
Qualifier valueQualifier Value
RaceRace
Record artifactRecord Artifact
Revenue CodeRevenue Code
SexGender
Social contextSocial Context
Special conceptSpecial Concept
SpecimenSpecimen
Staging and scalesStaging / Scales
Standardized MedDRA QuerySMQ
SubstanceSubstance
System Organ ClassSOC
Therapeutic ClassTherapeutic Class
UCUMUnit
UCUM CanonicalCanonical Unit
UCUM CustomUnit
UCUM StandardUnit
UndefinedUndefined
UNKNOWNUndefined
VA ClassDrug Class
VA Drug InteractionDrug Interaction
VA ProductDrug Product
VisitVisit
Visit TypeVisit Type