Transcription

(IJID) International Journal on Informatics for Development, e-ISSN: 2549-7448Vol. 7, No. 2, 2018, Pp. 48-53An Implementation of Web-Based Payroll InformationSystem in Universitas Proklamasi 45 YogyakartaMaria Ulfah SiregarInformatics Department, Master Program, Faculty of Scienceand Technology, Universitas Islam Negeri Sunan KalijagaYogyakarta, [email protected] Eko Katon MahardikaStudent of Informatics Department, Faculty of Science andTechnology, Universitas Islam Negeri Sunan KalijagaYogyakarta, as Proklamasi 45 Yogyakarta is a private university which is supervised by a Foundation that has implementedvarious information systems in various fields of work. However, in the payroll process of the employees are still done manually and havenot utilized a computerized system, such as attendance recap, wage recapitulation that is additional salary to basic salary, and the sum ofsalary received by employees. This makes the payroll process less effective and efficient. This study aims to establish a proposed systemthat is a web-based information system of employee payroll in the Universitas Proklamasi 45 Yogyakarta with the PHP programminglanguage using Codeigniter Framework and MySQL as its database. The system development method used is the Extreme Programmingmethod. This method was chosen because it promotes intense communication between the client and the system developer so that whenthere are changes or errors in the system, the developer is always ready to fix it. Extreme Programming also has a simple stage, namelyplanning, design, coding, and testing. The results of this study are the result of a web-based employee payroll information system that hasvarious actors involved in the management and processing of its data. With this information system, the employee payroll process becomesmore effective and efficient, because payroll data is processed and calculated by the system so that it has a high level of data accuracy anddoes not require a long time in the calculation process.Keywords-Web Application; Information System; Payroll System; Codeigniter; Extreme Programming

(IJID) International Journal on Informatics for Development, e-ISSN: 2549-7448Vol. 7, No. 2, 2018, Pp. 48-53I.INTRODUCTIONII.Technological advances today are experiencing very rapiddevelopment in various fields. This is marked by theimplementation of a service system that has been computerizedin various agencies and various fields in order to provideconvenience both for the company and for users in order to findinformation quickly and accurately. Many companies arecompeting to implement a computerized system that suits theneeds of the company with the aim of improving and optimizingthe quality of their services. Not even a few companies thatinclude the application of a computerized system in their visionand mission.PURPOSEThe formulation of the problem raised from the backgroundabove is:One system that is widely used in a company in order tooptimize their service quality is the application of a payrollinformation system, which is expected to help and facilitate thepayroll process of employees. The implementation of the payrollinformation system is very influential on companies or agenciesthat have a large number of workers. Furthermore, thecomponent of employee wages or salaries is not only the basicsalary, but also includes various allowances, incentives,deductions, overtime and other wages outside the basic salary[1]-[5]. The amount of salary for each workforce is alsodifferent. If the salary calculation process is still manual, it canbe detrimental to the company in terms of time efficiency, whichwill take a long time, so that it can result in delays in payment orpayment of salaries to employees.1.Analyzing and designing a web-based Employee PayrollInformation System in the Yogyakarta ProclamationUniversity 452.Implementing the information system into the employeepayroll process in the Universitas Proklamasi 45Yogyakarta so that it becomes an effective informationsystemIII.RESEARCH METHODSA. Data Collection MethodologyData were collected from various sources. Methodologythe data collection performed in this study are:1) Literature Study: Studying the theory / literature andscientific books and references related to PayrollSystem and Web-based technology applications.2) Interview: conduct interviews with the project ownerregarding the current employee payroll process.3) Observation: make direct observations when theemployee payroll process takes place.B. Identification of ProblemsThe main problems that occur in payroll processing aresuch as the calculation of attendance recap, payroll componentdata recap, making reports and salary slips that are donemanually. This requires a high level of accuracy considering thatsalary is a right of each employee to receive a valid salaryamount, so that it takes a long time in the process of calculatingand processing data. The problems contained in this research canbe developed with a web-based system, namely the PayrollInformation System. This system will help solve the problembecause it is computerized and automated so that the dataprocessing and salary calculation can be carried out validly andquickly.Universitas Proklamasi 45 Yogyakarta is a private universitywhose management is supervised by a Foundation. In every fieldof work, almost all have used information systems to facilitatetheir work and managerial governance. But in the employeepayroll process, it is not yet effective and efficient because theprocess is manual or does not utilize an information system, soit still has some shortcomings. These shortcomings includepayroll processes that take a long time, the accuracy of datacalculation and documentation of data is not well organized. Oneof the things that makes the payroll process take a long time isto recap data that affects the amount of salary nominal calculatedmanually, such as employee attendance recap, recap overtimedata, and recap of wages other than basic salary. Therefore, it isnecessary to have an effective, efficient and effective employeepayroll information system to be used in the employee salarycalculation process at the Yogyakarta Proclamation University45 Yogyakarta.C. Application DevelopmentSystem development method used in this research isExtreme Programming method. Extreme Programmingsequential system consist of:In designing information systems, there are problems thatoften occur, namely the request for changes in requirements andthe addition of features to the system desired by the client whenthe system design process is carried out [6]-[8]. Therefore, asimple system development method is needed and involvesclients in terms of communicating with system developers [9].Extreme Programming method is one of Agile methodologiesthat emphasizes good communication with clients, is fast in thedevelopment process, and is ready to accept changes andimprovements whenever there is an error. Therefore, theExtreme Programming method is used in designing thisemployee payroll information system.1) PlanningAt this stage defines the scope during the research,analyzes the current system and the problems thatoccur. Then it continues by analyzing the requirementsof the system to be designed.2) DesignAt this stage, designing the system work process anddatabase design in accordance with the results of datacollection and the results of the analysis that has beencarried out. In designing the work process of thisThis article is distributed under the terms of the Creative Commons Attribution-NonCommercial-NoDerivatives 4.0International License. See for details: 49

