BESTLINK COLLEGE OF THE PHILIPPINES

1071 Brgy.Kaligayahan Quirino Highway,

Novaliches, Quezon City

COLLEGE OF COMPUTER STUDIES

Leave Management

Human Resources III

Bachelor of Science and Information Technology

A Project presented to:

Mr. Erwin, Concepcion

Leave Management

By
Sulaiman, Norjanna A.

Student Information System-Human Resources 3Page 1

Chapter 1
1.0 Project Background
Leave Management is a recording all the leaves and controlling these against leave
policies that defined in the HR system. And it has the ability to record or track employee
leaves. Also, there is a capability to define different types of leaves and corresponding
rules applicable to an application. And leave management will help you based your
performance appraisal on accurate information since there is no chance of human error
through the employee leave management. Leave management is one of the simplest yet
crucial HR activities that often consumes a significant portion of the HR team’s time. HR
personnel have to ensure compliance with leave policies, guarantee the availability of
sufficient staff at all times and also make sure that employee satisfaction is retained. Leave
management, also called time-off management, is the set of processes that controls the
application, approval and tracking of employee leave in an organization. Tasks include
routing the application through multiple decision-makers, notifying payroll, and
communicating with employee attendance records and organizational time-off or leave
policies.

1.1 Project Charter

Leave Management is the process of managing all the information of leave.

1.1.1 Vision
To build and produce a reliable, efficient and user-friendly system that will help the
stakeholder and the user with their duties and works especially on the employee
management field. The developers will provide a system with high security and with
smooth process for the exchange of data’s and information. Promote the technology and
automated works to continue the growth and development of stakeholders. Ensure that the
process effective and the process should maximized that will ensure that transaction are
properly recorded and reported.

1.1.2 Objectives
 To manage information leave. Adding and updating of records improve the
result in proper resource management of leave data.
 To provide for an automated leave management that intelligently adapts to HR policy of
organization and allows employees and their line managers to manage leaves and
replacement for better scheduling of work load & processes.
 To develop a system which have an effective leave management module that will help
ease in filling all sorts of leave.

Student Information System-Human Resources 3Page 2

1.1.3 Project size estimate
 The company's system needs to develop within 1 to 2 weeks to keep the clients
satisfied.
 The Proposed system is connected to Core Human Capital to pass the leave report.
And connected to also Timesheet Management to get their employee record. Leave
Management is also connected to Shift and Schedule Management to pass their
request schedule and connected also to ESS for employee to see what happened to
their request if granted or not granted

1.1.4 Project complex estimate

Leave Management are link to another module, to get the information needed to systematized
the leave types.

1.1.5 Scope
 The system is an online leave management system for leave applications review
process usable in any organization and customizable to be used in different
business environments. A dynamic database will be used to hold all leave
applications details and keep data in a way that it can be viewed by management to
make prompt informed decisions on approvals and staffing levels. A simple interface
will be in place making it easy and simple to use for all employees and management.
A comprehensive documentation to assist in the maintenance, customizing and
adding more modules to the system.
 Leave Management tracks the workers leave information and the HR or the
Supervisor may grant or deny the request leave of the workers.

1.1.6 Organizational
ROLE NAME CONTACT RESPONSIBILITIES
INFORMATION
Project Erwin Conception ☞ Serve as a superiority and accountable for the
Owner project.
☞ Solutions, technology and team facing.
Collocated with team(s)
☞ Manage the stakeholders requirements.
☞ Ensures the product backlog is maintained and
current.
☞ Promote continuous improvement methods.
☞ Approves the release
Leave Sulaiman, Norjanna A. ☞ Leave rule defining engine for setting the leave
management rule according to company policy.
☞ Balance information for all leaves types.
☞ Online access for Leave Application.
☞ Online access for Department Head and HR for
approval’s.

Student Information System-Human Resources 3Page 3

 ☞ Instant access for Leave Balance details on your
