slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Title Slide Is Arial Bold, 26 Point and Justified to Bottom of Text Box PowerPoint Presentation
Download Presentation
Title Slide Is Arial Bold, 26 Point and Justified to Bottom of Text Box

Loading in 2 Seconds...

play fullscreen
1 / 32

Title Slide Is Arial Bold, 26 Point and Justified to Bottom of Text Box - PowerPoint PPT Presentation


  • 92 Views
  • Uploaded on

Title Slide Is Arial Bold, 26 Point and Justified to Bottom of Text Box. Data Warehouse solution Ministry of Public Health - Belgium The health care administration. The health care administration department of health care policy dept of accounts and hospital management

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 'Title Slide Is Arial Bold, 26 Point and Justified to Bottom of Text Box' - sai


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

Title Slide Is Arial Bold, 26 Point and Justified to Bottom of Text Box

Data Warehouse solution

Ministry of Public Health - Belgium

The health care administration

slide2
The health care administration
    • department of health care policy
    • dept of accounts and hospital management
    • dept of medical practice
  • Missions
    • Drafting policies
    • Financing hospitals
    • Carrying out studies, analyses,simulation,.....
    • Technical advice to minister
    • Secretariat for various councils and committees
    • ........................
  • Registrations systems

MKG, MPG, MFG, MVG, Haxhe, Finhosta, ....

example mkg

Hospital stay in specialized area

    • Specialized area codet
    • Length of stay
    • Length of stay in intensive care – in hours
  • Bed stay
    • Type of bed
    • Length of stay in each type of bed
    • Invoicing information
  • Care units
    • Care it code
    • Length of stay in care unit
  • Diagnosis
    • Main/secundary diagnosis
    • Diagnosis code ICD-9-CM
    • ICD-9-CM procedure code
    • ....
  • Emergency degree
  • Anaesthesia code
  • INAMI procedure
    • Chronological order number of same RIZIV procedure
    • ..
  • Birth of newborn
    • Weight
    • Apgar score after 1 minute
    • Apgar score after 5 minutes
    • Number of pregnancy weeks
    • ..............
Example : MKG
  • Administrative data
    • e.g. Date of creation of file,etc
  • Patient information
    • Patiet number
    • Year of birth
  • Hospital information
    • Hospital number
    • Type of hospital stay
    • Year of admission
    • Day of admission
    • Re-admission code
    • Re-admission number of days since last entrance
    • Month – day of discharge
    • Length of stay
    • Sex
    • Age
    • Postcode of area of residence
    • Nationaly indicator
    • Place of residence
    • Type of admission (e.g. Emergency, etc )
    • Sent by (e.g. General practitioner, etc )
    • Destination of discharge
    • Reason for discharge
    • Invoicing information
slide4

OVERVIEW

MVG

Haxhe

enquête RVT

andere....

LT

MKG

MPG

kadaster

MT

MFG

CIC

ziekenhuispersoneel

MFG(SHA)

KT

artsen

parmed

HAXHE

MPG

kadaster

budgetten ziekenhuizen

ligdagprijzen

inhaalbewegingen

budget FOD

CIC

Klassieke geg uit MKG

Healthaccount

CZB

jaarlijks

budget

MFG 96

MVG

MKG

B1-B2

A-B-C

DWH

MVG

rattrapages

RVT

FINHOSTA

MKG

PVT

slide5

Objectives Data Warehouse Project

University

Hospitals

Cabinets, commissions

- Multiple & easy access to data

- Intranet/Internet technology

Trend & cross-

analyses

Uniform Processing procedures

Ministry

Uniform Q procedures

MKG

MVG

MPG

MFG

External sources

Hospitals

slide6

Impact of Data Warehouse Solution

  • Organisation
    • Partnership with CSC
    • One team
      • CSC resources: project leader, analysts, SAS specialists, Oracle develop/DBA
      • Resources of Ministry: objective to prepare internal resources to take over project
  • Technology
    • SAS
    • Oracle RDBMS
  • Users
    • Analysts: doctors, economists
    • Controllers / administrative work
slide7

Architecture Data Warehouse Project

Internet/Intranet

SAS

- Feedback

- Brochures

- Analyses

- Simulations/calc.

Excel

Business

Intelligence

SAS/Oracle DataMarts

Data

Store

All domains linked with eachother:

Star-model: Dimensions, measures

Meta Data

Administration

MERCURE

Oracle 8

Extraction

& Population

Business

Objects

MKG

MFG

MVG

MPG

ZKH

Account.

HR

Follow up system

Oracle 8

Min. / Hosp

RIZIV

NIC / Nat Reg / Kruispuntbank ...

Internet ...

slide8

Functions of Data Staging Area

- Consultation basic data

(vb. General info Hospitals, RIZIV codes, ...)

- Maintenance of codes

- Follow up system

- Execution of Q-controles

- First feedback to hospitals

Boekhouding

Geneeskundepraktijk

Gezondheidszorgbeleid

MKG

MFG

MVG.

ZKH

Boekh.

Personeel

Opvolgingssysteem

Oracle 8

Min. / Hosp

RIZIV

NIC / Rijksregister / Kruispuntbank ...

Internet ...

slide9

Functions of Presentation Server

Boekhouding

Geneeskundepraktijk

Gezondheidszorgbeleid

Internet/Intranet

- Easy access to data & execution of stat analyses

on different MxG data

- Production of brochures

- Trends analyses

- Calculations / Simulations

- ....

Business

Objects

Excel

SAS

Oracle/

SAS

Datamarts

Ster-model: Dimensions, measures:

historical identification & consistent

Oracle 8

process flow
Process flow

CSC Proprietary 6/4/2014 11:00:31 AM 008_P2_CSC_white 10

slide11

2. Inlezen

3. Opladen staging area

1. Receptie

Controles

9. Correctie

4. Controles M.x.G.

10. Naar afzender

5. Aanvullende controles M.x.G.

11. Recuperatie

6. Controle M.x.G. - andere bronnen

7. Kruiscontroles M.x.G.

8. Globalisatie

12. Opladen “Presentation server”

Uniform Processing Procedures

Controller M.x.G / ext. data.

Oper. Informatica

Externe

gegevens

M.x.G.

slide12

SAS architecture

SAS architecture

slide30

Next steps

  • Integration in Intranet technology
  • Integration in HealthCare portal
    • Dynamic access to data for external parties (hospitals, …)
    • Transmitting and Q-controls of MxG data