1 / 32

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

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

sai
Download Presentation

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

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 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

  2. 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, ....

  3. 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

  4. 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

  5. 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

  6. 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

  7. 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 ...

  8. 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 ...

  9. 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

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

  11. 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.

  12. SAS architecture SAS architecture

  13. Easy access to data - Fingerprint Nursing data

  14. Easy access to data - Fingerprint Nursing data

  15. Easy access to data - Fingerprint Nursing data

  16. Easy access to data - Fingerprint Nursing data

  17. Easy access to data - Fingerprint Nursing data

  18. Easy access to data - Fingerprint Nursing data

  19. Easy access to data - Feedback to hospitals

  20. Easy access to data - How to find my way in the DWH?

  21. 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

  22. Questions

  23. CSC Proprietary 6/4/2014 11:00:31 AM 008_P2_CSC_white 32

More Related