Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Part I Logical and Physical Data Model

1 Introducing Oracle Healthcare Data Model

• What is the Oracle Healthcare Data Model?
• What Are the Benefits of Using the Oracle Healthcare Data Model?
• What Are the Components of the Oracle Healthcare Data Model?
• Oracle Products That Make Up the Oracle Healthcare Data Model

2 Logical Data Model Foundation

• Logical Data Model Entity Dictionary

3 Logical Data Model Dimensions

• Logical Data Model Dimensions
  • Age Band
  • Facility
  • KPI
  • Organization
  • Patient
  • Service Provider Practice
  • Shift
  • Time
  • Time of Day

4 Oracle Healthcare Data Model Physical Data Model

• Introduction to Oracle Healthcare Data Model Physical Data Model
• Oracle Healthcare Data Model Tables (HDM)
• Reference Tables
• Derived Tables
• DWX Cross Reference Tables
• Compressed Tables
• Partition Definitions
• Index Definitions
• Parallel Definitions
• OLAP ETL Views
• OLAP SQL Views

5 Oracle Healthcare Data Model Logical to Physical Mapping

• Logical to Physical Mappings for Oracle Healthcare Data Model

6 Oracle Healthcare Data Model Partitions and Indexes

• Partitioned Tables for Oracle Healthcare Data Model Table
• Indexes for Oracle Healthcare Data Model

Part II KPIs, Intra-ETL, OLAP, Data Mining, Utility Scripts, and Sample Reports

7 Oracle Healthcare Data Model Intra-ETL

• Introduction to Oracle Healthcare Data Model Intra-ETL

8 Oracle Healthcare Data Model KPIs

