User Tools

Site Tools


This is an old revision of the document!


The source to concept map table is a legacy data structure within the OMOP Common Data Model, recommended for use in ETL processes to maintain local source codes which are not available as Concepts in the Standardized Vocabularies, and to establish mappings for each source code into a Standard Concept as target_concept_ids that can be used to populate the Common Data Model tables. The SOURCE_TO_CONCEPT_MAP table is no longer populated with content within the Standardized Vocabularies published to the OMOP community. Mapping information between source codes and Standard Concepts are now stored in the CONCEPT_RELATIONSHIP table

source_codeYesvarchar(50)The source code being translated into a standard concept.
source_concept_idYesintegerA foreign key to the source concept to which the source code is being mapped.
source_vocabulary_idYesvarchar(20)A foreign key to the vocabulary table defining the vocabulary of the source code that is being mapped to the Standardized Vocabularies.
source_code_descriptionNovarchar(255)An optional description for the source code. This is included as a convenience to compare the description of the source code to the name of the concept.
target_concept_idYesintegerA foreign key to the target concept to which the source code is being mapped.
target_vocabulary_idYesvarchar(20)A foreign key to the vocabulary table defining the vocabulary of the target concept.
valid_start_dateYesdateThe date when the mapping instance was first recorded.
valid_end_dateYesdateThe date when the mapping instance became invalid because it was deleted or superseded (updated) by a new relationship. Default value is 31-Dec-2099.
invalid_reasonNovarchar(1)Reason the mapping instance was invalidated. Possible values are D (deleted), U (replaced with an update) or NULL when valid_end_date has the default value.


documentation/cdm/source_to_concept_map.1416056440.txt.gz · Last modified: 2014/11/15 13:00 by cgreich