with Name

OMOP_5.4_ER_ALL

OMOP_5.4_ER : Model

Entity - cdm_source link

Properties

Name

Value

Description

CDM_SOURCE

Table Description

The CDM_SOURCE table contains detail about the source database and the process used to transform the data into the OMOP Common Data Model.

CDM Field	User Guide	ETL Conventions	Datatype	Required	Primary Key	Foreign Key	FK Table	FK Domain
cdm_source_name	The name of the CDM instance.		varchar(255)	Yes	No	No
cdm_source_abbreviation	The abbreviation of the CDM instance.		varchar(25)	Yes	No	No
cdm_holder	The holder of the CDM instance.		varchar(255)	Yes	No	No
source_description	The description of the CDM instance.		varchar(MAX)	No	No	No
source_documentation_reference			varchar(255)	No	No	No
cdm_etl_reference		Put the link to the CDM version used.	varchar(255)	No	No	No
source_release_date	The release date of the source data.		date	Yes	No	No
cdm_release_date	The release data of the CDM instance.		date	Yes	No	No
cdm_version			varchar(10)	No	No	No
cdm_version_concept_id	The Concept Id representing the version of the CDM.	You can find all concepts that represent the CDM versions using the query: SELECT * FROM CONCEPT WHERE VOCABULARY_ID = ‘CDM’ AND CONCEPT_CLASS = ‘CDM’	integer	Yes	No	Yes	CONCEPT
vocabulary_version		You can find the version of your Vocabulary using the query: SELECT vocabulary_version from vocabulary where vocabulary_id = ‘None’	varchar(20)	Yes	No	No

Data Model

Physical

Primary Key Clustered

Unspecified

Unlogged

false

Columns Summary



	Column Name		Data Type		PK / FK		Nullable		Description

	cdm_source_name		varchar(255)				No
	cdm_source_abbreviation		varchar(25)				No
	cdm_holder		varchar(255)				No
	source_description		text				Yes
	source_documentation_reference		varchar(255)				Yes
	cdm_etl_reference		varchar(255)				Yes
	source_release_date		date				No
	cdm_release_date		date				No
	cdm_version		varchar(10)				Yes
	cdm_version_concept_id		int4		PK / FK		No
	vocabulary_version		varchar(20)				No

Relationships Summary



	Name		Begin		End

	fpk_cdm_source_cdm_version_concept_id : Relationship		concept : Entity		cdm_source : Entity

Columns Detail



	Name		Value

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



	Name		Value

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



	Name		Value

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



	Name		Value

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



	Name		Value

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



	Name		Value

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



	Name		Value

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



	Name		Value

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



	Name		Value

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



	Name		Value

	Name		cdm_version_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		vocabulary_version
	Type		varchar
	Nullable		false
	Unique		false
	Primary Key		false
	Index		false
	Type Name		varchar
	Length		20
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes

Relationships Detail

Name

Value

Name

fpk_cdm_source_cdm_version_concept_id

Foreign Key

	cdm_source

	cdm_version_concept_id : Column

Primary Key

	concept

	concept_id : Column

To Multiplicity

0..*

From Multiplicity

0..1

Sync To Association

Yes

Data Model

Physical

Appears In



	Diagram

	Standardized_Tables : Entity Relationship Diagram
	Vocabulary_With_Standard : Entity Relationship Diagram

OMOP_5.4_ER_ALL