finger tips for all levels.
☞ Leave cancellation request.
☞ Encashment application and approval features.
☞ Hierarchy based calendar view for leave status.
☞ Intelligent leave analyzer.
☞ Customizable leave types.
☞ Real time information captured on leaves for
your team members.
Stakeholders User Clients ☞ They are benefactors for the projects.
☞ Help to improve the system to a better way.

1.1.8 Resources
The project is the design and implementation of an interactive World Wide Web-based. Leave
Management System for the Human Resources Department at Bestlink College of the
Philippines. The leave Management System automates the process of managing and tracking
multiple types of employee leaves. Employees are able to submit the leave form, cancel
previously submitted leave request, check the status of leave request and view completed
leave transactions. The Leave Management System maintains a database to keep a running
balance of each employee’s account, accrues employee vacation and sick credits and
provides individual reports on employee leaves accruals.

1.1.8 Approach and Methodology

The Agile Scrum Methodology is a method to
create a software project. It has series of sprint
which has a multiple tasks with restricted time
duration to develop a functional system.
A. Brainstorming (Requirement Analysis)
The team first identifies the highest-level
processes and then the sub-processes
within each high level process.

B. Design (Design Document &

Prototype)
After the initial planning and ideation, the product manager and the designer will
begin to engage with the development team. Throughout the program, visual and
interaction design is iterative just like software architecture.
C. Development (Iteration, Demo, & Feedback)

Student Information System-Human Resources 3Page 4

 Describes an approach to software development under which requirements and
solutions evolve through collaboration effort of self-organizing and cross-functional
teams and their costumers/end-users.

D. Quality Assurance (Identify Defects & Resolve Bugs)

It is the set of activities aiming to build quality into the final product. It involves every
participant in the lifecycle of a product development, at any level and prevents the
defects that would arise before the development cycle ends.
E. Deployment (Production & Technical Support)
May be seen as simple another testing step since multiple development deployment
are performed between production deployments. QA “user” deeply involved in
improving the system by providing frequent feedback.
1.1.9 Priorities
We will prioritize gathering information and there we will base our information and we will
learn how this company processes. And to enhance the flexibility of leave management
system as rapidly to satisfied the employee.

1.1.10 Project roadmap

The status of this system is still ongoing. It may take - 3 months for the entire system
outcome.

1.1.11 Assumption and Constraints

Student Information System-Human Resources 3Page 5

 The company system is connected to the main person to collect data or records of
employees there is no limit to collecting data or records from employees but the leave
management request form has claims limitation and payment is also limited.
 Leave Management is the one can create employee leave what type of leave it is and
when the date to start and finish, And can view the record of employees submitted leave.
 Employee request cannot be approved simply because HR analyzed the request.

1.1.12 Risk and issues

RISK FACTOR PROBABILITY (H- IMPACT (H- RISK MANAGEMENT PLAN
M-L) M-L)
Calamity Risk M H Lack of personality meeting with
members, using communication
gadgets to stay connected with
each other.
User Risk M M Policy or Guiding for user

Security Risk M M Providing always check and

upgrading security to insure the
confidential information

1.1.13 Sign off

Leave management are responsible for the monthly sign-off the manual attendance card
are abandoned. The leave management will ensure an annual sign-off applying the
automated report generated in system.

1.2 PROJECT PLAN

Task name Responsibl Start Days End Status

1.3 e for this
project
Data Gathering and Sulaiman, 01/15/2020
Research for Document. Norjanna A
Working with Document Sulaiman, 2/22/2020
Norjanna A
Create Product Roadmap Sulaiman, 2/23/2020
Norjanna A
Create System Process Sulaiman,
Architecture Norjanna A
Create Business Sulaiman,
Architecture Norjanna A

SYSTEM ARCHITECTURE

Student Information System-Human Resources 3Page 6

A system architecture or systems architecture is the conceptual model that defines the
structure, behavior, and more views of a system. An architecture description is a formal
description and representation of a system, organized in a way that supports reasoning about
the structures and behaviors of the system.

