Enhancing Leave Management through an Online Employee Leave Application System

Abstract

  • Manual leave processing at PT. Citra Bonanza Express (and the related case of PT. Indomarco Adi Prima) causes inefficiencies, error-prone records, and lack of transparency.
  • Study goal: build a web-based Online Employee Leave Application System that streamlines requests, approval, tracking, and reporting.
  • Methodology: classic Waterfall model ➜ requirement analysis → design → implementation → testing → maintenance.
  • Outcomes reported
    • Marked increases in processing speed, data accuracy, and managerial visibility.
    • Real-time dashboards, automated balance calculations, PDF exports.
    • Facilitates data-driven decisions for HR and executives.
  • Potential for replication across organizations facing similar challenges.

Introduction

  • Leave management = critical HR function; efficiency benefits both employees (easy requests) & managers (monitoring & compliance).
  • Manual systems generate paperwork, double entry, and miscounts.
  • IT adoption in HR (HRIS, web apps) offers scalable solutions
    • Reduces administrative load
    • Enhances decision quality through analytics
  • Research context
    • PT. Indomarco Adi Prima confronted with manual process limitations.
    • Aim: introduce a web-based platform guided by established software-engineering best practices.
  • Chosen development model: Waterfall (Sommerville & Sawyer 19971997) because of its linear, well-defined deliverables—suitable for stable requirements.
  • Testing approach: Black-box (Yourdon 19891989) to verify functionality without code inspection.

Literature Review

2.1 Online Leave Application Systems

  • Digitisation removes paperwork, reduces errors, supports “anywhere-anytime” access (Basili 20122012).
  • Empirical evidence (Zhang et al., 20182018): improves policy compliance & user satisfaction.

2.2 Web-Based HRM Systems

  • Provide real-time data, cross-module integration, scalability (Pressman 20142014).
  • Positive impact on engagement & efficiency (Lee & Lee 20172017).

2.3 Benefits of Digital Leave Management

  • Auto-calculates balances; transparent workflows; detailed analytics (Yourdon 19891989; Chen et al., 20192019).
  • Raises satisfaction by shortening turnaround times.

2.4 System-Development Methodologies

  • Waterfall: sequential phases ensure rigorous validation; works when requirements are fixed (Petersen et al., 20142014).

2.5 Case Studies

  • Rumbaugh et al. (20042004) show higher efficiency & morale in large org.
  • Bertalanffy (19681968) stresses user-centric design.
  • Dutta & Sarkar (20162016) emphasize cultural tailoring.

Research Method (Waterfall Model)

  • Planning
    • Define scope, resources, milestones.
  • Analysis
    • Elicit functional & non-functional requirements (e.g., multi-role access, PDF reporting).
    • Assess competing sites to borrow proven UX patterns.
  • Design
    • Produce architecture diagrams, ERD, UI wireframes, integration & test plans.
  • Development
    • Code modules; perform unit & integration tests; fix defects.
  • Testing
    • Black-box scenarios (login, CRUD, approvals) – all 1919 cases passed.
  • Maintenance
    • Ongoing support & incremental improvements post-deployment.

Analysis Findings & Problem Definition

  • Many firms still unaware IT can handle leave; rely on paper/email.
  • Employees at PT Citra Bonanza Express largely manual labor; require simple, low-training solution.

Solution Procedure

  • Web site emphasises “3 E’s” metaphor:
    1. Ease – intuitive UI lowers learning curve.
    2. Efficiency – request in seconds, not days.
    3. Economy – saves printing & HR manpower costs.

System Design Artifacts

  • Use-Case Diagram: actors = Employee, Supervisor, HRD. Core cases: login, submit request, approve, generate report, reset balances.
  • Activity Diagram: illustrates workflow from draft request → supervisor review → HRD final approval → update balances.
  • Sequence Diagram: message flow among UI, controller, database for each event.
  • Database Design (ER/Relational)
    • Tables: users, departments, positions, leavetypes, leaverequests, leave_history.
    • PK/FK relationships ensure referential integrity.

Results & Discussion

4.1 System Specification Document

  • Defines functional scope, performance targets, and constraints (budget, technology).
Minimum Hardware (development environment)
  • CPU: Intel Core 2 Duo.
  • RAM: 4 GB4\text{ GB}.
  • Storage: 120 GB120\text{ GB} SSD.
Minimum Software
  • OS: Windows 7.
  • Web server: XAMPP (Apache + MySQL).
  • Browser: Google Chrome.
  • Code editor: Visual Studio Code.

4.2 Application Usage Walk-Through

  1. Launch XAMPP → start Apache & MySQL.
  2. In browser navigate to http://localhost/cuti.
  3. Login screen verifies credentials → redirects to role-specific dashboards.
Role-Based Dashboards
  • HRD: master-data CRUD, approval queue, PDF reports (Approved / All), reset balances.
  • Supervisor: view subordinates’ requests, approve/reject, view history.
  • Employee: submit request, track status, view personal leave balance & history.
Key Screens & Functions (Figures 6-13)
  • Employee master list – default password 123123, bulk add, edit, delete.
  • Leave application form – selects type, dates, reason.
  • Approved report – exportable PDF for audits.
  • History – timeline view of every past submission for transparency.
  • Password change – enforces credential hygiene.

Black-Box Test Matrix (Table 1)

  • 1919 functional cases executed; all returned “Successful.”
    • Examples: submit request, reset annual balance, print reports.
  • Confirms alignment with requirements and indicates readiness for production use.

Conclusion

  • Transitioning from manual to web-based leave systems yields measurable gains in efficiency, accuracy, transparency, and employee satisfaction.
  • Waterfall’s disciplined stages ensured on-time delivery within clearly scoped requirements.
  • Findings & artifacts provide a reproducible blueprint for other organizations aiming to modernize HR workflows.

Ethical / Practical Implications

  • Data privacy: system must comply with employment laws and safeguard personal records.
  • Change-management: training & communication critical to user adoption; resistance mitigated via intuitive design.
  • Business continuity: real-time system reduces downtime risk during peak leave periods (e.g., national holidays).

Connections to Foundational Principles

  • Aligns with Systems Theory (Bertalanffy): holistic integration of people, processes, technology.
  • Reflects Software-Quality Metrics (Kan 20022002): defect reduction, reliability, usability.

Real-World Relevance & Scalability

  • SMEs and large enterprises alike can deploy low-cost stacks (Apache/MySQL) to achieve HR digital transformation.
  • Modular design allows future add-ons: mobile app, single-sign-on, analytics dashboards.

References (cited in transcript)

  • Bassil Y. (20122012); Chen X. et al. (20192019); Dutta & Sarkar (20162016); Jalote (20052005); Kan (20022002); Lee & Lee (20172017); Petersen et al. (20142014); Pressman (20142014); Rumbaugh et al. (20042004); Sommerville (20112011); Sommerville & Sawyer (19971997); Yourdon (19891989); Zhang et al. (20182018).