| Case
Studies
SharePoint Patient Information Reporting System, Interface and Dashboard design
The Client:
A leading Medical (Kidney Stone Treatment) Company, Ohio.
The Situation:
The client has multiple sites and each site feeds data into separate databases. Three main databases include Patient information, treatments data, and monthly statistics. The challenge was to aggregate different databases into one, and to create customize patient management interface and dashboards.
The Solution:
A new SharePoint based reporting system was designed for the physicians and provided facilities to vendors and clients to fetch the reports via custom interfaces.
Some of the main features of its functionality are as follows:
- Personalized/Global views to display patient information: separate views were created using lists to display restricted information depending on user logins. Each user login had unique permissions and rights.
- Lookup functionality: Using lookup field on the list, automatic location identification was provided based on location of the user.
- Reports: Either gnat view or standard view reports were made available to display information about patients/treatments and statistics. Summarized reports displaying total cost per location were generated by providing customization.
- Dashboards: KPI (Key Performance Indicator) dashboards are generated to display patient’s data with the help of 3 indicators. These dashboards are generated based on the average of past moving 30 day’s data of the patients compared to current month. This means, the total number of patient’s data entered between 14th Jan 09 to 14th Dec 09 (for ex: 100 patients) will be treated as first month and then from 14th Dec 09 to 14th Nov 09(for ex: 200 patients) will be treated as second month for comparison. Based on these two months, average will be calculated (for ex: 150 patients).
- Alert notification: Alert notifications are required to be sent to the Location manager if no data is entered in the patient list, treatment list and statistics list till 5th of every month. This indicates the Location manager that data needs to be entered for the lists for which he has received notifications.
Technology Platform:
- MOSS (Microsoft Office SharePoint Server) 2007
- Microsoft Visual Studio 2008
- Microsoft .Net Framework 3.5
- Programming Language: C#.Net
- Microsoft SQL Server 2005
- Microsoft Visual Source Safe
Back To Case Studies
|
Clients