1.3.1 BUSINESS PROCESS ARCHITECTURE

A Business Process Architecture is the overview of a set of business
processes that reveals their inter-relations, which may be extended with guidelines to
determine the various relations between business processes.

EMPLOYEE SELF TIMESHEET

SERVICE MANAGEMENT

LEAVE
REQUEST
RECORDS
EMPLOYEE
INFORMATION
LEAVE MANAGEMENT

1.3.2 APPLICATION ARCHITECTURE

In information systems, applications

architecture or application architecture is one of
several architecture domains that form the
pillars of an enterprise architecture. An
applications architecture describes the
behavior of applications used in a business,
mfocused on how they interact with each other
and with users

1.3.3 DATA ARCHITECTURE

Student Information System-Human Resources 3Page 7

 In information technology, data architecture is composed of models, policies, rules or
standards that govern which data is collected, and how it is stored, arranged, integrated,
and put to use in data systems and in organizations.

Student Information System-Human Resources 3Page 8

1.3.4 TECHNOLOGY ARCHITECTURE
The technology architecture describes the infrastructure required to support
applications, operations, and reporting requirements. ... A framework for building an
enterprise including networking, hardware, operating systems, database management
systems, and application development

ADOBE PHOTOSHOP 2017

☞ Edit all pictures.

MS Paint

☞ Edit all pictures.

Java NetBeans 8.2

☞ Use for making a project.

MS SQL Server 2014

☞ For Integration
☞ For Database

SMS Gateway

☞ For verification

Student Information System-Human Resources 3Page 9

Chapter 2
2.0 PRODUCT BACKLOG
Product backlog which is another form of Software Requirement Specification in Agile
methodology is groomed by converting every wish list i.e. requirements – functional as
well as non-functional to User Stories and prioritizing them.

Product Backlog is further used as base for project/Sprint planning

2.1 PRODUCT BACKLOG (USER STORIES) TABLE

2.1.1 USER STORY NUMBER Priority R
User User Stories User Requirements Revision Status
Story Story Reference Priority
No.
1 As a user, I want to have Types of Leave
Types of Leave so that I can
create new types of leave.

LEAVE FORM
2 As a user I want to create Leave Records
Leave Records so that I can
be able to retrieve and view
employee leave records.

RECORDS FORMS
3 As a user I want to have Leave Request
Leave Request so that I can
be able to view the list of
request and set the status .

REQUEST FORMS
4 As a user, I want to have Leave Balance
Leave Balance so that I can
be able to view the remaining
balance of each employee.

BALANCE SHEETS
5 As a user, I want to know if Notification
employees have request , so
that I can create Notification
for their request.

NOTIFICATION FORMS

Student Information System-Human Resources 3Page 10

2.2 PRODUCT BACKLOG FOR EIS INFORMATION SECURITY TABLE
User Story User Stories User Requirements Revision Status
No. Story Reference Priority
Priorities
1 As a User , I
want to create
login with
restrictions so
that some
users only can
access it
2 As a User , I
want Leave
Management to
integrate to
employee self
service to
request
3 As a User , I
want Leave
Management to
integrate so
that it can be
monitor the
employees
leave by
percentage
4 As a User , I
want to have a
strength
password just
like solving
problem so that
the exclusively
choosen
person can
access our
system
5 As an User , I
want to have
Leave
Management
so that the
system to have
leave and User
can set Leave

Student Information System-Human Resources 3Page 11

2.3 PRODUCT BACKLOG FOR EIS STANDARDS TABLE

User User User Story Requirements Revision Status

Story Stories Priorities Reference Priority
No.
As an User ,
I want to
have Leave
Manageme
nt so that
1
the system
to have
leave and
User can
set Leave
As a User , I
want Leave
Manageme
nt to
integrate to
2 employee
self-service
to request
leave so
that can file
a easily
As a User , I
want Leave
Manageme
nt to
integrate so
3 that it can
be monitor
the
employees
leave by
percentage
As a user, I
can accept/r
eject
4 leave based
on work
requirement
.

