# Required columns

For each of the following source tables, the Empirica Healthcare Analysis application requires the following columns and requires that they be non-null. All columns except DRUG_EXPOSURE.DAYS_SUPPLY are also required by the OMOP Common Data Model.

The validation step in the ETL utility checks whether NOT NULL constraints exist on each of the following columns. If the constraints do not exist, the ETL utility creates them in the transferred data.

Required columns

Source table | Columns
--- | ---
PERSON | PERSON_ID GENDER_CONCEPT_ID YEAR_OF_BIRTH
OBSERVATION_PERIOD | PERSON_ID OBSERVATION_PERIOD_START_DATE OBSERVATION_PERIOD_END_DATE
DRUG_ERA | PERSON_ID DRUG_CONCEPT_ID DRUG_ERA_START_DATE DRUG_ERA_END_DATE
DRUG_EXPOSURE | PERSON_ID DRUG_CONCEPT_ID DRUG_EXPOSURE_START_DATE DAYS_SUPPLY
CONDITION_ERA | PERSON_ID CONDITION_CONCEPT_ID CONDITION_ERA_START_DATE
CONDITION_OCCURRENCE | PERSON_ID CONDITION_CONCEPT_ID CONDITION_START_DATE
PROCEDURE_OCCURENCE | PERSON_ID PROCEDURE_CONCEPT_ID PROCEDURE_DATE

Copyright © 2015 Oracle and/or its affiliates. All rights reserved.