| Oracle® Health Sciences Cohort Explorer Administrator's Guide Release 1.0 E24438-01 |
|
|
PDF · Mobi · ePub |
| Oracle® Health Sciences Cohort Explorer Administrator's Guide Release 1.0 E24438-01 |
|
|
PDF · Mobi · ePub |
The appendix contains the following topics:
Following is the list of variables in ODI repository:
| Variable Name |
|---|
|
ADDR_STATUS_CODE |
|
AGE_AT_FIRST_ONSET_FLG |
|
AGE_AT_FIRST_ONSET_VALUE |
|
ANATOMICAL_SITE_CATEGORY |
|
ANATOMICAL_SITE_CODE |
|
CITY_FLG |
|
CITY_VALUE |
|
CNSNT_EFF_END_DT_FLG |
|
CNSNT_EFF_END_DT_VALUE |
|
CNSNT_EFF_STRT_DT_FLG |
|
CNSNT_EFF_STRT_DT_VALUE |
|
CONSENT_STATUS_CODE |
|
CONSENT_TYPE_CODE |
|
DECEASED_DT_FLG |
|
DECEASED_DT_VALUE |
|
DEFAULT_WID |
|
DIAGNOSIS_CATEGORY |
|
DIAGNOSIS_CODE |
|
DIAGNOSIS_END_DT_FLG |
|
DIAGNOSIS_END_DT_VALUE |
|
DIAGNOSIS_ONSET_DT_FLG |
|
DIAGNOSIS_ONSET_DT_VALUE |
|
DIAGNOSIS_REPORTED_DT_FLG |
|
DIAGNOSIS_REPORTED_DT_VALUE |
|
DIAGNOSIS_STATUS_CODE |
|
DIAGNOSTIC_TEST |
|
DIAGNOSTIC_TEST_CODE |
|
DIAGTST_DT_FLG |
|
DIAGTST_DT_VALUE |
|
DOB_DATE_FLG |
|
DOB_DATE_VALUE |
|
ETHNICITY_CODE |
|
ETL_PROC_WID |
|
HIERARCHY_NAME |
|
HOME_ADDR_TYP |
|
INTRA_INTERVENTION_DIAGNOSTIC_TEST_CODE |
|
INTRA_INTERVENTION_MEDICATION |
|
INTVN_END_DT_FLG |
|
INTVN_END_DT_VALUE |
|
INTVN_STRT_DT_FLG |
|
INTVN_STRT_DT_VALUE |
|
IS_INCREMENTAL |
|
LAST_EXTRACT_DATE |
|
MEDICATION_CODE |
|
MEDICATION_RELSHP_CODE |
|
PATIENT_HISTORY_CODE |
|
PATIENT_HISTORY_END_DT_FLG |
|
PATIENT_HISTORY_END_DT_VALUE |
|
PATIENT_HISTORY_START_DT_FLG |
|
PATIENT_HISTORY_START_DT_VALUE |
|
POSTAL_CODE_FLG |
|
POSTAL_CODE_VALUE |
|
POST_INTERVENTION_DIAGNOSTIC_TEST_CODE |
|
POST_INTERVENTION_MEDICATION |
|
PRE_INTERVENTION_DIAGNOSTIC_TEST_CODE |
|
PRE_INTERVENTION_MEDICATION |
|
PROCEDURE_CODE |
|
PROCEDURE_END_DT_FLG |
|
PROCEDURE_END_DT_VALUE |
|
PROCEDURE_START_DT_FLG |
|
PROCEDURE_START_DT_VALUE |
|
RACE_CODE |
|
RESULTING_CODE |
|
SEPERATOR |
|
SPECIMEN_COLLECTION_DT_FLG |
|
SPECIMEN_COLLECTION_DT_VALUE |
|
SPECIMEN_TYPE_CODE |
|
SUBADMN_END_DT_FLG |
|
SUBADMN_END_DT_VALUE |
|
SUBADMN_START_DT_FLG |
|
SUBADMN_START_DT_VALUE |
|
TENANT_ID |
|
UOM_CODE |
Following is the list of sequences in ODI repository:
| Sequence Name |
|---|
|
W_EHA_ANATOMICAL_SITE_D_S |
|
W_EHA_CONSENT_D_S |
|
W_EHA_CONSENT_PATIENT_H_S |
|
W_EHA_CONSENT_STATUS_D_S |
|
W_EHA_DIAGNOSIS_D_S |
|
W_EHA_DIAGNOSIS_STATUS_D_S |
|
W_EHA_DIAGNOSTIC_TEST_D_S |
|
W_EHA_DIAGTST_PATIENT_H_S |
|
W_EHA_DIAGTST_PROC_DHL_S |
|
W_EHA_DIAGTST_SPEC_DHL_S |
|
W_EHA_DIAGTST_SUBADM_DHL_S |
|
W_EHA_DX_PATIENT_H_S |
|
W_EHA_ETHNICITY_D_S |
|
W_EHA_ETHN_PATIENT_H_S |
|
W_EHA_MEDICATION_D_S |
|
W_EHA_PATIENT_HISTORY_D_S |
|
W_EHA_PROCEDURE_D_S |
|
W_EHA_PROCEDURE_TYPE_D_S |
|
W_EHA_PROC_PATIENT_H_S |
|
W_EHA_PROC_SUBADMN_DHL_S |
|
W_EHA_PROC_TYPE_PROC_DHL_S |
|
W_EHA_PT_HISTORY_PT_H_S |
|
W_EHA_RACE_D_S |
|
W_EHA_RACE_PATIENT_H_S |
|
W_EHA_RESEARCH_PATIENT_D_S |
|
W_EHA_RESEARCH_PATIENT_F_S |
|
W_EHA_SPECIMEN_D_S |
|
W_EHA_SPECIMEN_PATIENT_H_S |
|
W_EHA_SUBADMN_PATIENT_H_S |
|
W_EHA_UOM_D_S |
|
W_USER_D_S |
The following table lists ODI repository interfaces and the folder or package containing the interface.
| Interface Name | Folder or Package Containing the Interface |
|---|---|
|
INT_TMPAPPS_Research_Patient_F |
Load_Research_Patient_Fact |
|
INT_TMPAPPS_Research_Patient_F_Full |
Load_Research_Patient_Fact |
|
INT_TMPAPPS_Patient_History_D |
Load_Patient_History_Dimension |
|
INT_TMPAPPS_Patient_History_D_Full |
Load_Patient_History_Dimension |
|
INT_TMPAPPS_Consent_Patient_H_Full |
Load_Consent_Patient_Bridge |
|
INT_TMPAPPS_Consent_Patient_H |
Load_Consent_Patient_Bridge |
|
INT_TMPAPPS_Subadmn_Patient_H |
Load_Subadmn_Patient_Bridge |
|
INT_TMPAPPS_Subadmn_Patient_H_Full |
Load_Subadmn_Patient_Bridge |
|
INT_TMPAPPS_Diagnosis_Status_D |
Load_Diagnosis_Status_Dimension |
|
INT_TMPAPPS_Diagnosis_Status_D_Full |
Load_Diagnosis_Status_Dimension |
|
INT_TMPAPPS_Race_D |
Load_Race_Dimension |
|
INT_TMPAPPS_Race_D_Full |
Load_Race_Dimension |
|
INT_TMPAPPS_Specimen_D |
Load_Specimen_Dimension |
|
INT_TMPAPPS_Specimen_D_Full |
Load_Specimen_Dimension |
|
INT_TMPAPPS_Diagtst_Proc_DHL_Full |
Load_Diagnostic_Test_Procedure_Bridge |
|
INT_TMPAPPS_Diagtst_Proc_DHL |
Load_Diagnostic_Test_Procedure_Bridge |
|
INT_TMPAPPS_Ethnicity_Patient_H_Full |
Load_Ethnicity_Patient_Bridge |
|
INT_TMPAPPS_Ethnicity_Patient_H |
Load_Ethnicity_Patient_Bridge |
|
INT_TMPAPPS_W_EHA_DIAGTST_SUBADM_DHL |
Load_Diagtst_Subadm_Bridge |
|
INT_TMPAPPS_W_EHA_DIAGTST_SUBADM_DHL_Full |
Load_Diagtst_Subadm_Bridge |
|
INT_TMPAPPS_Procedure_D |
Load_Procedure_Dimension |
|
INT_TMPAPPS_Procedure_D_Full |
Load_Procedure_Dimension |
|
INT_TMPAPPS_Diagtst_Patient_H |
Load_Diagnostic_Test_Patient_Bridge |
|
INT_TMPAPPS_Diagtst_Patient_H_Full |
Load_Diagnostic_Test_Patient_Bridge |
|
INT_TMPAPPS_DX_PATIENT_H_Full |
Load_Dx_Patient_Bridge |
|
INT_TMPAPPS_DX_PATIENT_H |
Load_Dx_Patient_Bridge |
|
INT_TMPAPPS_W_EHA_RESEARCH_PATIENT_D |
Load_Research_Patient_Dimension |
|
INT_TMPAPPS_GET_LATEST_PRTY_ADDR_Tmp_1 |
Load_Research_Patient_Dimension |
|
INT_TMPAPPS_W_EHA_RESEARCH_PATIENT_D_Full |
Load_Research_Patient_Dimension |
|
INT_TMPAPPS_GET_LATEST_PRTY_ADDR_Tmp_2 |
Load_Research_Patient_Dimension |
|
INT_TMPAPPS_Consent_D_Full |
Load_Consent_Dimension |
|
INT_TMPAPPS_Consent_D |
Load_Consent_Dimension |
|
INT_TMPAPPS_Diagnostic_Test_D |
Load_Diagnostic_Test_Dimension |
|
INT_TMPAPPS_Diagnostic_Test_D_Full |
Load_Diagnostic_Test_Dimension |
|
INT_TMPAPPS_Ethnicity_D |
Load_Ethnicity_Dimension |
|
INT_TMPAPPS_Ethnicity_D_Full |
Load_Ethnicity_Dimension |
|
INT_TMPAPPS_Diagtst_Spec_DHL |
Load_Diagnostic_Test_Specimen_Bridge |
|
INT_TMPAPPS_Diagtst_Spec_DHL_Full |
Load_Diagnostic_Test_Specimen_Bridge |
|
INT_TMPAPPS_Pt_History_Pt_H |
Load_Patient_History_Patient_Bridge |
|
INT_TMPAPPS_Pt_History_Pt_H_Full |
Load_Patient_History_Patient_Bridge |
|
INT_TMPAPPS_Proc_Patient_H |
Load_Procedure_Patient_Bridge |
|
INT_TMPAPPS_Proc_Patient_H_Full |
Load_Procedure_Patient_Bridge |
|
INT_TMPAPPS_Anatomical_Site_D_Temp |
Load_Anatomical_Site_Dimension |
|
INT_TMPAPPS_Anatomical_Site_D_Full |
Load_Anatomical_Site_Dimension |
|
INT_TMPAPPS_Anatomical_Site_D |
Load_Anatomical_Site_Dimension |
|
INT_TMPAPPS_Diagnosis_D |
Load_Diagnosis_Dimension |
|
INT_TMPAPPS_Diagnosis_D_Full |
Load_Diagnosis_Dimension |
|
INT_TMPAPPS_Diagnosis_D_Temp |
Load_Diagnosis_Dimension |
|
INT_TMPAPPS_Procedure_SubstanceAdministration_DHL |
Load_Procedure_SubstanceAdministration_Bridge |
|
INT_TMPAPPS_Procedure_SubstanceAdministration_DHL_Full |
Load_Procedure_SubstanceAdministration_Bridge |
|
INT_TMPAPPS_Consent_Status_D_Full |
Load_Consent_Status_Dimension |
|
INT_TMPAPPS_Consent_Status_D |
Load_Consent_Status_Dimension |
|
INT_TMPAPPS_Procedure_Type_Procedure_DHL_Full |
Load_Procedure_Type_Procedure_Bridge |
|
INT_TMPAPPS_Procedure_Type_Procedure_DHL |
Load_Procedure_Type_Procedure_Bridge |
|
INT_TMPAPPS_Medication_D_Full |
Load_Medication_Dimension |
|
INT_TMPAPPS_Medication_D |
Load_Medication_Dimension |
|
INT_TMPAPPS_Race_patient_H |
Load_Race_Patient_Bridge |
|
INT_TMPAPPS_Race_patient_H_Full |
Load_Race_Patient_Bridge |
|
INT_TMPAPPS_Procedure_Type_D_Full |
Load_Procedure_Type_Dimension |
|
INT_TMPAPPS_Procedure_Type_D |
Load_Procedure_Type_Dimension |
|
INT_TMPAPPS_Specimen_Patient_H |
Load_Specimen_Patient_Bridge |
|
INT_TMPAPPS_Specimen_Patient_H_Full |
Load_Specimen_Patient_Bridge |
|
INT_TMPAPPS_UOM_D |
Load_UOM_Dimension |
|
INT_TMPAPPS_UOM_D_Full |
Load_UOM_Dimension |
|
INT_TMPAPPS_UOM_Tmp |
Load_UOM_Dimension |
|
INT_TMPAPPS_User_D_Full |
Load_User_Dimension |
|
INT_TMPAPPS_User_D |
Load_User_Dimension |
|
 Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices |
|
