1. Administrator's Guide
  2. Manage access to patient or subject records and PII
  3. Import subject and patient data to the Cohort Data Model

Import subject and patient data to the Cohort Data Model

To make subject and patient data available in Oracle Healthcare Translational Research (OHTR):

  1. Load the data into Oracle Healthcare Data Warehouse (HDM) using the Healthcare Data Interface tables (HDI).
  2. Propagate the data to the Cohort Data Model (CDM) using either Informatica or Oracle Data Integrator (ODI) ETLs.

Instructions for loading data can be found in the Oracle Healthcare Foundation Administrator's Guide for Informatica and for Oracle Data Integrator. The guides are available in password-protected patch 22640545. To get the password, log a Service Request (SR) on My Oracle Support.

Note:

In the Single Patient Viewer screen, the consent records are displayed only if a valid Data Source Number is populated in the W_EHA_CONSENT_PATIENT_H.DATASOURCE_NUM_ID column. Make sure that the value populated in this column exists in the W_EHA_DATASOURCE_CDM.ROW_WID column, as well.

Parent topic: Manage access to patient or subject records and PII