Major Hospital (Western USA) - Data Mart for Nursing Administration Department
Executive Summary:Since its inception early in the 20th century, this hospital has evolved to become one that is internationally renowned for the best patient care modern medicine has to offer. It is committed to providing superior outpatient, acute, sub-acute and home patient care, breakthrough biomedical research, graduate and undergraduate medical education, and community service.The hospital cares for about 150,000 patients per year, and over 1,000 primary care physicians and specialists attend to these patients, supported by a support staff of many thousands more. Many patients are eligible to receive the newest treatments by participating in this Hospital’s active clinical research program. More than 300 principal investigators and 500 employees are involved in this research, resulting in over 300 papers appearing in peer-reviewed medical journals each year. All of these world-class services are provided at a multi-building campus, where over 10,000 users access over 500 different information technology applications running on many different platforms. This has created a complex web of inter-related systems that users have to navigate as part of doing their jobs. The hospital has an extensive Enterprise Information Systems (EIS) group that supports and develops the IT applications. The hospital has been a client of Aviana since 2000. Detailed below is one of the more significant projects that Aviana has implemented at the hospital: 
Business IssuesThe Aviana team's expertise with Cognos and Concur (T&E Solution) products was a major plus. The ability to coordinate with Cognos (as a Platinum Certified Partner) was another critical factor in the company's decision process. Aviana's reputation of doing implementations on time and on budget was also factored in. Aviana was asked to implement the following products for the project:
Aviana's SolutionAviana worked with the hospital's Nursing Administration management to understand their business needs and to design and build a data mart solution to track and examine the quality of nursing care. This project gave the hospital a way of loading utilization data into the data mart, and customized tools were developed to allow users to transform and analyze data, and to produce custom reports.
This data mart's functionality was subsequently expanded to cover participating hospitals in the state-wide coalition of hospitals, and these findings are used as a part of the hospital's periodic JCAHO Audit.
The project was developed in a multi-phased solution that:
Technical environment: Front-end: MS Front Office Automation and Visual Interdev (ASP, .net, C#, Excel, Outlook and Access), COGNOS; Back-end: SQL Server, SSIS.
 |
A Slice of Healthcare Advice11/11/2008
Health 2.0 - Major Vendors Bring Electronic Records to Patient's Desktop
Healthcare Related NewsStandards and Certification Criteria to Support Meaningful Use of Electronic Health RecordsDecember 30, 2009 A Message from Dr. David Blumenthal, National Coordinator for Health Information Technology As we look toward 2010, we can envision a transformation of our health system to improve health care quality, efficiency,... Latest Healthcare Headlines
|