Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Finding Information and Patches on My Oracle Support
• Finding Documentation on Oracle Technology Network
• Related Documents
• Conventions

Part I Using Oracle Health Sciences Cohort Explorer

1 Getting Started with Oracle Health Sciences Cohort Explorer

• Overview
  • What You Can Do Using Oracle Health Sciences Cohort Explorer
• Architecture
• Role of Oracle Health Sciences Clinical Development Center
• Reporting in Oracle Health Sciences Cohort Explorer
• Regulatory Compliance
  • Tracking Data
  • Managing ETL Versions
  • Security

2 Using Oracle Health Sciences Cohort Explorer

• Overview
• Accessing Oracle Health Sciences Cohort Explorer
  • Logging In
  • Viewing a Dashboard
• Using Oracle Business Intelligence
  • Oracle Business Intelligence Presentation Services Components
    • Oracle Business Intelligence Answers
    • Oracle Business Intelligence Interactive Dashboards
    • Oracle Business Intelligence Delivers
• Performing Common Tasks in Oracle Business Intelligence
  • Exiting Oracle Business Intelligence
  • Viewing Descriptions of Oracle Business Intelligence Dashboards and Saved Analyses
  • Using Online Help
  • Printing an Oracle Business Intelligence Dashboard or Saved Analysis
  • Emailing an Oracle Business Intelligence Dashboard Page or Analysis
  • Exporting Oracle Business Intelligence Results
  • Refreshing an Oracle BI Interactive Dashboard or Oracle Business Intelligence Request
  • Refreshing Information in the Oracle Business Intelligence Selection Pane
• Navigating in Oracle Business Intelligence
  • What is Available to You After Accessing Oracle Business Intelligence?
  • Using Oracle Business Intelligence Global Header
  • Working with Oracle Business Intelligence Pages
  • Drilling Down in Oracle Business Intelligence
  • Sorting Columns in Tables in Oracle Business Intelligence
• Using the Oracle Business Intelligence My Account Page
  • Setting Your Oracle Business Intelligence Preferences
  • Setting Your Oracle Business Intelligence Time Zone

3 Working with Analyses

• Predefined Analyses
  • Viewing a Predefined Analysis

Part II Appendixes

A Dashboards, Reports, and Prompt Sets

• Oracle Health Sciences Cohort Explorer Dashboards
  • Logging in to Cohort Explorer
  • Dashboard Pages
    • Summary Dashboard Page
    • Query Patients Page
    • List Patients in Cohort Page
    • Timelines of Patients in Cohort Page
    • List Patients Page
    • Patient Timelines Page
    • Individual Patient Details Page
• Oracle Health Sciences Cohort Explorer Reports
  • Patients Diagnosed and Treated (Report TRC-CER-001)
    • Audience
    • Report Type
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Report
    • Column Descriptions
  • Number of Treatments Performed (Report TRC-CER-003)
    • Audience
    • Report Type
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Report
    • Column Descriptions
  • Ethnicity or Race of Newly Diagnosed Patients (Report TRC-CER-004)
    • Audience
    • Report Type
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Report
    • Column Descriptions
  • Age or Gender of Newly Diagnosed Patients (Report TRC-CER-005)
    • Audience
    • Report Type
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Report
    • Column Descriptions
  • Biospecimen Samples Status (Report TRC-CER-006)
    • Audience
    • Report Type
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Report
    • Column Descriptions
  • Starting with Patient Count: (Report TRC-CER-101)
    • Audience
    • Report Type
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Report
    • Column Descriptions
  • Patient Information (Report TRC-CER-102)
    • Audience
    • Report Type
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Report
    • Column Descriptions
  • Protocol (Report TRC-CER-103)
    • Audience
    • Report Type
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Report
    • Column Descriptions
  • Patient History (Report TRC-CER-104)
    • Audience
    • Report Type
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Report
    • Column Descriptions
  • Diagnosis (Report TRC-CER-105)
    • Audience
    • Report Type
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Report
    • Column Descriptions
  • Procedure or Treatment (Report TRC-CER-106)
    • Audience
    • Report Type
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Report
    • Column Descriptions
  • Medication (Report TRC-CER-107)
    • Audience
    • Report Type
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Report
    • Column Descriptions
  • Diagnostic Test (Report TRC-CER-108)
    • Audience
    • Report Type
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Report
    • Column Descriptions
  • Filter Patients with Specific Combinations of Medication-Procedure, Diagnostic Tests-Procedure, Diagnostic Tests-Medication, Diagnostic Tests-Specimen (Report TRC-CER-109)
    • Audience
    • Report Type
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Report
    • Column Descriptions
  • Exclusion Criteria (Report TRC-CER-110)
    • Audience
    • Report Type
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Report
    • Column Descriptions
  • Total Patient Count (Report TRC-CER-112)
    • Audience
    • Report Type
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Report
    • Column Descriptions
  • Summary of Filtering Criteria Applied (Report TRC-CER-113)
    • Audience
    • Report Type
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Report
    • Column Descriptions
  • Timelines of Patients in Cohort (Report TRC-CER-114)
    • Audience
    • Report Type
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Report
    • Column Descriptions
  • Patient Timelines (Report TRC-CER-114-2)
    • Audience
    • Report Type
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Report
    • Column Descriptions
  • List Patients in Cohort (Report TRC-CER-115)
    • Audience
    • Report Type
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Report
    • Column Descriptions
  • List Patients (Report TRC-CER-115-2)
    • Audience
    • Report Type
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Report
    • Column Descriptions
  • Patient Profile (Report TRC-CER-116)
    • Audience
    • Report Type
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Report
    • Column Descriptions
  • Consent Forms Signed (Report TRC-CER-117)
    • Audience
    • Report Type
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Report
    • Column Descriptions
  • Qualifies for Protocols (Report TRC-CER-118)
    • Audience
    • Report Type
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Report
    • Column Descriptions
  • Patient History (Report TRC-CER-119)
    • Audience
    • Report Type
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Report
    • Column Descriptions
  • Patient Diagnosis (Report TRC-CER-120)
    • Audience
    • Report Type
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Report
    • Column Descriptions
  • Procedures or Treatments Undergone (Report TRC-CER-121)
    • Audience
    • Report Type
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Report
    • Column Descriptions
  • Medications Taken (Report TRC-CER-122)
    • Audience
    • Report Type
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Report
    • Column Descriptions
  • Diagnostic Tests (Report TRC-CER-123)
    • Audience
    • Report Type
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Report
    • Column Descriptions
  • Specimen Samples Collected (Report TRC-CER-124)
    • Audience
    • Report Type
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Report
    • Column Descriptions
  • Specimen or Specimen Count (Report TRC-CER-125)
    • Audience
    • Report Type
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Report
    • Column Descriptions
