Description

VOCABULARY

Table Description

The VOCABULARY table includes a list of the Vocabularies collected from various sources or created de novo by the OMOP community. This reference table is populated with a single record for each Vocabulary source and includes a descriptive name and other associated attributes for the Vocabulary.

CDM Field	User Guide	Datatype	Required	Primary Key	Foreign Key	FK Table
vocabulary_id	A unique identifier for each Vocabulary, such as ICD9CM, SNOMED, Visit.	varchar(20)	Yes	Yes	No
vocabulary_name	The name describing the vocabulary, for example, International Classification of Diseases, Ninth Revision, Clinical Modification, Volume 1 and 2 (NCHS) etc.	varchar(255)	Yes	No	No
vocabulary_reference	External reference to documentation or available download of the about the vocabulary.	varchar(255)	No	No	No
vocabulary_version	Version of the Vocabulary as indicated in the source.	varchar(255)	No	No	No
vocabulary_concept_id	A Concept that represents the Vocabulary the VOCABULARY record belongs to.	integer	Yes	No	Yes	CONCEPT

Primary Key Constraint Name

xpk_vocabulary

Unlogged

false



Name	Begin	End

fpk_concept_vocabulary_id : Relationship	vocabulary : Entity	concept : Entity
fpk_source_to_concept_map_target_vocabulary_id : Relationship	vocabulary : Entity	source_to_concept_map : Entity
fpk_vocabulary_vocabulary_concept_id : Relationship	concept : Entity	vocabulary : Entity



	Name		Value

	Name		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		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

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



	Name		Value

	Name		vocabulary_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		vocabulary_version
	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



Column Name	Data Type	PK / FK	Nullable	Description

vocabulary_id	varchar(20)	PK	No
vocabulary_concept_id	int4	FK	No
vocabulary_name	varchar(255)		No
vocabulary_reference	varchar(255)		Yes
vocabulary_version	varchar(255)		Yes



	Diagram

	Vocabulary_With_Standard : Entity Relationship Diagram
	Vocabulary_Tables : Entity Relationship Diagram