Skip Headers
Oracle® Healthcare Data Model Reference
11
g
Release 2 (11.2)
Part Number E18026-02
Home
Book List
Index
Contact Us
Next
View PDF
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
Scripting on this page enhances content navigation, but does not change the content in any way.