Programme Specs
For Payroll System
1
Table of Content
Sr. No Particulars Page No.
1. Payroll Login Page 3
2. Admin 4
2.1 Menu 4
2.2 System Setup 5
2.3 Update tax slab 6
2.4 Update tax slab for men 7
2.5 Update tax slab for women 8
2.6 Add/remove earning head 9
2.7 Add/remove deduction head 10
2.8 Salary setup 11
2.9 Update employee salary details 12
2.9.1 Landing page 12
2.9.2 Update page 13
2.10 Process payroll 14
3 Employee 16
3.1 Menu 16
3.2 Generate payslip 17
4 Top management 18
4.1 Menu 18
4.2 Generate report 19
2
1. Login Page
Screen
Screen Name Payroll Login
Trigger Type the intranet address of the site in the browser to access application
Pre-condition None
Field Level Validations
Field Name Validations Column Mapping
Usr_id 1. Compulsory. Emp_id
2. Not Null.
3. Numeric
4. Max Length = 5
Password 1. Compulsory. password
2. Not Null.
3. AlphaNumeric
4. Max Length = 12
Internal Flags
Table Name.Column Name Action
Employee_detail_tbl.emp_id Verify the emp_id & password
Employee_detail _tbl.password Verify the emp_id & password
Events
User Action System Response
Submit Button User enters employee id and System verifies the user id & password
password. Clicks button. combination & redirects to menu or login page
Clear Button User clicks on this button All fields are cleared
Post Condition As per the access rights, user will be directed to either admin page, employee
3
page or management page menu.
2. Admin
2.1 Menu
Screen
Screen Name Payroll Menu for Admin
Trigger Correct login or clicking ‘Home’ from any other page
Pre-condition User should be logged into the system and session should not have expired
Field Level Validations
Field Name Validations Column Mapping
Internal Flags
Table Name. Column Name Action
Events
User Action System Response
Click on Link User clicks on link Corresponding page open up
Logout Button User clicks on this button Session is invalidated. User is logged out of the
system
Post Condition Depending on the option selected user is taken to appropriate page
4
2.2 System Setup
Screen
Screen Name Payroll System Setup
Trigger Clicking on the System setup link from the menu page
Pre-condition User should be logged into the system as an administrator and session should
not have expired
Field Level Validations
Field Name Validations Column Mapping
Internal Flags
Table Name.Column Name Action
Events
User Action System Response
Post Condition User is taken to the page corresponding to the link clicked on
5
2.3 Update Tax slab
Screen
Screen Name Update Tax slab
Trigger Clicking on the “Update tax slab” link from the system setup page
Pre-condition User should be logged into the system as an administrator and session should
not have expired
Field Level Validations
Field Name Validations Column Mapping
Internal Flags
Table Name.Column Name Action
Events
User Action System Response
Post Condition User is taken to the page corresponding to the link clicked on
6
2.4 Update Tax slab for Men
Screen
Screen Name Update Tax slab
Trigger Clicking on the “Update tax slab for male” link from the “update tax slab” page
Pre-condition User should be logged into the system as an administrator and session should
not have expired
Field Level Validations
Field Name Validations Column Mapping
Internal Flags
Table Name.Column Name Action
Events
User Action System Response
Post Condition User is taken to the page corresponding to the link clicked on
2.5 Update Tax slab for Women
Screen
7
Screen Name Update Tax slab for women
Trigger Clicking on the “Update tax slab for women” link from the “update tax slab”
page
Pre-condition User should be logged into the system as an administrator and session should
not have expired
Field Level Validations
Field Name Validations Column Mapping
Internal Flags
Table Name.Column Name Action
Events
User Action System Response
Post Condition User is taken to the page corresponding to the link clicked on
2.6 Add/Remove earning head
Screen
8
Screen Name Add/remove earning heads
Trigger Clicking on the “Add/remove earning heads” link from the “menu” page
Pre-condition User should be logged into the system as an administrator and session should
not have expired
Field Level Validations
Field Name Validations Column Mapping
Internal Flags
Table Name.Column Name Action
Events
User Action System Response
Post Condition User is taken to the page corresponding to the link clicked on
2.7 Add/remove deduction head
Screen
9
Screen Name Add/remove deduction heads
Trigger Clicking on the “Add/remove deduction heads” link from the “menu” page
Pre-condition User should be logged into the system as an administrator and session should
not have expired
Field Level Validations
Field Name Validations Column Mapping
Internal Flags
Table Name.Column Name Action
Events
User Action System Response
Post Condition User is taken to the page corresponding to the link clicked on
2.8 Salary setup
Screen
10
Screen Name Define Salary structure
Table salary_master_tbl
Trigger Clicking on the link of “Define salary structure” in Payroll System setup page
Pre-condition User should be logged in the system and the session should not have expired.
User should be on Payroll System setup page.
Field Level Validations
Field Name Validations Column Mapping
Designation 1.Compulsory designation
HRA 1. Compulsory. hr_rate
2. Not Null.
3. Numeric value only, decimal allowed
TA 1. Compulsory. ta_rate
2. Not Null.
3. Numeric value only, decimal allowed
DA 1. Compulsory. da_rate
2. Not Null.
3. Numeric value only, decimal allowed
Allowance 1. Compulsory. allowance
2. Not Null.
3. Can be 0
4. Numeric value only, decimal allowed
PF 1. Compulsory. pf
2. Not Null.
3. Numeric value only, decimal allowed
11
Internal Flags
Table Name.Column Name Action
Events
User Action System Response
Submit Button User selects the designation System should successfully display a message
and enters the values for and update the data in database
earnings & deductions as a %
of basic salary and clicks on
update
Post Condition The user should be displayed with a successful message of give the necessary
warnings.
2.9 Update employee salary details
2.9.1 Landing Page
Screen
Screen Name Update Salary Information landing page
Trigger After entering the employee code click on continue
Pre-condition User should be logged in the system and the session should not have expired
12
Field Level Validations
Field Name Validations Column Mapping
Emp_id 1. Compulsory. Emp_id
2. Not Null.
Internal Flags
Table Name.Column Name Action
Salary_master_tbl.from Retrieve entire salary details
Events
User Action System Response
Submit Button User selects the period and Entire salary structure is displayed in editable
the employee id mode
Post Condition After click on update button user should be redirected to individual salary
structure page
2.9.2 Update Page
Screen
Screen Name Update Salary Information for employee
Trigger Clicking on the continue link from update salary information page
13
Pre-condition User should be logged in the system and the session should not have
expired
Field Level Validations
Field Name Validations Column Mapping
basic 1. Compulsory. from
Emp_id 1. Compulsory. Emp_id
2. Not Null.
Internal Flags
Table Name.Column Name Action
employee_salary_detail_tbl.basic Retrieve entire salary details
Events
User Action System Response
update button User selects the basic salary Entire salary structure is displayed in non-
from dropdown editable mode
Post Condition After updating the salary structure, the salary structure is updated in
employee_salary_detail_tbl table and a successful nessage is displayed
2.10 Process Payroll
Screen
Screen Name Process payroll
Trigger Clicking on the process payroll link from the menu page
14
Pre-condition User should be logged in the system and the session should not have expired.
Field Level Validations
Field Name Validations Column Mapping
month 1. Compulsory.
Internal Flags
Table Name.Column Name Action
Events
User Action System Response
Submit Button User selects the month from System will process the payroll for the selected
the drop down box and clicks month
on submit
Post Condition A new window opens with successful message with button for sending mail to
employees. On the click of the button mail should be dispatched to employees
whose salary has been processed.
15
3. Employee
3.1 Menu
Screen
Screen Name Payroll Menu for employees
Trigger Correct login or clicking ‘Home’ from any other page
Pre-condition User should be logged into the system and session should not have expired
Field Level Validations
Field Name Validations Column Mapping
Internal Flags
Table Name. Column Name Action
Events
User Action System Response
Click on Link User clicks on link Corresponding page open up
Logout Button User clicks on this button Session is invalidated. User is logged out of the
system
Post Condition Depending on the option selected user is taken to appropriate page
16
3.2 Generate Payslip
Screen
Screen Name Generate Report
Trigger Clicking on the print report link from the menu page
Pre-condition User should be logged in the system and the session should not have expired.
As per login rights the user should be redirected to employee salary page where
the user can view or download the salary slip for a particular month.
Field Level Validations
Field Name Validations Column Mapping
month 1. Compulsory. from
Internal Flags
Table Name.Column Name Action
Salary_master_tbl.from Parse the date value and retrieve the year
Salary_master _tbl.from Parse the date value and retrieve the month
Events
User Action System Response
Submit Button User selects the year and the The report for the corresponding period is
month from the drop down generated in a particular format
box and clicks on submit
17
Post Condition The salary slip is generated for the requested time month
4. Top Management
4.1 Menu
Screen
Screen Name Payroll Menu for Top level management
Trigger Correct login or clicking ‘Home’ from any other page
Pre-condition User should be logged into the system and session should not have expired
Field Level Validations
Field Name Validations Column Mapping
Internal Flags
Table Name. Column Name Action
Events
User Action System Response
Click on Link User clicks on link Corresponding page open up
Logout Button User clicks on this button Session is invalidated. User is logged out of the
system
Post Condition Depending on the option selected user is taken to appropriate page
18
4.2 Generate Reports
Screen
MIS_Report.xlsx
Screen Name Print Report
Trigger Clicking on the print report link from the menu page
Pre-condition User should be logged in the system and the session should not have expired.
As per login rights the user should be redirected to management report page
where the user can view or download the report for a particular month.
Field Level Validations
Field Name Validations Column Mapping
year 1. Compulsory. from
2. Not Null.
month 1. Compulsory. from
2. Not Null.
Internal Flags
Table Name.Column Name Action
Salary_master_tbl.from Parse the date value and retrieve the year
Salary_master _tbl.from Parse the date value and retrieve the month
19
Events
User Action System Response
Submit Button User selects the year and the The report for the corresponding period is
month from the drop down generated in a particular format
box and clicks on submit
Post Condition The report is generated in an excel sheet which is populated with the date for
the requested time period
20