# Tables that are copied from the source database

Your source data and vocabulary information in the OMOP Common Data Model (CDM) might be in separate accounts or in the same account. One account is created to hold all CDM data in the destination database, which is the Empirica Healthcare Analysis database.

The following table lists the tables that you can transfer to the account that is created by the ETL utility in the Empirica Healthcare Analysis database. The Empirica Healthcare Analysis application supports only these tables.

When you set installation and data transfer settings, you specify the tables to transfer.

Tables you may transfer from the source database

Table | Contains | Contents of the table | Source account
--- | --- | --- | ---
PERSON | Patient information | One record per patient. | Data
OBSERVATION_PERIOD | Date ranges during which data has been collected | Might contain more than one record per patient. | Data
DRUG_ERA | Drug information | One row per each span of time when a person is exposed to a drug. | Data
DRUG_EXPOSURE | Drug information | One record for each dispensation of a drug. | Data
CONDITION_ERA | Condition information | Information about the chronological period of condition occurrence combining individual occurrences into a single era. | Data
CONDITION_OCCURRENCE | Condition information | One record for each condition. | Data
PROCEDURE_OCCURRENCE | Procedure information | One record for each procedure. | Data
CONCEPT | Coded field translations | One record for each code. All codes are stored in the same table. | Vocabulary

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