(IJID) International Journal on Informatics for Development, e-ISSN: 2549-7448Vol. 7, No. 2, 2018, Pp. 48-53a. Master data management which includes employeedata, position, work unit, work period, and nominalpayroll components.system, UML is used because it places more emphasison developing object-oriented systems.3) CodingAt this stage is the stage where making the systembased on the design results that have been madepreviously. The design is implemented in the form ofcode that can be understood by computers withprogramming languages. As previously explainedabout Extreme Programming that this method involvesthe client in the system development process, theCoding process is carried out repeatedly if there is acorrection from the system user (refactoring).4) TestingAt this stage, each module that is being developed willfirst undergo testing. If it is still not in accordance withthe request, it will be repaired on the corrected part. Ifaccording to the request, the system can beimplemented.b. Payroll component data management whichincludes overtime data and meetings.c. Management of employee attendance data whichincludes employee attendance data uploads andprinting employee attendance recap data.d. Management of academic data which includesfaculty data, study programs, courses, studentexaminations, exam supervisors, and test resultscorrector.e. Management of payroll data that includesgenerating pay slips, printing pay slips, sendingpayroll slips, and seeing payroll reports.f. Providing operational incentives for employees bythe division heads of each division.g. See payroll data that can be done by each employee.IV.SYSTEM DEVELOPMENT USING EXTREMEPROGRAMMING2) First Phase DesignIn this first phase design the researcher makes thedesign process in the form of a use case diagram based onthe results of the analysis that has been carried out. Thepurpose of making a use case diagram is to describe whatfeatures or functions the system has developed. Fig. 1shows the use case diagram of this system.In developing the system using the Extreme Programmingmethod, this resulted in three development phases. Anexplanation of each of these phases can be seen below.A. First PhaseIn this first cycle, it focuses on the main purpose andfunctionality of the system being developed.1) First Phase PlanningIn this first planning phase, the researcher analyzes therequirements of the developed system. The analysis iscarried out by means of interviews and discussions with theproject owner. The results obtained are anyone who willuse the system later, and how the system works. Usersinvolved in the system can be seen in the Table 1.TABLE 1. LIST OF USERS WHO USE THE SYSTEMNoUsers1.HR Staff2.Academic Staff3.Financial Staff4.The head of the company5.Head of Unit6.EmployeeFigure 1. Use case diagram first phaseNext, the researcher makes an activity diagram todescribe the activities that occur in the system. There aremain activities, namely uploading employee attendancedata and generating employee pay slips. Activity diagramcan be seen in Figure 2 and Figure 3.The next step is to define and analyze the systemfunctional requirements which aim to determine what canbe done by the developed system. Functional requirementsare:This article is distributed under the terms of the Creative Commons Attribution-NonCommercial-NoDerivatives 4.0International License. See for details: 50