• Oracle Healthcare Data Model KPI Summary
• KPI 1 (#8) Heart Failure: Beta-Blocker Therapy for Left Ventricular Systolic Dysfunction (LVSD)
• KPI 2 (#199) Heart Failure: Patient Education
• KPI 3 (#44) Coronary Artery Bypass Graft (CABG): Preoperative Beta-Blocker in Patients with Isolated CABG Surgery
• KPI 4 (#28) Aspirin at Arrival for Acute Myocardial Infarction (AMI)
• KPI 6 (#10) Stroke and Stroke Rehabilitation: Computed Tomography (CT) or Magnetic Resonance Imaging (MRI) Reports
• KPI 10 (#126) Diabetes Mellitus: Diabetic Foot and Ankle Care, Peripheral Neuropathy - Neurological Evaluation
• KPI 12 (#49) Urinary Incontinence: Characterization of Urinary Incontinence in Women Aged 65 Years and Older
• KPI 13 (#175) Pediatric End Stage Renal Disease (ESRD): Influenza Immunization
• KPI 16 (#112) Preventive Care and Screening: Screening Mammography
• KPI 18 (#114) Preventive Care and Screening: Inquiry Regarding Tobacco Use
• KPI 19 (#189) Referral for Otologic Evaluation for Patients with a History of Active Drainage From the Ear Within the Previous 90 Days
• KPI 22 Lipid Lowering Therapies
• KPI 27 Door to CT Time
• KPI 28 Diabetic Teaching
• KPI 31 (AMI-8) Median Time to Primary PCI
• KPI 32 (AMI-7): Median Time to Fibrinolysis
• KPI 34 (SCIP-Inf-6) Surgery Patients with Appropriate Hair Removal
• KPI 35 (SCIP- Inf-9) Urinary catheter removed on Postoperative Day 1 (POD1) or Postoperative Day 2 (POD 2) with day of surgery being day zero
• KPI 36 (HBIPS-2) Hours of Physical Restraint Use
• KPI 37 (HBIPS-3) Hours of Seclusion Use

9 Oracle Healthcare Data Model OLAP Dimensions

• Introduction to OLAP Architecture
  • General Process to Populate the OLAP Module in Oracle Healthcare Data Model
• Oracle Healthcare Data Model OLAP Dimensions
• Age Band Dimension: AGEBND
  • Age Band Attribute Mapping
• Case Dimension: CASE
  • Case Attribute Mapping
• Facility Dimension: FAC
  • Facility Attribute Mapping
• KPI Dimension: KPI
  • KPI Attribute Mapping
• Observation Dimension: OBSV
  • Observation Attribute Mapping
• Organization Dimension: ORG
  • Organization Attribute Mapping
• Patient Dimension: PT
  • Patient Attribute Mapping
• Service Provider Practice Dimension: SPP
  • Service Provider Practice Attribute Mapping
• Shift Dimension: SHFT
  • Shift Attribute Mapping
• Time Dimension: TIME
  • Time Attribute Mapping
• Time of Day Dimension: TOD
  • Time of Day Attribute Mapping

10 Oracle Healthcare Data Model OLAP Cubes and OLAP Facts

• Oracle Healthcare Data Model OLAP Cubes
  • Case Cube
  • Encounter Cube
  • Observation Cube
  • Patient Cube
• Oracle Healthcare Data Model OLAP Facts
  • Case KPI Fact
  • Encounter KPI Fact
  • Observation KPI Fact

11 Oracle Healthcare Data Model Data Mining Models

• About Data Mining in Oracle Healthcare Data Model
  • Understanding the Mining Model Schema and Architecture
  • Using the Mining Model Refresh Procedure
• Model 1: Weight of Evidence Over Adverse Event (Patient Fall)
  • Patient Fall: Mining Source Table Attributes
  • Patient Fall Factors: the Ranking Output
  • Patient Fall: Prediction Algorithm

12 Oracle Healthcare Data Model Utilities

• Calendar Population
  • Calendar Population Scripts
  • How to Populate Calendar Data
• Metadata Editor
  • DWR_MD_ENTY Metadata Editor for Oracle Healthcare Data Model
  • DWR_MD_KPI Metadata Editor for Oracle Healthcare Data Model
  • DWR_MD_PRG Metadata Editor for Oracle Healthcare Data Model
  • DWR_MD_REF_ENTY_KPI Metadata Editor for Oracle Healthcare Data Model

13 Oracle Healthcare Data Model Sample Reports

• Cardiac Sample Reports
  • PQRI-Heart Failure: Heart Failure Patients Prescribed a Beta Blocker
  • PQRI Heart Failure: HF Patients Received Disease Management Education
  • AHA- Cardiac: Cardiac Patients That Receive Lipid-Lowering Therapies
  • PQRI- Cardiac AMI Patients That Received Aspirin Within 24 Hours
  • CMS/JCAHO Cardiac: Acute MI Patients Median PCI Time
  • CMS/JCAHO Cardiac: Acute MI Patients Median Fibrinolytic Agent Administration Time
• Diabetes Sample Reports
  • PQRI- Diabetes: Diabetes Patients That Have Had a Lower Extremity Neurologic Exam
  • AHA-Diabetes: Diabetic Patients That Receive Diabetic Education on Discharge
• General Medicine Reports
  • PQRI General: UI Patients had Incontinence Characterized
  • PQRI General: Women Had a Mammogram
  • PQRI General: Adults Queried about Tobacco Use
  • PQRI General: Patients Otologic Evaluation for Ear Active Drainage
• Pediatrics Report
  • PQRI Pediatrics: Pediatric End Stage Renal Disease (ESRD) Patients That Have Received the Influenza Vaccine
• Psychiatric Reports
  • CMS/JCAHO: Hospital Based Inpatient Psychiatric Services Hours of Physical Restraint Use
  • CMS/JCAHO: Hospital Based Inpatient Psychiatric Services Hours of Seclusion Use
• Risk Assessment Reports
  • Risk Assessment (Clinical): High Fall Risk Patients
  • Risk Assessment (Admin): Fall Outlier
  • Risk Assessment (Admin): Fall Patients Details at the Day
  • Risk Assessment (Admin): Falls in Age Group
  • Risk Assessment (Admin): Falls with Ambulatory Aid
  • Risk Assessment (Admin): Weight of Evidence
• Stroke Sample Reports
  • PQRI- Stroke: Stroke Patients with a CT or MRI of the Brain
  • AHA- Stroke: Stroke Patients That Receive CT Within 25 Minutes of Arrival
• Surgical Sample Reports
  • Surgical PQRI - CABG: Coronary Artery Bypass Graft Patients That Received a Beta Blocker Prior to Surgery
  • Surgical CMS/JCAHO-SCIP: Surgery Patients with Appropriate Hair Removal
  • Surgical CMS/JCAHO-SCIP: Patients with Urinary Catheter Removed on Postop Day 1/2

Part III Appendices

A Oracle Healthcare Data Model Control Tables

• Intra-ETL Install and Configuration Control Tables
  • Configure the Oracle Healthcare Data Model Domain Code System Control Table
  • Background Information about Shifts (DWR_SHFT)
  • Configure Facility Shift Cross Reference Table
• Intra-ETL Load Parameters Control Table
• Intra-ETL OLAP Mapping Control Table
• Intra-ETL Monitoring Process Control Tables

Index