# CFG_EXP

The CFG_EXP table is created in the destination account.

The table contains the following rows in the following tables. The Patient Id table row indicates whether a Patient Id table is required and created for the variable. Patient Id tables and Index tables are created as needed because the Empirica Healthcare Analysis application requires them.

Rows created based on the PERSON table

The following rows appear in this table for all imports.

PERSON table

Variable | Description | Table | Column | Variable type | Selection type | Patient Id table
--- | --- | --- | --- | --- | --- | ---
Patient Id | Unique identifier of individual | PERSON | PATIENT_ID | Patient ID | Free Text |
Gender | Patient gender | PERSON | GENDER_CD | Gender| Stratification | Distinct Value List | Yes
Race | Patient race | PERSON | RACE_CD | Other | Distinct Value List |
Ethnicity | Patient ethnicity | PERSON | ETHNICITY_CD | Other | Distinct Value List |
Enrollment Start | Enrollment start date | PERSON | ENROLLMENT_START_DATE | Other (Enrollment Start Date) | Continuous |
Enrollment End | Enrollment end date | PERSON | ENROLLMENT_END_DATE | Other (Enrollment End Date | Continuous |
Year of birth | Year of birth | PERSON | YEAR_OF_BIRTH | Other | Continuous |
Month of birth | Month of birth | PERSON | MONTH_OF_BIRTH | Other | Continuous |
Day of Birth | Day of birth | PERSON | DAY_OF_BIRTH | Other | Continuous |
Age | Age at enrollment start | PERSON | AGE | Age (Age at enroll-start) | Continuous |
Age Group | Patient age group | PERSON | AGE_GROUP | Other| Stratification | Distinct Value List | Yes

Notes:

- The Age Group variable has a report_id_table only when compute_age in the etl.properties file is set to 'Y'.
- For variables of type Drug, Event, and Procedure, the prefix attribute is D, E, and P, respectively.

Rows created based on the DRUG_EXPOSURE table

The following rows appear in this table if you imported the DRUG_EXPOSURE table.

DRUG_EXPOSURE table

Variable | Description | Table | Column | Variable type | Selection type | Patient Id table
--- | --- | --- | --- | --- | --- | ---
Patient Id (Drug) | Unique identifier of individual | DRUG_EXPOSURE_VIEW | PATIENT_ID | Patient ID | Free Text |
Drug Start Date | Drug start date | DRUG_EXPOSURE_VIEW | DRUG_EXPOSURE_START_DATE | Record Date | Continuous |
Drug End Date | Drug end date | DRUG_EXPOSURE_VIEW | DRUG_EXPOSURE_END_DATE | Other | Continuous |
Drug Code | Drug code | DRUG_EXPOSURE_VIEW | DRUG_CD | Other | Distinct Value List |
Drug Name | Drug name | DRUG_EXPOSURE_VIEW | DRUG_NAME | Drug | Distinct Value List | Yes
Drug Label | Drug name label | DRUG_EXPOSURE_VIEW | DRUG_NAME | Other (Drug Label) | Distinct Value List |
Drug Exposure Type | Drug exposure type | DRUG_EXPOSURE_VIEW | DRUG_TYPE_CD | Other | Distinct Value List |
Days Supply | Days supply | DRUG_EXPOSURE_VIEW | DAYS_SUPPLY | Record Duration | Continuous |
Stop Reason (Drug) | Stop reason | DRUG_EXPOSURE_VIEW | STOP_REASON | Other | Free Text |
Refills | Refill count | DRUG_EXPOSURE_VIEW | REFILLS | Other | Continuous |
Quantity | Quantity | DRUG_EXPOSURE_VIEW | QUANTITY | Other | Continuous |
SIG | SIG | DRUG_EXPOSURE_VIEW | SIG | Other | Free Text |
Relevant Condition Code | Relevant condition code | DRUG_EXPOSURE_VIEW | RELEVANT_CONDITION_CD | Other | Distinct Value List |

Rows created based on the CONDITION_ERA table

If you imported the CONDITION_ERA table, the following rows appear in this table.

CONDITION_ERA table

Variable | Description | Table | Column | Variable type | Selection type | Patient Id table
--- | --- | --- | --- | --- | --- | ---
Patient Id (Condition) | Unique identifier of individual | CONDITION_ERA_VIEW | PATIENT_ID | Patient ID | Free Text |
Condition Start Date | Condition start date | CONDITION_ERA_VIEW | CONDITION_ERA_START_DATE | Record Date | Continuous |
Condition End Date | Condition end date | CONDITION_ERA_VIEW | CONDITION_ERA_END_DATE | Other | Continuous |
Condition Code | Condition code | CONDITION_ERA_VIEW | CONDITION_CD | Other | Distinct Value List |
Condition Name | Condition name | CONDITION_ERA_VIEW | CONDITION_NAME | Event | Distinct Value List | Yes
Condition Label | Condition name label | CONDITION_ERA_VIEW | CONDITION_NAME | Other (Event Label) | Distinct Value List |
Condition Type | Condition type | CONDITION_ERA_VIEW | CONDITION_TYPE_CD | Other | Distinct Value List |
Occurrence Count | Condition occurrence count | CONDITION_ERA_VIEW | CONDITION_OCCURRENCE_COUNT | Other | Continuous |

Rows created based on the CONDITION_OCCURRENCE table

If you imported the CONDITION_OCCURRENCE table, the following rows appear in this table.

CONDITION_OCCURRENCE table

Variable | Description | Table | Column | Variable type | Selection type | Patient Id table
--- | --- | --- | --- | --- | --- | ---
Patient Id (Condition) | Unique identifier of individual | CONDITION_OCCURRENCE_VIEW | PATIENT_ID | Patient ID | Free Text |
Condition Start Date | Condition start date | CONDITION_OCCURRENCE_VIEW | CONDITION_START_DATE | Record Date | Continuous |
Condition End Date | Condition end date | CONDITION_OCCURRENCE_VIEW | CONDITION_END_DATE | Other | Continuous |
Condition Code | Condition code | CONDITION_OCCURRENCE_VIEW | CONDITION_CD | Other | Distinct Value List |
Condition Name | Condition name | CONDITION_OCCURRENCE_VIEW | CONDITION_NAME | Event | Distinct Value List | Yes
Condition Label | Condition name label | CONDITION_OCCURRENCE_VIEW | CONDITION_NAME | Other (Event Label) | Distinct Value List |
Condition Type | Condition type | CONDITION_OCCURRENCE_VIEW | CONDITION_TYPE_CD | Other | Distinct Value List |
Stop Reason (Condition) | Stop reason | CONDITION_OCCURRENCE_VIEW | STOP_REASON | Other | Free Text |

Rows created based on the PROCEDURE_OCCURRENCE table

If you imported the PROCEDURE_OCCURRENCE table, the following rows appear in this table.

PROCEDURE_OCCURRENCE table

Name | Description | Table | Column | Variable type | Selection type | Patient Id Table
--- | --- | --- | --- | --- | --- | ---
Patient Id (Procedure) | Unique identifier of individual | PROCEDURE_OCCURRENCE_VIEW | PATIENT_ID | Patient ID | Free Text |
Procedure Date | Procedure date | PROCEDURE_OCCURRENCE_VIEW | PROCEDURE_DATE | Record Date | Continuous |
Procedure Code | Procedure code | PROCEDURE_OCCURRENCE_VIEW | PROCEDURE _CD | Other | Distinct Value List |
Procedure Name | Procedure name | PROCEDURE_OCCURRENCE_VIEW | PROCEDURE _NAME | Event (Procedure) | Distinct Value List | Yes
Procedure Label | Procedure name label | PROCEDURE_OCCURRENCE_VIEW | PROCEDURE _NAME | Other (Proc Label) | Distinct Value List |
Procedure Type | Procedure type | PROCEDURE_OCCURRENCE_VIEW | PROCEDURE _TYPE_CD | Other | Distinct Value List |
Relevant Condition Code (Procedure) | Relevant condition code | PROCEDURE_OCCURRENCE_VIEW | RELEVANT_CONDITION_CD | Other | Distinct Value List |

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