PGH Phase 1 Project

The PGH Upgrading Phase 1 Computerization project is an upgrade to the existing Hospital Management Information System of PGH. The upgrade consists mainly of optimizing the system’s codes, particularly the database itself, its configuration, codes, and other related issues. Previously, PGH is using their HMIS to perform majority of their work, such as patient tracking, patient admission, billing and collection, and inventory monitoring. The said system was developed using Oracle 9i as its database, and for the mean time, the system gives them the desired output. The HMIS was initially developed by LST. However, the group plans on reducing software licensing and maintenance costs, particularly with database software to virtually zero. The previous PGH HMIS contains only 1 database instance and 1 web application server. With this kind of design, the database will be receiving workloads that will eventually lead to system slow downs and probable cause of bugs.

The Phase 1 focus on 4 key issues: Database Migration, a separate Master Patient Index, a separate system consisting of Service Request Processing and Billing & Collection System, a separate Pharmacy Inventory System, and the Reference Table Maintenance. The previous database was divided into 4 main databases namely the Master Patient Index, Service Request Processing and Billing & Collection System, Pharmacy Inventory System, and the Reference Table Maintenance. These databases interconnected via a Web Service Application. The system set up for the PGH Upgrading Phase 1 Computerization have 5 different servers, two were used as database servers, the other two for application servers and one for backup/archiving server.