5 Verifying an Oracle Health Sciences Cohort Explorer Installation

This chapter describes the components of the application after a successful installation. Verify that they are available after installation.

This chapter includes the following sections:

• "OHSCE Database Components"

• "ODI Repository Components"

OHSCE Database Components

After a successful installation of the Master Install Script, you can view the following components in the Oracle HSCE data mart schema.

• The following 33 data model tables containing patient-related medical information. When ODI packages are executed, data is loaded into these tables from HDWF:

  W_EHA_ANATOMICAL_SITE_D

  W_EHA_CONSENT_D

  W_EHA_CONSENT_PATIENT_H

  W_EHA_CONSENT_STATUS_D

  W_EHA_DIAGNOSIS_D

  W_EHA_DIAGNOSIS_STATUS_D

  W_EHA_DIAGNOSTIC_TEST_D

  W_EHA_DIAGTST_PATIENT_H

  W_EHA_DIAGTST_PROC_DHL

  W_EHA_DIAGTST_SPEC_DHL

  W_EHA_DIAGTST_SUBADM_DHL

  W_EHA_DX_PATIENT_H

  W_EHA_ETHNICITY_D

  W_EHA_ETHN_PATIENT_H

  W_EHA_MEDICATION_D

  W_EHA_PATIENT_HISTORY_D

  W_EHA_PROCEDURE_D

  W_EHA_PROCEDURE_TYPE_D

  W_EHA_PROC_PATIENT_H

  W_EHA_PROC_SUBADMN_DHL

  W_EHA_PROC_TYPE_PROC_DHL

  W_EHA_PROTOCOL_D

  W_EHA_PROTOCOL_PATIENT_H

  W_EHA_PT_HISTORY_PT_H

  W_EHA_RACE_D

  W_EHA_RACE_PATIENT_H

  W_EHA_RESEARCH_PATIENT_D

  W_EHA_RESEARCH_PATIENT_F

  W_EHA_SPECIMEN_D

  W_EHA_SPECIMEN_PATIENT_H

  W_EHA_SUBADMN_PATIENT_H

  W_EHA_UOM_D

  W_USER_D

• The following configuration tables used by ETL:

  C_COHORT_PROCEDURE_TYPE

  C_LOAD_PARAM

  C_LOAD_DATES

  C_LOAD_DE_IDENTIFY

• The following view used by ETL:

  W_EHA_RESEARCH_PATIENT_V

• The following procedures used by ETL:

  ETL_POSTPROCESSOR()

  NAV_RECORD_UPDATE()

  SEED_NA_RECORDS()

  SEED_NOT_AVAILABLE_RECORDS()

• The following functions used by ETL:

  CUSTOM_HDM_DATE_DE_IDENTIFY()

  CUSTOM_HDM_NUMBER_DE_IDENTIFY()

  CUSTOM_HDM_STRING_DE_IDENTIFY()

  GETCOLDATATYPE()

ODI Repository Components

This section describes the organization of an ODI project in this application. All related ODI objects are organized within ODI folders in a particular hierarchy. Each folder contains various objects as described below.

This section describes the following:

• ODI Master Repository Components

• ODI Work Repository Components

ODI Master Repository Components

The ODI master repository contains topology information such as contexts, physical architecture components such as agents, technologies and logical architecture components such as agents and technologies.

Topology information:

• Contexts— Global

• Physical Architecture Agents: LOCALHOST_20910

• Physical Architecture Technologies: ORACLE_HDM, ORACLE_DATAMART, ORACLE_TEMP_DATAMART

• Logical Architecture Agents: LOCALHOST_20910

• Logical Architecture Technologies: ORACLE_SOURCE, ORACLE_TARGET

You can choose to use the existing topology and update it according to your system and database configurations, or create a new set of these components. See the sections on configuration for instructions.

ODI Work Repository Components

This repository contains ODI objects such as folders, packages, interfaces, variables, sequences and functions organized in the following manner:

The project OracleHealthcareAnalytics under the Project tab, contains the following folders:

• Execution Plans containing the following sub folders.

  Initial Setup

  Level1_Load_User_Dimension

  Level2_Load_All_Other_Dimensions_And_Patient_Fact

  Level3_Load_All_Bridge_Tables

  Level4_Load_Unspecified_Records_For_Bridge_Tables

  Level5_Load_Protocol_Tables

  Master_Execution_plan

• Mappings containing the following sub folders.

  Dimensions

  Facts

• Variables containing 73 variables.

  Dimensions

  Facts

• Sequence containing 31 sequences.

  Dimensions

  Facts

• User Functions containing one function—UserWID.

  LKM TMP APPS Oracle to Oracle (DBLINK)

  CKM Oracle

  IKM TMP APPS Oracle Control Append

  IKM TMP APPS Oracle Incremental Update

The Models tab contains a folder—Oracle Healthcare Analytics, which in turn contains 3 models.

• Oracle Configuration Tables

• Oracle HDM

• Oracle TMPAPPS Data mart

The Others tab contains 8 Global User Functions as follows:

• TO_CHAR_FORMAT()

• %NOW%()

• ADD_TO_DATE()

• SESSSTARTTIME()

• COALESCE()

• NEXTVAL()

• GET_SCEN_NAME()

• QUALIFY()

The screenshot depicts the organization structure described above for the W_EHA_ANATOMICAL_SITE_D table.

Figure 5-1 Organization Structure of an ODI Work Repository

Description of "Figure 5-1 Organization Structure of an ODI Work Repository"