Option Matrix has been working over last 2 years for an IT solutions firm in Denmark that provides portal solutions to sports clubs
The objective of the project was to develop a desktop application to manage the data related to the patient and handle multiple departments in different modules for effective hospital management. Patients can fix their appointments with the doctors, come to the clinic, undergo diagnosis, and receive medical advice / follow-up. This project is a windows-based application/software called EMR to store patient healthcare data. The application consists of a ‘front-end’ and a ‘back-end’. The front-end file acts as the user interface for HDM. It contains forms, queries, reports, code modules and local tables. The front-end file contains table links to the back-end file. The back-end file is located on a server that acts as an HDM database.
Admin user can installs the application in different departments with a pre-defined authentication. At the time of installation, the admin user can setup the login details for different department users. Admin user can also manage the department user, user profiles, providers, patients of different departments, insurance companies, tasks like type / category relationship and mailbox / staff assignments. Assign access rights to different users.
Department users are the users of different departments in the hospital have access rights to perform different tasks based on their authentication. Prospective Department users can also add a new patient record and manage the existing patient records, Fix an appointment for the patient with a consultant (doctor) and search for an appointment of a particular doctor, admin user can manage the schedule of the providers and resources. The reminders for the tasks for a particular patient with complete details can be sent
The application was programmed in windows architecture using .Net 2.0 (with VB.Net as language) and MS SQL Server 2000 or equivalent as RDBMS. There is a separate MS SQL Server 2000 database at each of the three offices and these 3 databases synchronize with each other as per the set schedule. The windows interface application can be loaded on each PC in the LAN and there is a higher capacity Windows XP / 2003 server in each of the 3 offices where the MS SQL Server 2000 RDBMS has reside. Optimistic locking with ADO.Net disconnected database has been used. Another interface was created and linked with the patient forms web application.