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 |