Health Center Management System Capstone Project Document

Introduction

In the current time people can’t imagine their life without technology. The technology sector has changed and developed many products. A computer is an example of technology that helps people in many ways. People use computers to finish office works, for business and also for entertainment. Computers helps us makes manual process easier and efficient.

Most of us already engage ourselves in the developing state of our environment. As we go on to our study, we ask several people on how modern technology affects their daily activities, one of those are the health centers which is having a lot of daily activities. Our system focuses on how the health center personnel can convey an effective service to its people in a manageable span of time. It also emphasizes with the registration of ongoing patients, together with their SMS notification wherein they will be easily notified about their appointments, changes of schedule and follow- up reminders. In addition to that are the health center personnel can easily manage their time and can give effective and efficient satisfaction to their patients with the help of our system.

 

Background of the Study

Barangay health center is a community based and patient directed organization. It is usually the first point of contact between residents of the community and other health care facility levels. Barangay Estefania health center provides consultation, immunization and prenatal. They are using manual procedure to get information from their patients. Barangay health center service is regulated by the DOH. Every health center is equipped to provide primary level of health care.

We developed this system in order to make the health center acquire modern technology, to consume the time works and easily deliver monthly reports and records. The provision of high-quality health care services is an increasingly difficult challenge and outcomes of health care services. It is a key to inform government officials by having a modern technology and other decision making more accurate about health-related issues. Health services researchers examine the access to care, and easily to processes the outcomes of health services for individuals and populations.

 

Statement of the Objective

The Automated process of  Health Center will be a big help to them, that was the main objectives of our system to get out from manual process, and to implement a new way of method to the center.

The study aims to develop a system that allows to:

• Organize the record list and easily to find the previous Records.
• Lessen the time to find their Records in log book and their paper works.
• Easy to get information by using SMS notification.

Conceptual Framework

      The goal of this study is to make the Health Center automated from manual process. This system can record and send SMS notification.

Scope and Delimitation

     This system has the following scope and limitations:

Scope        

This study consists of SMS notification, records and similar nature of transaction and processes of barangay health center. For the patient information database, the report generates a purpose and also SMS Notification. This system can be use by the personnel of the Barangay Estefania Health Center. Through SMS Notification they will know the information and schedule activities for the patient and with upcoming events. The SMS notification will transmit the message through the patient about the program from the health center.

Delimitation

This study does not cover the previous years patients records. Only the volunteer can access the system. Volunteers are the ones to make or set appointment of the patient. Once the SMS notification is sent to the patient, the patient can’t reply to the sent message. There is also possibility of SMS failure due to coverage of signals. It also covered maintenance good for 6 months.

Significance of the study

The study will be significant to the following identified beneficiaries:

Patient. They will never forget their schedule for their next visit at the center, it’s because the center have already the system that can sent a notification for all their patients. They have a timely record for just a one click ahead where records can be easily and ready to print out.

BHW. Makes their paper works secure, time consumption manageable, and most of all avoiding human errors and misinformation of the patients records. The main purpose of this is making the reports for the supplies in the center, like the medicines. Is considered as the most informative system in all barangays. By the SMS, it also ease the barangay personnel to send the information to the people. It is needed for health assistance and guidelines for the national investment of technology for the system to be fully functional. Improve client services satisfaction.

Future Researcher. This may acquired the same study, useful research in the future and recommendation of study.

Definition of Terms

       To provide understanding of the following terms used below conceptually and operationally.

Data- Conceptually, as a general concept refers to the fact that some existing information or knowledge is represented or coded in some form, suitable for better usage or processing.

Operationally, is a collection of information that organized so that it can easily be accessed, manage and update.

Record- Conceptually, a thing constituting a piece of evidence about the past, especially an account of an act or occurrence kept in writing or some other permanent form.

Operationally, files where you will find information regarding patients.

SMS Notification- Conceptually, is also commonly referred to as a text message.  With a SMS you can send a message of up to 160 characters to another device.

