: Record Table 928

Record Table 928

Title:	OMOP Dose Era
Access field:	20142 (Present in OMOP dataset)

Table name

omop_dose_era

Table group

OMOP

Debut

Feb 2023

Row count

34,000+

Parent table

n/a

Version

Sep 2024

Size

1MB

Stability

Complete

Cost Tier

dX o2 s2

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

WARNING: the interactive features of this website use CSS3, which your browser does not support. To use the full features of this website, please update your browser.

Notes

A Dose Era is defined as a span of time when the Person is assumed to be exposed to a constant dose of a specific active ingredient. These are detailed in the omop_dose_era table.
Further details can be found in the OMOP CDM Standardized Derived Elements specifications - https://ohdsi.github.io/CommonDataModel/cdm53.html#DOSE_ERA
Due to some data quality issues identified by research groups who have been using the returned OMOP derivation dataset, the record-level tables are now restricted. Please see Field 20142 for more information.

7 Columns

#	Column	Type	Notes
1	dose_era_end_date	date	The end date for the drug era constructed from the individual instance of drug exposures. It is the end date of the final continuously recorded instance of utilization of a drug.
2	dose_era_id	integer	A unique identifier for each Dose Era.
3	dose_era_start_date	date	The start date for the drug era constructed from the individual instances of drug exposures. It is the start date of the very first chronologically recorded instance of utilization of a drug.
4	dose_value	integer	The numeric value of the dose.
5	drug_concept_id	integer	A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies for the active Ingredient Concept.
6	eid	integer	A foreign key identifier to the Person who is subjected to the drug during the drug era.
7	unit_concept_id	integer	A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies for the unit concept.

15 Related OMOP Record Tables

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
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
937	omop_specimen	OMOP Specimen
938	omop_visit_detail	OMOP Visit Detail
939	omop_visit_occurrence	OMOP Visit Occurrence

Enabling scientific discoveries that improve human health