Alchemist / Critical Care

Documentation on the data exchange format for HIC Critical Care and the Alchemist ingestion pipeline.

Domain

The DOMAIN table includes a list of OMOP-defined Domains that 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.

Field Required Type FK Table Description
domain_id Yes varchar(20)   A unique key for each domain.
domain_name Yes varchar(255)   The name describing the Domain, e.g. “Condition”, “Procedure”, “Measurement” etc.
domain_concept_id Yes bigint CONCEPT A foreign key that refers to an identifier in the Concept table for the unique Domain Concept that this 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 records.
  • Versions prior to v5.0.0 of the OMOP CDM did not support the notion of a Domain.