Alchemist / Critical Care

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

Metadata

The METADATA table contains metadata information about a dataset that has been transformed to the OMOP Common Data Model.

Field Required Type FK Table Description
metadata_concept_id Yes bigint CONCEPT A foreign key that refers to a Standard Metadata Concept identifier in the Standardized Vocabularies.
metadata_type_concept_id Yes bigint CONCEPT A foreign key that refers to a Standard Type Concept identifier in the Standardized Vocabularies.
name Yes varchar(250)   The name of the Concept stored in metadata_concept_id or a description of the data being stored.
value_as_string No text   The metadata value stored as a string.
value_as_concept_id No bigint   A foreign key to a metadata value stored as a Concept ID.
metadata_date No date   The date associated with the metadata.
metadata_datetime No datetime   The date and time associated with the metadata.