Student Information System-Human Resources 3Page 12

2.3.1 UI/UX (ICONS, COLOR, ETC)

USER
USER STORIES REVISED
STORY USER STORIES STATUS
PRIORITIES PRIORITIES
NUMBER
As a user, I want to
see the icons and
1 button that may use On-going
in the templates of
the system.
As a user, I want to
see a well-defined
color combination of
2 the template so that I On-going
will know if it is
appropriate to the
eyes.

2.3.2 MESSAGE

USER
USER STORIES REVISED
STORY USER STORIES STATUS
NUMBER PRIORITIES PRIORITIES
As a user, I want to
create a notification
message to all
1 module so that they On-going
can notify me on
their concerned
and inquiries
As a user, I want
to create
notification
2
messages for the
Ongoing
system to see the
unknown user

2.3.3 DATABASE

USER USER STORIES USER REVISED ST

STORY STORIES PRIORITIES AT

Student Information System-Human Resources 3Page 13

 PRIORITIE
NUMBER US
S
As a user, I want to view all the On-
1 database of the system so that I can goin
monitor the database g
As a user, I want to create database On-
2 so that the employee view the data goin
need. g
As a user, I want to have an access On-
3 to the database so that I will know if goin
their any anomalies g

2.4 PRODUCT BACKLOG FOR EIS INTEGRATION TABLE

EIS EIS REVISED

STAT
INTEGRATIO EIS INTEGRATION STORIES INTEGRATION PRIORITIE
US
N NUMBER PRIORITIES S

As a user, I want to integrate

On-
1 each sub-system so that I can
going
make it a dynamic

As a user, I want all sub-

system can transmit data for
On-
2 each other so that the system
going
will be utilize and have
integration
As a user, I want to view the
integration universalize log in
form so that if the moderator
3
want to view all the sub
system it can be use one log
in form for it.

2.5 PRODUCT BACKLOG FOR EIS ANALYTIC TABLE

USER REVISED
ANALYTIC STAT
USER STORIES STORIES PRIORITIE
NUMBER US
PRIORITIES S
As a user, I want to see a
dash board in the system so On-
1
that I will see what type of the going
leave is the higher

Student Information System-Human Resources 3Page 14

 As a user, I want to have a
analytic system table so I will On-
2
know what is the status of going
leave of employee

2.5.1 APPLICATION SYSTEM ANALYTICS

Applications systems analysts specialize in creating and implementing applications for
functional programs or business initiatives. They can work in a variety of industries, including
financial institutions and healthcare organizations. Applications systems analysts usually
work full-time in an office setting.

2.5.2 EIS ANALYTICS

In general, EIS are enterprise-wide DSS that help top-level executives analyze, compare, and
highlight trends in important variables so that they can monitor performance and identify
opportunities and problems. EIS and data warehousing technologies are converging in the
marketplace.

Student Information System-Human Resources 3Page 15

CHAPTER 3
3.0 SPRINT BACK LOG
This is simply the list of things (again in priority order) that the team thinks they can do in the
current Sprint. This is chosen by the team (pull) not by managers (push).

Student Information System-Human Resources 3Page 16

3.1 SPRINT BACKLOG TABLE
3.1.1 USER STORIES
USER
USER RESPONSIBLE
STORY USER
TASK (a….n) STORY TEAM
NUMBE STORIES
POINTS MEMBER
R
As a user, I
want to see the
performance
1. View the record of
record of
employee
employee so
1
that I can see
2. View the performance
the changes of
changes
attendance of
each
employee
As a user, I
want to
improve the
performance of
leave 1. Improving the
2
management performance of system
system for the
quickly
satisfaction of
employee.
As a user, I
want to create 1. Create the performance
3
a performance rate
rate
As a user, I
want to see the
list of each
4 1. Estimate the rate
employee the
estimate the
leave type rate
3.1.2 INFORMATION SECURITY TABLE

