Chapter 1 The challenge and Its Background
Introduction
Mataas na Kahoy Community Clinic is a newly opened business and continues to be operating pertaining to only 90 days, that is why nearly half of the method/work procedures will be conducted personally, may it be around the patient’s record of entrance, on the products on hand of the drugs and on their billing program.
Since there is no technology used, existing billing approach to the hospital functions manually. The billing staff fills-up a printed invoicing form with the price based on various treatments and facility and equipment utilized by the patient.
Employees manually computes the total invoice with the use of a calculator. This procedure is very labor intensive, inconvenient, and prone to problem. Total expenses have to be rechecked/recomputed several times to ensure accuracy and avoid incorrect info. Thus, the staff has to duplicate all the calculation from the start. Hospital’s copy with the patients’ bill is maintained a file file, arranged by date when the patient has been discharged, inside their record section and when someone requests for a copy with their bill, the staff has to by hand browse the required record through the entire file folder.
Page 1 of 43
Based on the reality stated by hospital’s payment staff, the proponents believe that this current system is not really effective and efficient for the staffin generating the bills. That is why the proponents recommended a system since they assumed that the business needs to have an efficient automated invoicing system. Intended for the improvement from the manual system, the supporters proposed something to make a system which interface contains the features found on the invoicing form. When the program with built-in formula for the computation can be integrated for the system, the manual calculation on a calculator will be eradicated. Unlike the manual program, where the invoicing staff produces the price of the patient’s treatment on the billing form, now the staff merely has to enter the patient’s payment on the program and it will automatically calculate for the total amount to be paid.
The system will not need to recheck the bill computation for several times. Hence, the computerized billing program conserves more time and no mistakes will be generated. Another advantage the proposed system gives can be when a sufferer requests to get a copy with their bill, the program has the ability to come with an easy access around the record of the patient’s invoice. This is made possible through the presence of a data source which constantly updates documents on every deal. Instead of surfing the document folder with the Record Section, the payment staff simply has to enter the name from the patient within the system as well as the system is going to check for the record within the database but it will surely list each of the billing info of the sufferer. Upon using a more convenient system, the task from the billing staff is lessened and which has a
Page 2 of 43
anchored database, you will have an easier get on the record of the patients’ bill anytime.
Statement from the Problem
1 . In what way can your bills end up being calculated within a faster and accurate method? 2 . Just how can staff access the billing records easily? 3. How could staff ensure that the studies / information of individuals are highly secured? 4. How can the information be updated automatically anytime there will be improvements into the person’s information?
Aims
1 . To make a system which could compute charges in a quicker and accurate manner. 2 . To develop a process that enables the user to access patients’ records conveniently. 3. To make a system connected to database which will guarantee a high level of to safeguard the patients’ records. some. To make a system that can upgrade records instantly every time that there is information to be modified. Webpage 3 of 43
Significance from the Project
After identifying the hospital’s issue regarding their billing system, the supporters has come up to the idea of bettering the billing system to be a more efficient and effective system. The proponents proposed an automatic billing program for a healthcare facility which will gain the following:
A healthcare facility. Since the proponents is suggesting for a fresh and increased billing system, the hospital will surely benefit from this kind of especially when everyone should know that the community hospital is already technology-dependent in most their establishments and providers. It will gain the trust of every person and because of these; the hospital’s income will be greater than expected.
The Hospital’s Billing Personnel. The suggested system will benefit the billing staff/s since the computations will be done by the system alone. The remedies are already inside the codes therefore it is not a requirement of the staff to compute the bills physically. It can make his/her work quicker and at the same time, they can ensure that all the calculations done by the machine are exact and there are simply no things to become worry about.
The Patients/Customers. They can also benefit from the proposed system because they will assure that the bills that they may be paying are Page 4 of 43
computed properly. Another thing is the fact since the calculation of expenses is now programmed, patients may eventually get their bills faster than predicted.
They will no more wait for a number of years just for their very own bills to get computed.
Foreseeable future Researchers. They may benefit in such approach that they can consider it as a guide for their analysis. It can also be the for them in creating their particular system.
Experts. The researchers will gain benefit system, too. This may be a preparation to allow them to conquer the IT universe in the near future. It will eventually no longer be hard for them to make reports, program analysis, system design, etc ., because they are right now trained in performing such responsibilities.
Scope and Limitation
The proposed invoicing system involves all the computations of a person’s bill ” those who are restricted (in-patient), and others who go to the hospital for check-ups (out- patients). All the patient’s records will be placed on a secured database. There will also be a database for the obtainable rooms for each and every room type to know if the specific space is already occupied or not really. To ensure the reliability, there will be a great authorization pertaining to the user. Only the billing personnel and Site 5 of 43
the head of facilities might have the makes up about the system. A log-in form will be built to ensure that simply authorized users are the kinds who will utilize system and access every one of the billing records. When related to records, it includes all the people who spend on any service done by the hospital” in-patients and outpatients. It will also create a financial statement that is to be given to the hospital’s head of establishments. However , its database is only for the record from the patients’ bill, the system will not provide an products on hand of the medications in the hospital’s pharmacy plus the facilities and equipments applied. It means that the billing personnel must have a duplicate of the rates of the medication and by hand enter individuals on the program. The payment must always maintain cash as the system does not cover any payment carried out either using a credit card or possibly a check. The system does not likewise cover virtually any process regarding having a consultation with the doctors in the hospital.
Meaning of Terms
ï‚·
Automated Payment System ” the kind of program the advocates is proposing for the Mataas na Kahoy Community Hospital.
ï‚·
Fee(s) ” those that should be computed and totaled which can be to be paid by the patients / customers.
Web page 6 of 43
Patient(s) ” they are the person who will be paying the fees. They are the customers of the hospital.
Hospital Staff(s) ” they are the users of the program. They will be the main one who will enter the fees around the system.
Brain of Establishments ” the one who will obtain the reports that is generated by system.
Charge cards ” can be utilised for repayment especially when the bill is too costly to be paid by cash.
Calculator ” the material utilized to compute the fees employed by the patient within the manual invoicing system.
Repository ” this will serve as the storage from the patients’ costs information. This will keep all of the patients’ costs records to have an easy access with it whenever a record will be searched.
In-patients ” patients that are confined inside the hospital. Out-patients ” all those patients who only go to the hospital for a check-up.
Radiology ” the laboratory evaluation done with the use of x-ray devices.
Page several of 43
Chapter 2 SYSTEM ANALYSIS
This chapter discusses the Data Circulation Diagram (DFD) of the existing billing system of Mataas em Kahoy City Hospital as well as the proposed system. This phase also protects the Operational Framework of the proposed system.
Operational Platform of the Suggested System
Fig. 2 . 1 ” Example of the Functional Framework of MnKCH Billing System
Webpage 8 of 43
MnKCH(Mataas mhh Kahoy Community Hospital) Invoicing System is an application that
provides a more quickly and appropriate computation of patients’ charges. All the entered information will be stored over a database. The database will then create information that are to become viewed by head of facilities and the hospital’s movie director.
Data Stream Diagram (DFD) of the Current System
Fig. 2 . 2 ” Representation of the Context Level DFD of the existing system
Webpage 9 of 43
Fig installment payments on your 3 ” Illustration of the Level 0 DFD of the existing system
The current payment system of Mataas na Kahoy Community Hospital is operated by hand. In this program, there are techniques whenever a affected person is going to pay out. The first step may be the billing staff will write the entire treatment fee of the patient on a printed invoicing form. All things considered the necessary medications and treatment fees are written, the billing staff will now figure out the total with the bills with the aid of a calculator. After checking out the computation 2 times, the patient will certainly
Page 10 of 43
be capable of geting a copy on this billing type as a invoice. Another duplicate of each billing form of the two outdoor and indoor patients’ are kept on a file file for the hospital’s backup. These invoicing forms will be arranged by the date of discharge of the patient. The hospital also gives a Record Section Room for important paperwork like the invoicing forms and whenever a patient is going to demand a copy of their billing type, the staff is going to browse the file folders.
Data Flow Plan (DFD) in the Proposed System
MnKCH Payment System is the name of the proposed automated billing approach to the Mataas na Kahoy Community Medical center. To use the system, the user (or thebilling staff) is required to fill-up a log-in form to get security purposes. The log-in details of the consumer is now stored on the Admin database. In this case, the user may well now access the system anytime just by visiting in into the system. Following logging in, the staff can now enter every one of the treatment information used by the individual (in-patient as well as out-patient). After entering every detail, the computed total bill will instantly be made at the bottom of the billing type. A published billing declaration will be given to the patient while his/her backup. She/he will pay the desired figure to the invoicing staff. Following receiving the repayment, the staff will print a receipt that will be directed at the patient. During the printing method, the data source will be instantly updated since it is connected to the program. The check information will be stored on the Person’s bill records/ database. Following Page 10 of 43
stamping the invoice, a report made up of the information from the newly moved into treatment information can be viewed and printed to get submitted for the head of facilities.
Every time a patient demands a copy of their bill data, they may request a copy in the staff. The billing personnel will merely enter the term of the sufferer on the search box of the system and the patient’s record will appear on the screen. It is now willing to be branded and then willing to be given for the one who wanted it.
Fig. 2 . 5 ” Representation of the Framework Level DFD of the suggested system
Webpage 12 of 43
Fig. 2 . 5 ” Illustration in the Level 0 DFD from the proposed system
Page 13 of 43
Section III PROGRAM DESIGN
GRAPHICAL USER INTERFACE DESIGN
a few. 1 . Welcome Menu The welcome menu shows the hospital’s emblem together with its name. There is a press button which is intended for log-in purposes.
Page 18 of 43
a few. 2 . Log-in Form The log-in form can be used to allow people who may use the system.
a few. 3. Log-in Failed
Web page 15 of 43
The example above could be the look with the system when the user moved into incorrect username/password.
3. four. Main Menu Whenever the logging in of the consumer to the product is successful, the key menu will appear.
Page of sixteen of 43
three or more. 5. Menu ” Add ” Individual Info of In-Patient This will be the proper execution look like when the user will certainly add a patient that will be limited (in-patient).
Web page 17 of 43
3. 6. In-Patients’ Affected person Information User interface After selecting the Add In-Patient’s Data, the above kind will appear. The proper execution will require you enter some basic information of the patient. The system will also need the user to find the room type wanted by the patient. Following selecting the room type, an individual needs to look for the offered rooms through the search button.
Page 18 of 43
a few. 7. Selecting Room ” Room Type: Ward This type shows the rooms / room no . the ward contains. All those disabled areas are the bedrooms that are already occupied. It has been disabled to avoid inconsistency. At the upper underlying part of the contact form is a textbox that will quickly shows the chosen room to get the patient. When the user is performed selecting the area for the newly accepted patient, he/she must click on the OK press button to validate the selection.
Web page 19 of 43
3. almost eight. Selecting Area ” Area Type: Semi ” Non-public
3. being unfaithful. Selecting Area ” Space Type: Non-public
Page twenty of 43
several. 10. Accomplished Patient Details Form After clicking the OK button of the earlier form, it will eventually automatically return to the person’s info kind. The form that could appear is currently a complete affected person information kind that may certainly be saved.
Webpage 21 of 43
3. 11. Menu ” Add ” Patient Details of Out-Patient This will the shape look like upon selecting the Add Away ” Person’s Information.
Webpage 22 of 43
3. doze. Out-Patient’s Info Interface Since out-patients happen to be those who have only gone to the hospital for their check-ups, the form don’t have to have the “Date and Time Admitted feature. Instead, it will have the day of check up.
Page twenty three of 43
a few. 13. Adding In-Patient’s Computation
When a individual will be dismissed, his/her bills must be calculated. The form over shows just how it looks like when the user chooses a new computation for the in-patient.
Web page 24 of 43
11, 800. 00
3. 14. In-Patient’s Billing Type This is the invoicing form of the in-patients. All the details has been included to the form. Those costs that are pointed out with color grey happen to be fixed fees. It has been produced as read-only to avoid editing of the fixed charges.
Web page 25 of 43
3. 15. Adding Out-Patient’s Computation
This can be a illustration of what the system will look like following selecting the out-patient’s calculation.
Page 26 of 43
3. 16. Out-Patient’s Billing Type
Above may be the out-patient’s payment form. At the end is a key named “Print. If the customer click the Printing button, it will eventually view the produce preview.
Webpage 27 of 43
3. seventeen. Print Survey
Page twenty-eight of 43
After computing the bills, along with clicking the button within the former form
the print preview will appear. In this feature of the program, the user can see the branded form of the patient’s bill statement.
several. 18. Menu ” Search Record
It can be what the program look like whenever a record is to be searched.
Page 29 of 43
3. 19. Search ” All Documents Upon clicking on the Search Record, almost all records will be at first. There exists a text package on the rightmost top corner of the kind. There, the machine will let the user get into any of the information on the patient he is looking.
Page 35 of 43
a few. 20. Search ” Time Discharged Details about the person may be moved into on the input box. For example , is the date the person had been discharged. The date may be entered on the search field and upon clicking the button, the program will show all of the possible outcomes.
Page 31 of 43
several. 21. Search ” Particular date Admitted
Another example, is definitely the date the sufferer had been admitted. All the feasible results with the keywords the person have came into will appear around the form.
Web page 32 of 43
3. twenty-two. Search ” Last Name An additional patient’s details that may be joined on the search field is the name with the patient. Once the staff joined the name of the patient, it will instantly be displayed by the system.
Page 33 of 43
a few. 23. Menu ” Perspective Report Observing reports is definitely the feature from the system that may be enabled equally for the billing staff and the brain of facilities. After selecting the view survey, the system will be directed to an additional page which can be the report itself.
Web page 34 of 43
3. twenty four. Monthly Report
This will become the made report by the system. It may be printed by any of the billing staff as well as the head of facilities for a few reasons.
Page 35 of 43
3. twenty-five. Menu ” Exit
This is the menu kind wherein the chosen action by the user is exiting the system.
Page thirty six of 43
a few. 26. Quit ” Affirmation
If the user selected the exit feature of the system, a message credit reporting the wearer’s choice will be. If the user clicks the “Yes key, the system is going to eventually close. However , whenever the user click the “No key, it will get back to the main menu of the system.
Page thirty seven of 43
Section IV Implementation Strategy
This chapter discusses the setup model being used in the MataasnaKahoy Community Hospital. This consists of implementation unit, andgradual operations of execution like installation and training and personnel development.
Execution Model For the application of new system being implemented, it is significant to choose the right model. Each system needs different models. After the analysis from the existing system, the proponents chose the Direct Installation (Cutover). A cut-over implementation takes place in a single, main event. All modules during installation across the entire organization at the same time, more or less. Following your planning actions have been efficiently executed, this system will be turned off, plus the new program will be released. At this point you cannot find any turning back. The new system, which is the automated billing system, is going to replace the manual payment system. The most frequent criticism may be the risk element; there are a number of things that can go wrong instantly changeover. Nevertheless , the execution is quick and less costly than a extended, drawn-out took approach. Webpage 38 of 43
Figure four. 1 ” Direct Cutover Implementation
Advantages of Cut-over rendering: 1 . Rendering time is usually shorter. installment payments on your Costs are much lower than an extended, drawn-out rendering. 3. Users only need to be train within the new program, not for the changeover period. 4. Setup happens about the same date. Doing System Rendering There is a risk factor after replacing directly the manual system, while using automated 1 cause issues could come out wrong in a rapid change. Because of this, mindful system assembly and proper training of end-users can be an indispensable component to IT service to provide very good system protection.
Page 39 of 43
Initially task is to install correctly the recommended system system on the hospital’s personal computer used on cash orders. Upon assembly, proponents need to make sure that all data files (e. g. exe data files, documentations, etc . ) are very well copied and stored on a secured folder because incorrect installationof this software may lead to program errors. Following the successful installation of the software may be the turn to introduce it for the end-users. The proponents need to certainly give to carry out all required trainings the end-users required. Since they produced the software, intro and familiarization of the fresh system for the end-users must be conducted successfully.
This alignment style schooling includes details and manual steps on how to operate the new system beginning with the very simple parts like specifying all the program features and define the function of each up to the most complex ones like how to troubleshoot the program when an incorrect info will be joined. Proper hands-on training will be provided by the proponents to get a span of one week to help the clients if ever a major problem occurs. This consists of proper utilization of the system as well as resolving possible errors that could occur through the entire run time of the program. On the succeeding weeks, the advocates would simply have to visit and observe the circulation of progress with the program and the clients for three to four moments a week.
Page 40 of 43
Chapter Sixth is v CONCLUSIONS AND RECOMMENDATIONS
This kind of chapter comes with the a conclusion of the study together with the tips from the researchers. This chapter aims to decide and assess the significance of changing the existing billing system of Mataas na Kahoy Community Medical center.
Conclusions
Following your analysis and study, the researchers created the following results:
1 .
The current system, a manual payment system, is definitely not an effective and effecient system towards the staff and patients in the Mataas bist du Kahoy
Community Medical center, instead this consumes lots of time and effort.
2 .
There is a need to to replace the current system with a brand new and improved billing system.
3.
The hospital’s payment staff as well as the head of facilities are demanding for any new program which can be an effective and
Page 41 of 43
effective system in replacement for the existing manual billing system. 4. The proposed fresh system helped making the service quicker than previous service provided by the hospital. Since there is the proposed system, the condition of the hospital with their existing billing system which is that they use wide range of time in processing the patients’ bills, have been solved. For the reason that the new system automatically computes the total expenses of the patients without the usage of calculator. The modern system decreased the time consumes by the staff in calculating the treatment service fees.
Recommendations
Getting the conclusions above, the following suggestions were hereby given by the researchers:
1 ) The analysts recommend replacing the existing payment system of Mataas na Kahoy Community Medical center. The new payment system will definitely be an effective and effective system to the staff, as it will figure out the bills entered by the staff to the system instantly; and to the patients from the Mataas mhh Kahoy Community Hospital
Site 42 of 43
because since the computations of bills will be done automatically, they will no longer wait for a very long time just to have their bills computed. 2 . The researchers as well suggest that the device must be linked to a databases for the storage with the patients’ information. With the repository, the reviews that must be given to the head of facilities will probably be generated more quickly. The information will also include a more look good look compared to the former studies the existing system had made. 3. One more recommendation the researchers can give is the purchasing of an additional computer to implement the new system. It is due to the fact that the modern billing product is an automated program and may simply only be used through computers. There are many brand-new computer products which costs less than others. It may make them to make all their work easier and faster.
Page 43 of 43
1
