B Oracle Healthcare Data Warehouse Foundation Tables

This appendix includes the following sections:

• "Mandatory Oracle Healthcare Data Warehouse Foundation Code Types Table"

• "Oracle Healthcare Data Warehouse Foundation Physical Table"

Mandatory Oracle Healthcare Data Warehouse Foundation Code Types Table

Oracle Healthcare Data Warehouse Foundation (HDWF) mandatory Code Types require configuration from source system(s) to populate respective Cohort data mart tables.

Table B-1 Mandatory HDWF Code Types Tables

OHSCE Data Mart Table(s)	Code Type	Description	Sample Value
W_EHA_RESEARCH_PATIENT_D	ADDRESS_STATUS_CODE	The coded representation of the status of the address.	For example, current, active, and inactive.
W_EHA_RESEARCH_PATIENT_D	ADDRESS_TYPE	The type of address.	For example, Mailing, Business, and Home.
W_EHA_UOM_D	AGE_AT_FIRST_ONSET_UOM_CODE	The coded representation of the unit of measure for the age at first onset value as it pertains to the diagnosis.	For example, Years, Months, Days, and Hours.
W_EHA_ANATOMICAL_SITE_D W_EHA_SPECIMEN_PATIENT_H	ANATOMICAL_SITE_CODE	The coded representation of the anatomical site for the diagnosis, specimen, etc.	For example, Arterial system structure.
W_EHA_CONSENT_STATUS_D	CONSENT_STATUS_CODE	The coded representation of the status of the consent form.	For example, Active, and Not Active.
W_EHA_CONSENT_D	CONSENT_TYPE	The coded representation of the type of the consent.	For example, Surgical, Study, Blood Products, and Special Procedure.
W_EHA_RESEARCH_PATIENT_D	COUNTRY_CODE	The coded representation of the country in which the patient is located.	For example, United States, and Canada.
W_EHA_DIAGNOSIS_D W_EHA_DX_PATIENT_H	DIAGNOSIS_CODE	The coded representation of the diagnosis.	For example, Leukemia.
W_EHA_DIAGNOSIS_STATUS_D W_EHA_DX_PATIENT_H	DIAGNOSIS_STATUS_CODE	The coded representation of the status of the diagnosis.	For example, recurrent, active, and not active.
W_EHA_DIAGNOSTIC_TEST_D W_EHA_DIAGTST_PATIENT_H W_EHA_DIAGTST_SPEC_DHL W_EHA_DIAGTST_SUBADM_DHL	DIAGNOSTIC_TEST_CODE	The coded representation of the diagnostic test.	For example, Chest x-ray.
W_EHA_UOM_D	DOSE_UOM_CODE	The coded representation of the unit of measure of the dose of substance administered.	For example, milligrams and grams.
W_EHA_ETHNICITY_D	ETHNICITY_CODE	The coded representation that best describes the ethnic origin of the patient.	For example, "1" = Spanish/Hispanic Origin, "2" = Not of Spanish/Hispanic Origin, "9" = Unknown
W_EHA_UOM_D	FREQUENCY_UOM_CODE	The coded representation of the units of measure for the substance frequency.	For example, BID = Twice a Day.
W_EHA_ETHNICITY_D	GENDER_CODE	The coded representation that best describes the gender of the patient.	For example, "M" = Male, "F" = Female.
W_EHA_DIAGTST_PROC_DHL	INTERVENTION_OBSERVATION_RELATIONSHIP_TYPE	The coded representation of the relationship type between the diagnostic test and respective results.	For example, Resulting.
W_EHA_RESEARCH_PATIENT_D	MARITAL_STATUS_CODE	The coded representation of the patient's marital (civil) status.	For example, Married and Unmarried.
W_EHA_MEDICATION_D W_EHA_SUBADMN_PATIENT_H W_EHA_PROC_SUBADMN_DHL	MEDICATION_CODE	The coded representation of the generic names associated with a medication.	For example, the second segment of numbers in an NDC. 451 from 50580-451-03 signifies 500 mg Acetaminophen.
W_EHA_UOM_D	OBSERVATION_VALUE_UOM_CODE	The coded representation of the unit or measure of a numeric value for an test result.	For example, mg/dl.
W_EHA_PATIENT_HISTORY_D	PATIENT_HISTORY_CODE	The coded representation of the representation of the type of Patient History.	For example, Tobacco Use, Alcohol Use.
W_EHA_PROCEDURE_D W_EHA_PROC_PATIENT_H W_EHA_PROC_SUBADMN_DHL W_EHA_DIAGTST_PROC_DHL	PROCEDURE_CODE	The coded representation of the procedure.	For example, brain tumor resection.
W_EHA_RACE_D	RACE_CODE	The coded representation that best describes the race of the party.	For example, "01" = White, "02" = African American (Black), "03" = Native American (American, Indian/Eskimo/Aleut), "04" = Asian, "05" = Native Hawaiian or Other Pacific Islander, "88" = Other Race, "99" = Unknown
W_EHA_DIAGTST_SUBADM_DHL W_EHA_PROC_SUBADMN_DHL	RELATED_INTERVENTION_RELATIONSHIP_TYPE	The coded representation of the relationship type between the diagnostic test or procedure (intervention) and medications or results respectively.	For example, Pre, Intra and Post Intervention Medication; or Pre, Intra, Post Intervention Diagnostic Test.
W_EHA_UOM_D	SPECIMEN_QUANTITY_UOM_CODE	The coded representation of the units for measure for the amount of specimen collected.	For example, millimoles/liter, and mg/dL.
W_EHA_SPECIMEN_D	SPECIMEN_TYPE_CODE	The coded representation of the type of Specimen.	For example, Blood, Urine, and Sputum.
W_EHA_RESEARCH_PATIENT_D	STATE_CODE	The coded representation of the code for state within a country.	For example, AZ, CO, MO, and CA.
W_EHA_RESEARCH_PATIENT_D	POSTAL_CODE	The coded representation of the Zip Code assigned by the Postal Service to the patient's principal residence.	For example, 33101.

Oracle Healthcare Data Warehouse Foundation Physical Table

You must load the following HDWF physical tables for OHSCE to function properly.

Table B-2 HDWF Physical Tables

HDWF Physical Table Name	HDWF Logical Entity Name
HDM_CD_HIER	Code Hierarchy
HDM_CD_REPOSITORY	Code Repository
HDM_CD_REPOSITORY_CD_TYP	Code Repository Code Type
HDM_CD_SYS	Code system
HDM_CD_TYP	Code Type
HDM_CNRN	Concern
HDM_CNRN_ANATSITE	Concern Anatomical Site
HDM_CNSNT	Consent
HDM_IND_PRTY	Individual Party
HDM_IND_PRTY_ETHN	Individual Party Ethnicity
HDM_IND_PRTY_RC	Individual Party Race
HDM_INTVN	Intervention
HDM_INTVN_OBSV	Intervention Observations
HDM_INTVN_SUBST	Intervention Substance
HDM_OBSV	Observation
HDM_PRTY_ADDR	Party Address
HDM_PT	Patient
HDM_PT_HX	Patient History
HDM_RELTD_INTVN	Related Intervention
HDM_SPCMN	Specimen
HDM_SUBADMN	Substance Administration
HDM_SUBST_HX	Substance History