: Record Table 937

Record Table 937

Title:	OMOP Specimen
Access field:	20142 (Present in OMOP dataset)

Table name

omop_specimen

Table group

OMOP

Debut

Feb 2023

Row count

5,000,000+

Parent table

n/a

Version

Sep 2024

Size

462MB

Stability

Complete

Cost Tier

dX o2 s2

This item is regarded as restricted and will be supplied to researchers only when absolutely necessary.

15 Columns

#	Column	Type	Notes
1	anatomic_site_concept_id	integer	A foreign key to a Standard Concept identifier for the anatomic location of specimen collection.
2	anatomic_site_source_value	string	The information about the anatomic site as detailed in the source.
3	disease_status_concept_id	integer	A foreign key to a Standard Concept identifier for the Disease Status of specimen collection.
4	disease_status_source_value	string	The information about the disease status as detailed in the source.
5	eid	integer	A foreign key identifier to the Person for whom the Specimen is recorded.
6	quantity	float	The amount of specimen collection from the person during the sampling procedure.
7	specimen_concept_id	integer	A foreign key referring to a Standard Concept identifier in the Standardized Vocabularies for the Specimen.
8	specimen_date	date	The date the specimen was obtained from the Person.
9	specimen_datetime	timestamp	The date and time on the date when the Specimen was obtained from the person.
10	specimen_id	integer	A unique identifier for each specimen.
11	specimen_source_id	string	The Specimen identifier as it appears in the source data.
12	specimen_source_value	string	The Specimen value as it appears in the source data. This value is mapped to a Standard Concept in the Standardized Vocabularies and the original code is, stored here for reference.
13	specimen_type_concept_id	integer	A foreign key referring to the Concept identifier in the Standardized Vocabularies reflecting the system of record from which the Specimen was represented in the source data.
14	unit_concept_id	integer	A foreign key to a Standard Concept identifier for the Unit associated with the numeric quantity of the Specimen collection.
15	unit_source_value	string	The information about the Unit as detailed in the source.

Column

Type

Notes

anatomic_site_concept_id

integer

A foreign key to a Standard Concept identifier for the anatomic location of specimen collection.

anatomic_site_source_value

string

The information about the anatomic site as detailed in the source.

disease_status_concept_id

integer

A foreign key to a Standard Concept identifier for the Disease Status of specimen collection.

disease_status_source_value

string

The information about the disease status as detailed in the source.

eid

integer

A foreign key identifier to the Person for whom the Specimen is recorded.

quantity

float

The amount of specimen collection from the person during the sampling procedure.

specimen_concept_id

integer

A foreign key referring to a Standard Concept identifier in the Standardized Vocabularies for the Specimen.

specimen_date

date

The date the specimen was obtained from the Person.

specimen_datetime

timestamp

The date and time on the date when the Specimen was obtained from the person.

specimen_id

integer

A unique identifier for each specimen.

specimen_source_id

string

The Specimen identifier as it appears in the source data.

specimen_source_value

string

The Specimen value as it appears in the source data. This value is mapped to a Standard Concept in the Standardized Vocabularies and the original code is, stored here for reference.

specimen_type_concept_id

integer

A foreign key referring to the Concept identifier in the Standardized Vocabularies reflecting the system of record from which the Specimen was represented in the source data.

unit_concept_id

integer

A foreign key to a Standard Concept identifier for the Unit associated with the numeric quantity of the Specimen collection.

unit_source_value

string

The information about the Unit as detailed in the source.

Table ID	Table	Title
924	omop_condition_era	OMOP Condition Era
925	omop_condition_occurrence	OMOP Condition Occurrence
926	omop_death	OMOP Death
927	omop_device_exposure	OMOP Device Exposure
928	omop_dose_era	OMOP Dose Era
929	omop_drug_era	OMOP Drug Era
930	omop_drug_exposure	OMOP Drug Exposure
931	omop_measurement	OMOP Measurement
932	omop_note	OMOP Note
933	omop_observation	OMOP Observation Period
934	omop_observation_period	OMOP Observation
935	omop_person	OMOP Person
936	omop_procedure_occurrence	OMOP Procedure Occurrence
938	omop_visit_detail	OMOP Visit Detail
939	omop_visit_occurrence	OMOP Visit Occurrence

Table ID

Table

Title

924

omop_condition_era

OMOP Condition Era

925

omop_condition_occurrence

OMOP Condition Occurrence

926

omop_death

OMOP Death