| Title: | OMOP Drug Era |
| Access field: | 20142 (Present in OMOP dataset) |
| Table name | omop_drug_era | Table group | OMOP | Debut | Feb 2023 | ||
| Row count | 19,000,000+ | Parent table | n/a | Version | Mar 2023 | ||
| Size | 988MB | Stability | Complete | Cost Tier | d2 o2 s2 |
Record Table 929
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 Drug Era is defined as a span of time when the Person is assumed to be exposed to a particular active ingredient. A Drug Era is not the same as a Drug Exposure. Drug Eras are detailed in the omop_drug_era table.Further details can be found in the OMOP CDM Standardized Derived Elements specifications - https://ohdsi.github.io/CommonDataModel/cdm53.html#DRUG_ERA
7 Columns
| # | Column | Type | Notes |
|---|---|---|---|
| 1 | drug_concept_id | integer | A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies for the Ingredient Concept. |
| 2 | drug_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. |
| 3 | drug_era_id | integer | A unique identifier for each Drug Era. |
| 4 | drug_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 conutilization of a Drug. |
| 5 | drug_exposure_count | integer | The number of individual Drug Exposure occurrences used to construct the Drug Era. |
| 6 | gap_days | integer | The number of days that are not covered by DRUG_EXPOSURE records that were used to make up the era record. |
| 7 | person_id | integer | A foreign key identifier to the Person who is subjected to the Drug during the Drug Era. |
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 |
| 928 | omop_dose_era | OMOP Dose 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