(IJID) International Journal on Informatics for Development, e-ISSN: 2549-7448Vol. 7, No. 2, 2018, Pp. 48-53Sequence Diagram design is also needed to explain indetail the sequence of processes carried out in the systemto achieve the objectives of the Use Case that have beendescribed previously. The Sequence Diagram can be seenin Figure 4 and Figure 5.Figure 5. Sequence diagram of generate payslip3) First Phase CodingIn this first phase coding, several implementations werecarried out which included database implementation andimplementation of the interface design that had beencreated. In the database, there are many tables used. A listof database tables can be seen in the Table 2.Figure 2. Activity diagram of employee attendant data uploadTABLE 2. LIST OF TABLE ON DATABASE IN FIRST PHASENo.Table NameNo.Table Name1.Master bidang12.Data rapat peserta2.Master unit kerja13.Data upah rapat3.Master jabatan14.Data lembur4.Master periode15.Data upah lembur5.Master jam kerja16.Data ujian6.Master prodi17.Data ujian pengawas7.Master matakuliah18.Data ujian korektor8.Master nominal19.Data upah pengawas9.Data karyawan20.Data upah korektor10.Absensi data21.Data insentif operasional11.Data rapat22.Data slip gajiFigure 3. Activity diagram of generate payslipNext, implementation results of the interface designcan be seen in Figure 6 and Figure 7.Figure 4. Sequence diagram of employee attendant data uploadFigure 6. Login pageThis article is distributed under the terms of the Creative Commons Attribution-NonCommercial-NoDerivatives 4.0International License. See for details: 51

(IJID) International Journal on Informatics for Development, e-ISSN: 2549-7448Vol. 7, No. 2, 2018, Pp. 48-53e. Speed up the process of generating employee payslips.B. Second PhaseIn this second phase, there are fundamental differences withthe previous phase, which is more focused on improving systemperformance. It can be seen from the results of the first phasetesting.1) Second Phase Planning and DesignThe purpose of changing the way of working from theinput date field is, so that the date entered is no less or nomore than the initial limit and the deadline for the selectedwork period. So, before the work period is selected, theinput date field in the disable state. This is an effective stepso that the data entered into the system is more properlydocumented and neat based on its working period.Figure 7. Generate payslip page4) First Phase TestingIn this first phase of testing researchers involve all usersof the system and focus on the functionality of the systembeing developed. During the testing process, researchersget requests for the addition of several new features,namely:Furthermore, the purpose of adding automaticattendance recap functionality is when HR staff uploadattendance data, the system will read and store attendancedata into the attendance data table, while simultaneouslyrecording the attendance data which will then be stored inthe attendance recap table. This will have an impact onsystem performance when generating employee pay slips,because the process of generating payroll slips requiresmonthly attendance recap data from each employee. Whenthe process of generating pay slips, the system simply readsthe attendance recap data from the attendance recap table,no longer need to do calculations or calculation of dailyattendance data from the attendance data table.a. Change behavior from each date input field, will bedisabled when the work period has not beenselected.b. Automatic attendance recap when the attendancedata upload process is done.c. Change employee attendance data.d. Employee overtime submission.In this phase, changes and additions are made to thesystem database structure, which is adding a table calledemployee attendance recap and changing employeeovertime table. The design of new pages is also done,namely the employee attendance data change page and theovertime request page by employees.C. Third PhaseIn this third phase, further development is carried out on thesystem by adding several new features based on the projectowner's request. This feature is considered effective by theproject owner when applied to the system because it is alsoincluded as one of the factors that influence the amount ofemployee payroll.2) Second Phase CodingAfter analysis and redesign, researchers carried out theimplementation of the system developed. In this secondphase, the code structure changes or commonly referred toas refactoring.1) Third Phase Planning and DesignThe reason for the addition of employee work reportmanagement features and employee performanceappraisal features is as a parameter and also the referenceused by the Head of Unit in providing operationalincentives to employees who are under him. In addition tothe current system, employees make work reports usingMicrosoft Excel which then sends it to the Head of the Unitvia email. The Unit Head must open one by one the workreport file sent to him when he wants to see and check whatthe employee's work report looks like. This will take a longtime.At this stage the researcher again designed the activitydiagram and sequence diagram for the management ofemployee work reports and employee performanceappraisal. It also creates a new table in the database,namely the daily work plan and report tables, detailedtables of daily work plans and reports, checklist tables and3) Second Phase TestingIn the second phase of the testing, it was re-conductedwith the project owner. The results of this test are that thereare several requests for additional new features in thesystem, namely:a. Additional employee work report managementfeatures for employees, which can be used to createdaily work plans, daily work reports, monthlychecklists, and monthly work reports.b. The addition of employee performance appraisalfeatures by the unit head.This article is distributed under the terms of the Creative Commons Attribution-NonCommercial-NoDerivatives 4.0International License. See for details: 52

