N3C Extension Vocabulary Table

N3C Vocabulary Table - entry for N3C vocabulary

vocabulary_id	vocabulary_name	vocabulary_reference	vocabulary_version	vocabulary_concept_id
N3C	National Covid Cohort Collaborative Extension Vocabulary	N3C generated	2021-11-21	1

N3C Extension Concept Table

• Each custom concept id is created in 2bil range with data element that require extension concepts

concept_id	concept_name	domain_id	vocabulary_id	concept_class_id	standard_concept	concept_code	valid_start_date	valid_end_date	invalid_reason
2004207791	N3C:LongCOVIDSpecialtyVisit	Observation	N3C	44819093	S	2004207791	2021-11-01	2099-12-31	null
2004208004	N3C:Other oxygen device	Device	N3C	Physical Object	null	OT_O2_DEVICE	1970-01-01	2099-12-31	null
2004208005	N3C:Room air	Device	N3C	Physical Object	null	ROOM_AIR	1970-01-01	2099-12-31	null

Example of Observation domain row using the N3C extension concept

• Example of the mapped data elements in the observation domain for the N3C:LongCOVIDSpecialtyVisit concept

observation_id	observation_date	observation_datetime	person_id	provider_id	qualifier_source_value	unit_source_value	value_as_number	visit_detail_id	visit_occurrence_id	value_as_string	observation_source_value	observation_concept_id	observation_source_concept_id	observation_type_concept_id	qualifier_concept_id	unit_concept_id	value_as_concept_id	observation_concept_name	observation_source_concept_name	observation_type_concept_name	qualifier_concept_name	unit_concept_name	value_as_concept_name	data_partner_id
{generated is - programmatically}	{clinic_visit_date from file}	null	{person_id from file}		null	null	null	null	null	null	null	2004207791	2004207791	32817	null	null	null	N3C:LongCOVIDSpecialtyVisit	N3C:LongCOVIDSpecialtyVisit	EHR	null	null	null	< data_partner_id>