slide1
Download
Skip this Video
Download Presentation
OSUMC:Decision Support Services

Loading in 2 Seconds...

play fullscreen
1 / 9

OSUMC:Decision Support Services - PowerPoint PPT Presentation


  • 227 Views
  • Uploaded on

OSUMC:Decision Support Services. The Information Warehouse: Analysis at Your Fingertips. Information Warehouse(IW) Conceptual View. Information Warehouse. Data Acquisition. Data Transfer. Data Access . Scrubbing Reconciliation Integration Validation Transformation.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'OSUMC:Decision Support Services' - Mia_John


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1
OSUMC:Decision Support Services

The Information Warehouse:

Analysis at Your Fingertips

information warehouse iw conceptual view
Information Warehouse(IW)Conceptual View

Information

Warehouse

Data

Acquisition

Data

Transfer

Data Access

Scrubbing

Reconciliation

Integration

Validation

Transformation

External Data

Source

Multidimensional analysis

Data

Mart

Data Mining

External Data

Source

Adhoc query & reports

Data

Mart

Internal Data

Source

Consolidated

Data Repository

Data

Mart

Web reporting & dashboard

Internal Data

Source

Internal Data

Source

De-identify

Outside benchmarking

National/State/Regional database

Error Report

information warehouse iw osumc environment
Information Warehouse (IW): OSUMC Environment

Data Acquisition

Data Transfer

Information Warehouse

Data Access

Encounter

DM

ICU

DM

Readmt

DM

Consolidated

Data

Repository

Patient

Management

HCC Cost

Accounting

D

A

T

A

V

A

L

I

D

A

T

I

O

N

Pharmacy

DM

ED Visits

DM

Mom/Baby

DM

Patient

Accounting

COE/DI

DM

Multidimensional analysis/Data Miming

Lab

DM

Blood Bank

DM

CPOE

Pt Sat.

DM

Adhoc query

Sunquest

Lab System

Rejection

DM

Web reporting & dashboard

Patient

Satisfaction

CCG

DM

De-identify

Ohio Hospital

Association

Revenue

DM

OHA

DM

Outside data for benchmarking

Genetic

Consolidated

Data Entry

Census

DM

information warehouse iw historical genetic data
Information Warehouse (IW): Historical Genetic Data

Data Acquisition

Data Transfer

Information Warehouse

Data Access

D

A

T

A

V

A

L

I

D

A

T

I

O

N

Main

Genetics

Existing

Data

Marts

Multidimensional analysis/Data Miming

Amish

Barrett’s

Adhoc query

CCG

Data

Mart

HNPCC

Web reporting & dashboard

Cowden

Samples

Direct Data Entry

slide5
OSUMC: IW/DM Benefits
  • Easy Access
  • Data Integrity
  • Trending/Forecasting
  • Centralized reporting
  • Ad hoc Query
  • Consistent definitions/data
  • Outcomes measurement/better patient care
  • Data for research
  • Data for community outreach
  • Data mining
  • Analysis for cost savings
  • Data security
  • One source of data for vendors- UHC,OHA,HCIA
slide6
OSUMC: IW/DM Sample Data

Information on individuals on a research protocol

Family risk assessment of individuals on protocol

tools to access data
Discoverer

Allows user to create reports by running ad hoc queries and performing counts and calculations on specific values (or range of values) of the data elements in the IW.

Holos

Allows data in the IW to be pre-calculated, aggregated and stored in an application, that can be presented in multiple ways for analysis, trending and forecasting without the user having to write and run queries. Many Holos applications have been developed at the OSUMC.

Tools to access data

Web

Census, Revenue, COE

  • For outside vendors like UHC, HCIA etc, programs have been developed by the IW staff to extract the data for the desired time period and export on a quarterly basis.
information warehouse current data sources
Information Warehouse: Current data sources
  • HCC Managed Care System
    • Provides medical and financial encounter related data
  • Siemens Patient management

Provides daily census data by hospital service, nurse station and admitting physician

  • Siemens Patient accounting
  • Provides daily revenue data
  • SunquestLab information system
  • Provides daily patient lab results
  • Siemens/Invision
  • Provides ‘computerized order entry’ and ‘discharge instructions’
  • data
  • Centralized Physician database
  • Provides physician data
primary internal external customers
Leadership Council for Clinical Value EnhancementPrimary Internal & External Customers

Internal:

  • Clinical services
  • Quality and Operations Improvement
  • Medical Information Management
  • Strategic and Business Planning
  • Fiscal Services
  • Transplant Services

External:

  • University Healthcare Consortium (UHC)
  • Ohio Hospital Association (OHA)
ad