# How added columns are populated

How added columns are populated

Column | How it is populated
--- | ---
PATIENT_ID | PATIENT_ID is derived from PERSON_ID by converting to a VARCHAR2. The string is zero-filled to maintain sort order in the Empirica Healthcare Analysis application. A leading 1 is prepended to the value because the Empirica Healthcare Analysis application requires this format. The maximum number of allowed digits in PATIENT_ID is 10 and in PERSON_ID is 9.
(Multiple columns used for coded fields) | <value>_CD fields, such as RACE_CD, are derived by selecting the CONCEPT_NAME from the CONCEPT table, based on the value of the corresponding <value>_concept_id field.
ENROLLMENT_START_DATE ENROLLMENT_END_DATE | The SELECTED_OBSERVATION_PERIOD view is created and contains one row for each person, with the OBSERVATION_START_DATE and OBSERVATION_END_DATE for the longest enrollment period (as determined by subtracting START_DATE from END_DATE). If more than one record exists with the longest duration, the earliest observation period is selected.
AGE | Age, in years, is either derived or populated: If compute_age in the etl.properties field is set to 'Y', this value is either derived by subtracting YEAR_OF_BIRTH from the year part of ENROLLMENT_START_DATE, or populated with values from the database field that you specify in age_column. If compute_age is set to 'N' and you specify a column name in age_column in the etl.properties file, this field is populated with values from the database field that you specify. If compute_age is set to 'N' and you do not specify a column name in age_column, this field is null.
AGE_GROUP | AGE_GROUP is derived from AGE when compute_age in the etl.properties file is set to ‘Y’. Each patient has one of the following values: '00-04' '05-14' '15-17' '18-24' '25-34' '35-44' '45-64'; ‘65+’ 'UNK' (if AGE is null) When compute_age is set to 'N', this field is null.
DURATION | Duration is derived by subtracting DRUG_ERA_START_DATE from DRUG_ERA_END_DATE + 1.

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