Operationally, contains information date, time and change of schedule.

System- Conceptually A set of principle or procedure according to which something is done an organized scheme or method.

Operationally, automated filling of records for easy access.

Review Of Related Literature

This chapter includes concepts of related study in the system that show or present the information about the Barangay Health Center with SMS Notification.

LOCAL RELATED STUDIES

• Patient Record Management System

TAB FUSION RMS modules handle everything from entry level tracking to advanced imaging all with enhanced security and optimized workflow. Easy to access patients records management software solution. It can use unity of the entire spectrum of medical records that your institution needs. Make retrieval and viewing of patient (or staff) information easy and secure. Ensures the right information is in the right hands at the right time. Deliver easy to use transparent reporting in a variety of formats. Tab Corporate Headquarters- 2002

http://www.ameshealthcarerecords.com/record-management-system/

• SMS Delivers Patient Support in Many Form

The SMS advantages in Health Care institutions want to connect with their patients via SMS should pay attention to these figures. SMS can help with many aspect of the healthcare process, such as sending patient’s appointment and follow-up reminders, information about schedule changes, timely medical advice and more. SMS also has the advantage of making communication feel more personal, since messages are sent to individual phones.

Sharon Hurley Hall- February 17, 2016

https://www.mobilecommon.com/blog/2016/02/sms-delivers-patient-support-many-forms/

 

 FOREIGN RELATED STUDIES

• Clinic Management System outpatient Management System

It is design to be tool for doctors and also registrar to manage their out patient. Design to provide better service to patient, patient details and other vital information for group clinic such as registration process. Lessen the workload of registrar, where all data are easier to receive without time wasting compare to the manual process where data about patient need to be search in the archive, where required extra effort and time.

Nurzety Aqtar Ahmad Azuan- March 2005

https://sourcetorge.net/project/clinicmanagement

• The Helpful Patients Record System: Problem Oriented and Knowledge Based

A helpful Patients Record System is a problem oriented and knowledge based system which provides the clinician with situation- specific information from the patient record, relevant to the activity within the patient care process. They suggest extending the data model of current patient record system. Knowledge for recognizing and interpreting care situation. Knowledge for how clinician work and what information they need means to rank information according to its relevance in a system situation. Elizabeth Bayelgan-2002

https://www.ncbi.nlm.nin.gov/pmc/articles/PMC2244287

Related System Summary Table

This table shows the features of our system based on the researcher analysis in the comparison of related system according to Barangay Health Center with SMS Notification Management System.

Synthesis

The system that in the related studies, both local and foreign in the system feature they present of each local and foreign that connected to the systems. The 2^nd local related study the patient can access SMS Notification. The 1^st local and 2^nd foreign related study has patient record. Only the second local related study has information schedule. Base on the research both related study doesn’t have similarities in our system.

Methodology

This chapter is to show the flow of system and techniques applied in this study. The purpose explains the use and the process of developing of the system.

System Development Life cycle (SDLC) was designed to build on one another, it is a framework defining tasks performed at each step in the software development process. SDLC is a structure followed by a development team within the software organization. It consists of a detailed plan describing how to develop, maintain and replace specific software by incremental waterfall model.

Development process is structures that impose the development of software. Describing approaches to a variety of tasks or activities that take place during the process. The basic activities or task of development software process are as follow Planning, Analysis, Design, Development, Testing, Implementation and Maintenance phases.

Planning Phase

The project will start upon discussion of the group about the kind of system we will be developing. The group already come up with a list of company we will be visiting for an interview. After that we will come up with the title for our defense. 

Analysis phase

This phase, the researcher will start collecting data and information needed for the system. Involved the flow of the system, as well as their role and responsibility and current process that is being adopted by the health center in daily operation.

Design Phase

                 Figure 2.0: Incremental Waterfall Model

This phase, we design for the system. We will make a Dataflow that will modify how the system flow. And the Software requirement specification this is the reference of the system architect to come up with the design for the system.