• Oracle Health Sciences Cohort Explorer Prompt Sets
  • Statistics from-to (Prompt Set TRC-CEP-001)
    • Audience
    • Prompt Set Type(s)
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Prompt
    • Prompt Descriptions
  • Add or Remove Patient IDs (Prompt Set TRC-CEP-002)
    • Audience
    • Prompt Set Type(s)
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Prompt
    • Prompt Descriptions
  • Display Detailed Information for a Given Patient (Prompt Set TRC-CEP-003)
    • Audience
    • Prompt Set Type(s)
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Prompt
    • Prompt Descriptions
  • Patient Information Prompts (Prompt Set TRC-CEP-S01)
    • Audience
    • Prompt Set Type(s)
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Prompt
    • Prompt Descriptions
  • Protocol Prompts (Prompt Set TRC-CEP-S02)
    • Audience
    • Prompt Set Type(s)
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Prompt
    • Prompt Descriptions
  • Patient History Prompts (Prompt Set TRC-CEP-S03)
    • Audience
    • Prompt Set Type(s)
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Prompt
    • Prompt Descriptions
  • Diagnosis Prompts (Prompt Set TRC-CEP-S04)
    • Audience
    • Prompt Set Type(s)
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Prompt
    • Prompt Descriptions
  • Procedure Prompts (Prompt Set TRC-CEP-S05)
    • Audience
    • Prompt Set Type(s)
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Prompt
    • Prompt Descriptions
  • Medication Prompts (Prompt Set TRC-CEP-S06)
    • Audience
    • Prompt Set Type(s)
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Prompt
    • Prompt Descriptions
  • Diagnostic Test Prompts (Prompt Set TRC-CEP-S07)
    • Audience
    • Prompt Set Type(s)
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Prompt
    • Prompt Descriptions
  • Filter Patients with Specific Combinations of Medication-Procedure, Diagnostic Tests-Procedure, Diagnostic Tests-Medication, Diagnostic Tests-Specimen Prompts (Prompt Set TRC-CEP-S08)
    • Audience
    • Prompt Set Type(s)
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Prompt
    • Prompt Descriptions
  • Exclusion Criteria Prompts (Prompt Set TRC-CEP-S09)
    • Audience
    • Prompt Set Type(s)
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Prompt
    • Prompt Descriptions
  • Specimen Prompts (Prompt Set TRC-CEP-S10)
    • Audience
    • Prompt Set Type(s)
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Prompt
    • Prompt Descriptions
  • Add or Remove Patient IDs and Time Range (Prompt Set TRC-CEP-S11)
    • Audience
    • Prompt Set Type(s)
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Prompt
    • Prompt Descriptions
  • Select Patient IDs (Prompt Set TRC-CEP-S12)
    • Audience
    • Prompt Set Type(s)
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Prompt
    • Prompt Descriptions
  • Select Patient IDs and Time Range (Prompt Set TRC-CEP-S13)
    • Audience
    • Prompt Set Type(s)
    • Location
    • Dimensions
    • Supplementary Prompts
    • Reports Referenced
    • Reports Referencing This Prompt
    • Prompt Descriptions

B Oracle Health Sciences Cohort Explorer Presentation Catalog

• Dimensions in the Oracle Health Sciences Cohort Explorer Presentation Catalog
• Facts in the Oracle Health Sciences Cohort Explorer Presentation Catalog
• Measures in the Oracle Health Sciences Cohort Explorer Presentation Catalog

Glossary

Index