Payroll System

PAYROLL SYSTEM

Manage EMP Information

Employee

Data Entry Employee

Fig 3.1 Use Case for Manage EMP Information

Calculate Payroll

Manage Salary History

Generate Pay Slip

Account Officer

Generate Reports

Fig 3.2 Use Case Payroll Calculation & Payslip Generation

Employee

Review Salary History

Upload Pay slip to portal Generate Reports Senior Account Officer

Fig 3.3 Use Case for Salary History & Reports Generation

Assign/ Update Role

Maintain System

Review Log File Controller Of Finance Review the Reports

4.2.1

Context Diagram

Fig 3.4 Use Case for the Controller of Finance

Employee

Employee’s Personal Details

Reports

Payroll System

Employee’s Personal Details

Pay Slip

Fig 4.1 Context diagram 4.2.2

Information Flow ( Data Flow Diagram)

System User

Employee Detail

1.0 Payroll System

Pay-Slip

Reports

Fig 4.2 Level – 0 (DFD)

Employee

Accounting Department

EMP PAY_MASTER

EMP

P inf ayr o orm ll ati on

System User

il

1.1 Calculate salary

_no

Net Salary

p Em

Deta Emp

Emp_no

1.2 Generate Pay-slip

Net Salary

Pay-slip Pay-slip Detail

Emp _no

1.3 Generate Reports Payroll Reports

Fig 4.3 Level – 1 (DFD)

1.1.1 Calculate Gross Earning ID P_ EM

To ta Am l Gro o u ss nt

System User Calculate net salary

EMP_PayMaster EM P_ ID

Net S ala ry

1.1.2 Calculate Deduction

ion uct d De nt ta l o u To Am

Pay Slip

Fig 4.4 Level – 2 (DFD)

1.1.1.1 Calculate Allowances lA ta To ce an w llo

ID P_ EM

System User EMP_PayMaster

Calculate Gross Amount

EM P_ ID tal

Net Sala ry

To

1.1.1.2 Calculate Basic (Salary+ DP)

Pay Slip

Fig 4.5 Level – 3 (DFD) Loan_Bank

E

System User

_I D MP

EMP_ID

1.1.2.1 Calculate Loan Installment

1.1.2.2. Other Deduction

EM P_ ID

an I

ns t al

lm

en t

Am ou n

t

Othe

r De d Amo ucti on unt

x Ta me nt o c u In mo A

Calculate Overall Deduction

Deducted Amount

1.1.2.3 Calculate Income Tax

Lo

Pay Slip

IT_Annual

Fig 4.6 Level – 3 (DFD)

4.3.3 ER Diagram

USER_NAME

COMPANY/ ORGANIZATION EMP_CODE (P)

PASSWORD HAVE

EMPCOMPANY

User Role DEPT_NO(P)

ACC_NO

USERINFO

PANNO DEPT_NAME EMPPERSONAL

M

EMPLOYEE

STATUS

M

DEPARTMENT

HAS

1

EFFECTIVE DATE

SALARY

M

EMPCONTACT RECIEVES

GIVENDATE

M

M

1 INCTYPE

M

PAYSLIP

M

HAVE

WORKS ON DESIGNATION

1

M

NET SALARY

1

GROSS SALARY

BANK ACCOUNT NO

DEDUCTION

HAS

HELD

DESIGNATION

1

EMPPAYMASTER

SALARYGRADE

DESIGNATION DESIG_NO(P)

1

1

EMP_CODE BASICPAY CONTAINS INCOME

LOAN

DEDUCTIONS

STARTING

INCREMENT

1

OT_MASTER LOANDATE LOAN INSTALLMENT BALANCE

OT_CODE

LOANAMOUNT LOANTYPE

OT_RATE

Fig 4.7 ER Diagram

ENDING