After the analyzing the data and information its already read for database program, the proponent were able to plan the interface and start on its design.

Development Phase

This phase is to analyzed the information and the initial design of the system, creating database and using coding in order for the system to work

Testing Phase

This phase is the testing of the system to the administrator or BHW of health center where defects are identified and retested of the system. Until it achieve the standard quality of the system.

Implementation Phase

This phase is presented to the user by the features and system details of documentation. After the documentations, the developers conduct the seminar or survey to the user of the system to test and to check the error in the software. This error will be fix to formal software and to give it to the BHW/ administrator when the system is correctly implemented.

Maintenance Phase

          In this phase, the system require maintenance, edit and delete made by administration or BHW of the system are considered for its enhancement. For the purpose, maintenance of the system is updated only for 6 months.

User’s Acceptance Survey

The system were improved the record of patient and the services in BHW. The Health Center should be enhanced with the activities, the operations of the application of patient with the SMS notification

Requirements Specification

Operational Feasibility

The goals of this system study are to develop the following functionalities:

1. Provides an information schedule for the patient which may help for the patient to know their schedule.
2. Provide the medicine and services for the patients.
3. An SMS notification and mobile application that can be accessed in anywhere through the individual mobile phone.
4. Generates a monthly and weekly patient record.
5. The health center that provides a free consultation, immunization, pre-natal check up and other services that help for the patient.

Program Environment

Front End

HTML is the standard markup language for creating web pages and web applications. With Cascading Style Sheets (CSS), and JavaScript, it forms a triad of cornerstone technologies for the Worldwide Web. Web browsers receive HTML documents from a web server or from local storage and render them into multimedia web pages. HTML describes the structure of a web page semantically and originally included cues for the appearance of the document.

CSS the Cascading Style Sheets Specification (CSS) is a computer language that is used to write formatting instructions. It is the language for describing the presentation of Web pages, including colors, layout, and fonts. It allows one to adapt the presentation to different types of devices, such as large screens, small screens, or printers. CSS is independent of HTML and can be used with any XML-based markup language.

Back End

  PHP is a widely-used open source general-purpose scripting language that is especially suited for web development and can be embedded HTML. PHP is a general-purpose scripting language that is especially suited to server-side web development, in which case PHP generally runs on a web server. Any PHP code in a requested file is executed by the PHP runtime, usually to create dynamic web page content or dynamic images used on websites or elsewhere.

MySQL is an open source relational database management system that uses structure query language, the most popular language for adding, accessing, and processing data in a database. MySQL is noted mainly for its speed, reliability, and flexibility. It is fast, robust and scalable relational database management system.

Technical Feasibility

        Hardware specification (maximum requirement)

Client

• Quad Core Processor
• 1 GB Ram
• Android 5.0 version up to latest version

Server

• Dual Core Processor
• 4GB Ram (internal Memory)
• 320GB Hard drive

Software specification (maximum requirement)

Client

• Google chrome version 6.3.2
• Mozilla firefox  17.6
• Windows 8.0 Pro

Server

• XAMPP

System Architecture

The health center management system will display the network design for the user and end up for the patient. It shows that the system needs the patient to access through internet connection and mobile phone to be able to get information for the efficiency to deliver the information schedule and services.

Cost Benefit Analysis

Cost Benefits Analysis or CBA is the estimation and total equivalent money value of the benefits and costs of the system in order to determine its worth.

Table 2.4: Cost Benefit Analysis

Database Model

Figure 5.0: Entity Relationship Diagram

This figure shows the relationship of each entity. The data gathered into individual entities become basis record and entities. Necessary attributes that simplify the data in the system.

Data Flow Diagram

Admin

Figure 6.0: Data Flow Diagram

This Data flow diagram shows the process between the admin and the volunteer.

Data Dictionary

Table 3.0: Data Dictionary of the System

______________________________________________________________________________

Data field             Type                                     Description

______________________________________________________________________________

