Customer Profile :-
Customer is the leading home care technology company that delivers web-based and mobile applications for agency management, clinical, financial and knowledge-based services. Their portal ehomecare.com has the following features:
- Enables rapid clinical, operational and financial transactions between the Home Care Agency and its referral partners and billing sources, maximizing efficiencies for all involved.
- Provides each user with an easily customizable, unique view of ehomecare.com’s features and services suited to their individual needs.
- Provides informational resources on home care issue
Business Situation :-
The Center for Medicare and Medicaid Services (CMS) will be measuring home health agencies based on the quality of care provided to patients by measuring the results of patient outcomes. Reports are available to the agencies on a quarterly basis from CMS and on a monthly basis if they are using any third-party outcome reporting. The reports cannot provide the detail information needed to do the necessary analysis to determine causes for improvement and decline in specific areas. The new outcome reports will provide the information in various formats to help the agency identify areas of concern on many levels: patient, clinician, diagnosis. This information can then be used to determine best practices to help improve the outcome results.
Agencies will be measured for P4P based on a number of factors, including: rate of acute care hospitalization, need of emergent care, improvement in wound care, infection rates, immunization. One of the first measures that will be analyzed will be the rate of hospitalization. To help agencies with this effort, two reports will be provided: One to show all the patients at risk for hospitalization and one to show all the patients and reasons for emergent care. The reports will show patients with the associated category and each category with the associated patients.
Solution :-
Analyze existing database and create de-normalized tables to improve performance of reports. Derived a row per clinical visit structure for the tables and transferred records using a nightly processing stored procedure.
Created highly optimized stored procedures to retrieve data for the reports.
Benefits :-
-
Creation of reports is more efficient since the processing logic for stored procedures used to retrieve data for the reports is simplified
-
Very little processing is required by the report stored procedures.
-
As data is split between tables data volume is restricted.
Technology Used :-
SQL Server 2005 Database, SQL Server 2005 Reporting Services
|
