User Tools

Site Tools


documentation:cdm:domain

This is an old revision of the document!


DOMAIN table

The DOMAIN table includes a list of OMOP-defined Domains the Concepts of the Standardized Vocabularies can belong to. A Domain defines the set of allowable Concepts for the standardized fields in the CDM tables. For example, the “Condition” Domain contains Concepts that describe a condition of a patient, and these Concepts can only be stored in the condition_concept_id field of the CONDITION_OCCURRENCE and CONDITION_ERA tables. This reference table is populated with a single record for each Domain and includes a descriptive name for the Domain.

FieldRequiredTypeDescription
domain_idYesvarchar(20)A unique key for each domain.
domain_nameYesvarchar(255)The name describing the Domain, e.g. “Condition”, “Procedure”, “Measurement” etc.
domain_concept_idYesintegerA foreign key that refers to an identifier in the CONCEPT table for the unique Domain Concept the Domain record belongs to.

Conventions

  • There is one record for each Domain. The domains are defined by the tables and fields in the OMOP CDM that can contain Concepts describing all the various aspects of the healthcare experience of a patient.
  • The domain_id field contains an alphanumerical identifier, that can also be used as the abbreviation of the Domain.
  • The domain_name field contains the unabbreviated names of the Domain.
  • Each Domain also has an entry in the Concept table, which is recorded in the domain_concept_id field. This is for purposes of creating a closed Information Model, where all entities in the OMOP CDM are covered by unique Concept.
  • Past versions of the OMOP CDM did not support the notion of a Domain.
documentation/cdm/domain.1418496610.txt.gz · Last modified: 2014/12/13 18:50 by cgreich