Administrator

______________________________________________________________________________

Id                       int(11)                       Id number of Student

Username         varchar(50)               Unique name to access administrator

Password          varchar(50)               Unique key to access administrator

______________________________________________________________________________

Table 3.0: Data Dictionary of the System

Data field	Type	Description
Administrator
Id Username Password	int(11) varchar(50) varchar(50)	Id number of student Unique name to access Unique key to access administrator

 

Prenatal
Prenatal Id First Name Last Name Husband Name Age Address MenstrualHx Menarche Cycle Flow Duration Dysmenorrhea ObgyneHx Past MedicalHx	int(11) text(25) text(25) varchar(50) int(2) varchar(100) varchar(50) varchar(50) varchar(50) varchar(50) datetime(6) varchar(50) text(100) varchar(100)	Refers to the number ID patient to register Refers to the first name of the patient Refers to the last name  of the patient Refers to the name of husband of the patient Refers to the age of the patient Private address for the Patient Refers to the menstrualhx Refers to the first occurrence of the patients first menstruation Refers to the cycle Refers to the flow of blood Refers to the duration Refers to the dsymenorrhe Refers to the obgynehx Refers to the past medication of the patient

Prenatal Nurse Note
Id Prenatal Id Fundamental heartbeat Fatal Height Weight BP Temperature Presentation Complaint  Date Appointment	int(11) int(11) varchar(11) varchar(25) varchar(25) varchar(25) text(100) text(100) datetime(6)	Refers to the number ID patient to register Patient prenatal ID Refers to the fundamental heartbeat Refers to the fatal height Refers to the weight Refers to the blood pressure Refers to the presentation Refers to the complaint Refers to the appointment date

 

Immunization
Id First Name Last Name Gender Mother’s Name Father’s Name Date first Seen Birth date Birth Weight Place of delivery Address Type of delivery	int(11) text(25) text(25) text(25) text(25) text(25) datetime(6) date(6) varchar(25) varchar(50) varchar(50) text(50)	Refers to the number ID patient to register Refers to the first name of the child Refers to the last name of the child Refers to the gender Refers to the mother’s name Refers to the father’s name Refers to the date first seen Refers to the birthday Refers to the birth weight Refers to the place of delivery Private address for the patient Refers to type of delivery

Immunization Visit
Id Immunization ID Service ID Number of Visit Visit Date	int(11) int(11) int(11) varchar(25) datetime(6)	Refers to the number ID of patient to register Patients immunization id Patients service id Refers to number of visit Refers to the date visited

 

Immunization Services
Id Service Name	int(11) text(25)	Refers to the number ID of patient to register Refers to the name of service

 

 

