Please enable JavaScript.
Coggle requires JavaScript to display documents.
smart payroll system, sps_db - Coggle Diagram
smart payroll system
Admin
Login
Add single employee
view,edit,delete,export data
accept leave request from employee
add bulk employee details though excelsheet
download excel sheet,upload excel sheet,view
add salary details for single employee
view
add salary details through excelsheet
download excel sheet,upload excel sheet,view
rule builder
edit allowance
edit deduction
edit contribution
payroll process
single employee
All employees
view salary
export data
view salary detals of particular employee
payslip
attendance
dowload excel sheet,upload,view
single employee attendance
approve leave
loan
approve loan
logout
employee
login
view employee details
view salary details
apply loan
apply leave
logout
request to admin (edit employee details)
sps_db
salary
id(pk)
fk_user_id
da
hra
total_allowance
gs
emp_pf
cmp_pf
emp_esi
cmp_esi
total_deduction
net_sal
monthly_ctc
professional_tax
salary_date_time
created_date
updated_date
user_personal_details
id(pk)
fk_user_id
bank_Acc_no
ifsc_code
bank_name
aadhar
pan
address
status
created_date
updated_date
fk_designation_id
user
id(pk)
name
fname
lname
email
phone
password
user_type
admin
employee
status
created_date
updated_date
joining_date
emp_id
config_master
id(pk)
component_name
percentage
value
description
status
created_date
updated_date
lv_details
id(pk)
fk_user_id
fk_leave_id
from_date
to_date
status
approve
reject
created_date
updated_date
leave_type
id(pk)
title
number of days
status
created_date
updated_date
designation
id(pk)
title
manager/SDE!
created_date
updated_date
basic_salary