Customers Profile
APS Healthcare Inc, (http://www.apscare.com)

Our Solution
After interacting with APS and understanding the requirements it was decided to form two core teams one onsite and the other offshore, which will work together in developing the system.

The aim of this project was to find a solution for all the required modifications and enhancements to be made to the existing CCMS internal and external reports.

The required reports were developed using Crystal Reports. Most of the backend functionality was created using Oracle functions. Visual Basic forms were used as calling interfaces for the reports.

Methodology
The Incremental model was used to develop the reporting section of the project. This model was opted for as we expected frequent interactions with the client by the on-site team and more requirements as the project progresses.

APS wanted the user interface to fit into their existing CCMS support application in terms of the GUI and functionality. These constraints were kept in mind during the design.

Benefits
The project refines and implements technical enhancements that will allow APS to provide smooth implementations, accurate and comprehensive reporting, and smooth integration with and for their customers.

It also helps APS in assessing their performance as an organization and the performance of their employees by providing the periodic reports from time-to-time.

Introduction
CCMS is a comprehensive and flexible tracking software for utilization and case management activities. Presently the application supports medical services, behavioral health services, and maternity services. It receives inputs of membership, provider, facility and employer group information through a built in "Refresh" mechanism. This mechanism is the function that brings data from the Central Data Repository into CCMS.

Situation
In an effort to adequately support the implementation of several new clients at APS Healthcare, the Medical Services Division, in conjunction with Behavioral Health Services and Software Development had defined a project to prepare CCMS and the CDR for implementing this new business. This phase of the project involved development of new reports and redefinition of existing reports to support requirements for new APS clients.

The project consisted the following phases:

1. Design and write specifications for all the reports;
2. Modify/Create the database routines to implement (1);
3. Create the printable reports for printing to implement (1);
4. Test the interface, modify as necessary to meet clients adjusted requirements;
5. Install and implement the interface.
6. Create documentation for all portions of the system.

This phase of the project handles the entire reporting module. APS achieved the following through this project:

1. Rewrite UM Activity report, Event Summary Report, and Circle report to meet customer needs.
2. Transition CM reports (external customer reports - TSO) from Info-maker to Crystal.
3. Transition all reports so member coverage pulls from event table rather than member level.
4. Enhance all report modules to support aggregate group reporting.

Extract reports that keep track of the turn-around-time of APS's internal processes.

Features

• Generating complex reports very efficiently and accurately with ease 
• Customizable reports for reporting the various clinical details.
• Provide front-end interfaces that can be used to restrict the information set for the given report.
• Easy maintainability as most of the functionality is developed at the backend in the form of SQL server stored procedures.
• Reports with a good design in terms of look and feel.

Tools and Technologies

• Microsoft Windows NT4.0/ 2000 Server
• Seagate Crystal Reports 8.0
• Microsoft Visual Basic 6.0
• Oracle 8.0.5

Our Process

The system is developed using Crystal Reports. The Oracle functions and tables are used for the backend calculations of the data. The front-end interfaces used for calling the reports are designed using Visual Basic 6.0. The system has the following reports designed for reporting various clinical details.

• Ten Day Report
• UM Activity Report
• Event Summary Report
• Case Summary Report
• Case Manager Internal QA Report
• Utilization Management Report
• UM Production Report
• TSO Report

Conclusion

We have made significant contributions in terms of the design for this system and tried to keep in mind the client's long-term requirements. Our work in completing the project on-time was appreciated.