Consultation
Id First Name Last Name Address Head of the family Occupation Age Date of Birth Number of living child Date Weight BP Temperature	int(11) text(25) text(25) varchar(50) text(25) text(25) int(2) date(6) int(11) date(6) varchar(11) varchar(25) varchar(50	Refers to the number ID of patient to register Refers to patients first name Refers to patients last name Private address for the patient Refers to the name of the head of the family Refers to the occupation Refers to the age of patient Refers to the date of birth of the patient Refers to the number of living child Refers to the date of consultation Refers to the weight of the patient Refers to the blood pressure Refers to the patients temperature

Presentation, Analysis, and Presentation of Data

This chapter will exhibit the result of the User’s Survey conducted for the system to the Barangay Health Worker and Nurses.

Presentation

The researcher demonstrates the system’s functionality to the randomly selected respondents. The researcher observed how the respondents respond to the system and perform about technology to the system. In the User’s Acceptance Survey provided by capstone adviser researcher evaluate those respondents, gathered some data and to distinguish the level of acceptance of the proposed system.

Data Analysis

This section presents the analysis of data gathered from the respondents of Barangay Health Worker and Nurses.

Characteristics of the Respondents

The population composed of the Barangay Health Worker and Nurses. The researcher got twenty respondents from the Barangay Health Worker and Nurses.

Table 4.0 Frequency of Respondents

Respondents	Frequency
Nurses/ BNS BHW Total	3 17 20

This table shows the frequency who has answered the User Acceptance Survey. The researcher got total 20 of respondents.

Interpretation of Data

The instrument to access the perception of the users in terms (5) categories namely: Effectiveness, Efficiency, Quality, Timeless and Productivity.

The first category composed of four(4) items, second category composed of three(3) items, third category composed of four(4) items, and then the fourth and fifth category composed of four(4) items with the rating scale was 1 to 5 which are 5 as very satisfied, 4 as satisfies, 3 as neutral, 2 as dissatisfies and 1 as very dissatisfied.

 

 

Table 6.0 Rating Scale

­­­­ Range of Mean                                                Verbal Interpretation

4.21-5.00                                                              Very Satisfied

3.41-4.20                                                               Satisfied

2.61-3.40                                                                Neutral

1.81-2.60                                                                Dissatisfied

1.00-1.80                                                                Very Dissatisfied

This table shows the range of mean and its verbal interpretation.

Table 7.0 Survey Result of Effectiveness

Effectiveness

Question 1        Question 2          Question 3          Question 4        TOTAL

Mean        4.0                  3.55                    4.0                  4.0                     4.0125

Table 7.0 shows that effectiveness as a whole has an average mean of 4.0125 as very satisfied that the users were highly satisfied after the testing.

Table 7.1 Survey Result for Efficiency

Efficiency

Question 1        Question 2          Question 3             TOTAL

Mean                      3.7                 4.0                              4.0                      3.90

The table above shows that efficiency as a whole average mean of 3.90 as a satisfied with the efficiency of the system after the testing.

Table 8.0 Survey Result Quality

Quality

Question 1        Question 2          Question 3          Question 4        TOTAL

Mean      4.0                   4.0                       4.0                        3.75          3.9375

This table shows the survey result for the systems quality recorded a total mean of 3.9375 which is interpreted that the users were satisfied with the systems quality after using it.

Table 9.0 Survey Result Timeliness

Timeliness

Question 1        Question 2          Question 3          Question 4        TOTAL

Mean     3.85                   4.0                       4.0                    3.85                       3.925

This table shows the survey result for the systems timeliness accounted a total mean of 3.925 which is interpreted that the user were satisfied with the efficiency of the system aster testing it.

Table 10.0 Survey Result Productivity

Productivity

Question 1        Question 2          Question 3          Question 4                TOTAL

Mean   3.85                 3.9                       4.2                        4.1                         4.0125

This table shows the survey result for the systems productivity as a whole has an average of 4.0125 which is interpreted that the user were satisfied with the systems productivity after testing it.

Summary of Findings, Conclusion and Recommendation

This chapter presents the summary or the research work undertaken the recommendation and conclusion of an outgrowth of study.

Summary of Findings

This study was conducted purposes of making reliable for Brgy.Estefania Center w/ SMS Notification System. It will be beneficial for Barangay Estefania Health Center workers can work efficiently and access patient records. The system generates the records and can secure the records of the patients. The researcher utilize the interview technique was used for gathering data and also the Users Acceptance Survey serves as elements for collecting data.

The findings of users experience with the system of effectiveness got a total of 4.0125 which is interpreted as a very satisfied for the level of users experience towards the system efficiency got total rating of 3.90 as satisfied. In the term of system quality got total rating of 3.9375 being satisfied for the timeless the users rate of 3.925 as a satisfied and also the productivity got rating of 4.0125 as a very satisfied. The total of whole system proposed was a big help for generating time records and managing the record of patient and also obtaining the security of the records through having restriction between the BNS/ Nurse and BHW.

 

Conclusion

They prepare as much and gathered all the files of patients that recommended the Health Center. The Brgy. Health Center typically shows the information that given into the patients. They notice the system was been essential in managing the records of every patient in Barangay Health Center.