SOURCE_TO_CONCEPT_MAP

Table Description

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.

CDM Field	User Guide	ETL Conventions	Datatype	Required	Primary Key	Foreign Key	FK Table
source_code	The source code being translated into a Standard Concept.		varchar(50)	Yes	No	No
source_concept_id	A foreign key to the Source Concept that is being translated into a Standard Concept.	This is either 0 or should be a number above 2 billion, which are the Concepts reserved for site-specific codes and mappings.	integer	Yes	No	Yes	CONCEPT
source_vocabulary_id	A foreign key to the VOCABULARY table defining the vocabulary of the source code that is being translated to a Standard Concept.		varchar(20)	Yes	No	No
source_code_description	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.		varchar(255)	No	No	No
target_concept_id	The target Concept to which the source code is being mapped.		integer	Yes	No	Yes	CONCEPT
target_vocabulary_id	The Vocabulary of the target Concept.		varchar(20)	Yes	No	Yes	VOCABULARY
valid_start_date	The date when the mapping instance was first recorded.		date	Yes	No	No
valid_end_date	The date when the mapping instance became invalid because it was deleted or superseded (updated) by a new relationship. Default value is 31-Dec-2099.		date	Yes	No	No
invalid_reason	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.		varchar(1)	No	No	No



Name	Begin	End

fpk_source_to_concept_map_source_concept_id : Relationship	concept : Entity	source_to_concept_map : Entity
fpk_source_to_concept_map_target_concept_id : Relationship	concept : Entity	source_to_concept_map : Entity
fpk_source_to_concept_map_target_vocabulary_id : Relationship	vocabulary : Entity	source_to_concept_map : Entity



	Name		Value

	Name		source_code
	Type		varchar
	Nullable		false
	Unique		false
	Primary Key		false
	Index		false
	Type Name		varchar
	Length		50
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		source_concept_id
	Type		int4
	Nullable		false
	Unique		false
	Primary Key		true
	Index		false
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		true
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		target_concept_id
	Type		int4
	Nullable		false
	Unique		false
	Primary Key		true
	Index		false
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		true
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		target_vocabulary_id
	Type		varchar
	Nullable		false
	Unique		false
	Primary Key		true
	Index		false
	Type Name		varchar
	Length		20
	Scale		0
	Id Generator		native
	Foreign Key		true
	Generated		Unspecified
	Sync To Attribute		Yes



Column Name	Data Type	PK / FK	Nullable	Description

source_code	varchar(50)		No
source_concept_id	int4	PK / FK	No
target_concept_id	int4	PK / FK	No
target_vocabulary_id	varchar(20)	PK / FK	No
source_vocabulary_id	varchar(20)		No
source_code_description	varchar(255)		Yes
valid_start_date	date		No
valid_end_date	date		No
invalid_reason	varchar(1)		Yes



	Diagram

	Vocabulary_With_Standard : Entity Relationship Diagram
	Vocabulary_Tables : Entity Relationship Diagram