# Columns that are added when data is transformed

The following columns are added in the Empirica Healthcare Analysis database and populated during the data transformation step.

Columns that are added when data is transformed

Table | Added column | Nulls allowed? | Based on
--- | --- | --- | ---
All Tables | PATIENT_ID | No | PERSON_ID
PERSON | GENDER_CD | No | GENDER_CONCEPT_ID
PERSON | RACE_CD | Yes | RACE_CONCEPT_ID
PERSON | ETHNICITY_CD | Yes | ETHNICITY_CONCEPT_ID
PERSON | ENROLLMENT_START_DATE | No | Observation Periods
PERSON | ENROLLMENT_END_DATE | No | Observation Periods
PERSON | AGE | Yes | ENROLLMENT_START_DATE, YEAR_OF_BIRTH
PERSON | AGE_GROUP | Yes | AGE
DRUG_ERA, DRUG_EXPOSURE | DRUG_TYPE_CD | Yes | DRUG_TYPE_CONCEPT_ID
DRUG_ERA | DURATION | No | DRUG_ERA_START_DATE DRUG_ERA_END_DATE
DRUG_EXPOSURE | RELEVANT_CONDITION_CD | Yes | RELEVANT_CONDITION_CONCEPT_ID
CONDITION_ERA, CONDITION_OCCURRENCE | CONDITION_TYPE_CD | Yes | CONDITION_TYPE_CONCEPT_ID
PROCEDURE_OCCURRENCE | PROCEDURE_TYPE_CD | Yes | PROCEDURE_TYPE_CONCEPT_ID
PROCEDURE_OCCURRENCE | RELEVANT_CONDITION_CD | Yes | RELEVANT_CONDITION_CONCEPT_ID

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