IS IS
RESPONSIBLE
NUMBE DESCRIPT TASK (a…..n) IS POINTS
TEAM MEMBER
R ION
1. Create a design from
Make a login form
1 Programmer
login form 2. Put a codes in the
design of a login form
2 Create a 1. Choose an appropriate programmer

Student Information System-Human Resources 3Page 17

 design
strengths
2. Code the design
password
3. Create button for
for the
password
system
4. Connect to the database
1. Create button for
Make refreshment of
refresh password
3 Programmer
button for 2. Code the button
password 3. Create a confirmation
message
1. Analyze security to use
for the information
2. Apply the existing
security
Information
4 3. Test if it works and if it programmer
security
can protect the
information
4. If it is approved apply
security on the system
1. Enter username
Data
5 2. Enter password Programmer
Security
3. Wait for log in access
1. Set up the system
2. Create login form for
6 Login Form different users. Programmer
3. Create design for login
form
1. Enter username
Security Programmer
7 2. Enter password
Login
3. Access Denied
3.1.3 EIS STANDARDS TABLE

STANDARD EIS RESPONSIB

STANDAR
DESCRIPTIO TASK (a…..n) STANDARD LE TEAM
D NUMBER
N POINTS MEMBER
Normalization 1. Gather all the data
of Data needed
2. Do the 1st normalization
3. Do the 2nd normalization System
1
4. Do the 3rd normalization Analyst
5. Do the 4th normalization
6. Put a primary key in
every table
2 Make a 1. Visualize the appropriate System
template color combination Analyst
design 2. Put a function for every
icon and button

Student Information System-Human Resources 3Page 18

 3. Put a logo of the
company
Make a 1. Put icons/button that
button and used in every module
Icons transaction
2. Put a readable/ System
3
understandable picture Analyst
for every buttons
3. Have a function every
buttons
Make a 1. collect all the date
Database needed
2. Normalize all the
collected data
3. Do the database schema System
4
of your EIS Analyst
4. Put all the data in the
table
5. Connect to Database
SQL
Generate 1. Gather all the data
Report 2. Make a report System
5
3. Generate all the reports Analyst
collected

3.1.4 EIS INTEGRATION TABLE

RESPONSI
INTEGRATIO INTEGRATION INTEGRATION
TASK (a……n) BLE TEAM
N NUMBER DESCRIPTION POINTS
MEMBER
Create an 1. Collect data for each
integrated module of subsystem
system 2. Make a database for
1 each subsystem Programmer
3. Put all the data in the
database of the
system
Make a system 1. Create employee ID
that transmit 2. Create database
2 Programmer
data for each 3. Code the send and
other received button
1. Create universal login
View the form for EIS
integration 2. Connect to the
3 Programmer
universalize general database
login form 3. Code the login form
4. Design the template

Student Information System-Human Resources 3Page 19

3.1.5 ANALYTICS TABLE

ANALYTIC ANALYTIC ANALYTIC RESPONSIBLE

TASK (a…..n)
NUMBER DESCRIPTION POINTS TEAM MEMBER
View the 1. Create a dashboard
dashboard for the system
1 2. Connect the dash Programmer
board to the database
3. View the dashboard
Make a gantt 1. Identify the module
chart for all that had a graph for
2 programmer
module hr analytics
2. Create database

3.2 SPRINT BURNDOWN CHART

Leave Management

Student Information System-Human Resources 3Page 20

 Sprint Burndown Chart

3.3 SPRINT BACKLOG OUTPUT TABLE

3.3.1 TASK NUMBER

3.3.2 TASK NAME
3.3.3 OUTPUT
3.3.4 TEST RESULT
3.3.5 ACCEPTED BY PRODUCT OWNER

Student Information System-Human Resources 3Page 21