(IJID) International Journal on Informatics for Development, e-ISSN: 2549-7448Vol. 7, No. 2, 2018, Pp. 48-53monthly reports, detailed checklist and monthly reporttables, and employee performance appraisal tables. Thenit continues by designing the interface for the employeework report management page which includes pages fordaily work plans, pages for daily reports, monthlychecklist pages, and pages for monthly reports.development. In each phase there is always a testing phase thatinvolves the project owner to find out whether the system is inaccordance with the needs or not. The system development phaseis declared complete when all planned system functionality issuccessfully implemented properly and does not get correctionfrom the project owner.Based on research that has been done on the development ofWeb-based Employee Payroll Information System usingExtreme Programming method (case study in UniversitasProklamasi 45 Yogyakarta), then the conclusions drawn asfollows:2) Third Phase CodingBased on the results of the design in the third phasedesign, the researcher then implements the addition offeatures to the system developed. The first is to implementwork report management features for employee actors bycreating pages for daily work plans and reports, as well aspages for checklists and monthly reports.1) This study succeeded in analyzing and designingemployee payroll information systems in accordancewith the payroll flow in the Universitas Proklamasi 45Yogyakarta based on the results of the analysis that hasbeen carried out.3) Third Phase TestingAfter implementing the feature additions in theprevious stage, the researchers tested the system againwith the Proclamation University 45 as the project owner.The results of this third phase testing are in accordancewith the planning that researchers have done before, andthe output produced is in accordance with the projectowner's request. Therefore the developed system is readyfor release.2) This research succeeded in implementing the employeepayroll information system at the UniversitasProklamasi 45 Yogyakarta so that it became aneffective information system.REFERENCES[1]V.RESULTThe previous employee payroll process requires work orsalary calculation activities manually. With this payrollinformation system, the manual calculation can be left behindand switch to using an information system. Payroll data iscalculated and presented neatly in the system. Payroll slipswhich are the final result of the payroll component calculationprocess can also be obtained by utilizing this payrollinformation system. Based on the explanation above, the payrollinformation system that was designed during this study waseffective to be used in the employee payroll process because interms of results it was in line with what was expected.[2][3][4][5][6]In terms of time, the payroll information system that wasdesigned also succeeded in increasing efficiency in theemployee payroll process at the Universitas Proklamasi 45Yogyakarta. In the previous system, manual payroll calculationtook quite a long time considering the number of data and thenumber of employees was not small. The calculation must alsobe careful and accurate so that the results are accurate, sosometimes it is not enough if you only do calculations only onceand need to be reset. With this payroll information system, datais calculated and processed by a computerized system so thatthe level of data accuracy increases and does not take a longtime. Based on this explanation, an efficient payroll informationsystem for use in the employee payroll process.VI.[7][8][9]Alhadi, “Sistem Informasi Penggajian dan Pengupahan KaryawanMenggunakan Arsitektur Hierarchial-Model-View-Controller FrameworkPHP Codeigniter (Studi Kasus di PT. Krakatau Wijatama Cilegon,Banten),” Skripsi: UIN Sunan Kalijaga, 2013Ardhi, D. P., “Pengembangan Sistem Absensi dan Penggajian Karyawandi PT. X,” Skripsi, Yogyakarta: UIN Sunan Kalijaga, 2011.Dewanto, S. P., “Perancangan dan Implementasi Sistem Informasi Cost ofProduction (COP) dan Pengajian Karyawan Penerbit Buku PendidikanDeepublish (CV Budi Utama) Yogyakarta,” Skripsi, Yogyakarta: UINSunan Kalijaga, 2013.Firdaus, M., “Rancang Bangun Sistem Informasi Penggajian Karyawan diCV. Sogan Jaya Abadi dengan Metode Prototyping,” Skripsi, Yogyakarta:UIN Sunan Kalijaga, 2017.Hutama, P. W., “Rancang Bangun Aplikasi Presensi Karyawan BerbasisAndroid dengan Metode Extreme Programming pada PT. GeschoolCerdas Mandiri,” Skripsi, Yogyakarta: UIN Sunan Kalijaga, 2016.Jogiyanto, H. M., Analisis dan Desain Sistem Informasi. Yogyakarta:Penerbit Andi, 2005.Kadir, A., Pengenalan Sistem Informasi. Yogyakarta: Penerbit Andi,2003.Whitten, Bentley & Dittman, Metode Desain dan Analisis Sistem.Yogyakarta: Psenerbit Andi, 2004.Daqiqil, I., “Framework Codeigniter Panduan Terbaik dan Best CLUSIONThe use of Extreme Programming methods in thedevelopment of this system resulted in three phases ofThis article is distributed under the terms of the Creative Commons Attribution-NonCommercial-NoDerivatives 4.0International License. See for details: 53

(IJID) International Journal on Informatics for Development, e-ISSN: 2549-7448 Vol. 7, No. 2, 2018, Pp. 48-53 An Implementation of Web-Based Payroll Information System in Universitas Proklamasi 45 Yogyakarta Maria Ulfah Siregar Informatics Department, Master Program, Faculty of Scienc