PAYROLL DATA FLOW

ADMIN MODULE:-

User Master

Application:

New - Administrator can create the Login User’s from

New Toolbar Button
Edit - Administrator can edit the Login user’s details
from Edit toolbar button
Save - New login user’s details can save from Save
toolbar button
Delete - Administrator can delete the existing user’s
details from delete toolbar button
Print - User’s can print the existing user’s list details
from print toolbar button

Database:

Store Procedure - rUser

Tables - tblusermst
 User Rights

Form Description:

An administrator can assign the user rights to the entire user’s using User
Rights form.

Application:

Tree view - This control used for display the all the menus and
submenus.
New, Save, Edit, Search, Print, Cancel - This checkbox are used for assign the toolbar rights.
Save - Administrator can save the user rights to user from
Save button

 Database

Store Procedure - sGetUserRights, sDeleteUserRights, sSaveUserRights

Tables - tblUserRights, tblUserMst

 Report Master

Form Description:

An administrator can create the new report code and Report name. And also Edit,
Print and delete the existing report details.

Application:

New - An administrator can create the new report

name.
Save - Administrator can save the new report from
Save button.
 Database
Store Procedure - HPayReportMstSave
Tables - TblReportMst
 Report Details

Form Description:
An Administrator can select the Reports column name, width, Alignment, etc.

Application:

Report Name - To select the report name from report list.

Grid Control - Administrator can select the column name.
 And assign the width, alignment, priority
wise sort the columns.
 Database
Store Procedure - ReportDetailSave
Tables - TblReportMst, tblreportdtl
 Master Module:-

Company Master

Tables Used: - tblCompanymst.

Procedures Used: - rCompanyDet, rCompanyMstdelete, rCompanysave.

Views Used: - kPurchaseunit.

Functionalities:-

New: - Enter the New company.

Edit: - Update the previously added company details.

Save: - Save the new or updated company details.

Cancel: - Cancel the current updated details.

Exit: - Exit the form.

 Category Master

Tables Used: - tblCategoryMst.

Procedures Used: - HCategorySave.

Functionalities:-

New: - Enter the New Category.

Edit: - Update the previously added category details.

Save: - Save the new or updated category details.

Delete: - Delete the required category details. The respective category is deleted if it is not added
into any Employee’s details.

Cancel: - Cancel the current updated details.

Exit: - Exit the form.

 Department Master

Tables Used: - tblDeptmst

Procedures Used: - HDepartmentSave

Functionalities:-

New: - Enter the New Department.

Edit: - Update the previously added Department details.

Save: - Save the new or updated Department details.

Delete: - Delete the required Department details. The respective Department is deleted if it is not
added into any Employee’s details.

Cancel: - Cancel the current updated details.

Exit: - Exit the form.

 Designation Master

Tables Used: - tblDesgmst

Procedures Used: - HDesignationSave

Functionalities:-

New: - Enter the New Designation.

Edit: - Update the previously added Designation details.

Save: - Save the new or updated Designation details.

Delete: - Delete the required Designation details. The respective Designation is deleted if it is not
added into any Employee’s details.

Cancel: - Cancel the current updated details.

Exit: - Exit the form.

Employee Master:-
Tables Used: - tblPayEmployee, tblPayempPaydtl, tblPayempleavedtl, tblPayempFamilydtl.

Procedures Used:-
APayEmployeesaveorEdit, APayemployeeRetrieveorDelete, APayEmpFamilydtlSaveorEdit,
ApayEmpFamilydtlRetrieve, APayEmpLeaveDtlRetrieve, APayEmpLeaveDtlsaveorEdit,
APayEmpPaydtlSaveorEdit, APayEmpPaydtlRetrieve.

Functionalities:-

New: - Enter the new Employee details.

Edit: - Update the existing employee details.

Save: - Save the new or updated details.

Delete: - The required employee details are made inactive.

Cancel: - Cancel the current updated details.

Exit: - Exit the form.

Fields Information:-

 Employee code id is auto-generated and incremented by itself, when EmpCode label is

clicked then the employee details will be loaded into the respective controls.

 Employee father name is a compulsory field.

 The area, city, country details can be populated if the respective names are saved once.

 The Benefits details should be saved if it is given. The PF, ESI numbers should be filled
if they are given to the employee.

 The Loan approval, Incentive should be set to yes if those provisions are provided for the
employee.

 The remuneration should be entered in the grid.

 The Qualification and leave details should be entered.

 The photo of the employee can be uploaded.

Note: - Any changes made to employee’s Benefit details, remuneration and leave details will
affect the whole Payroll Process.
Employee Master (Personal Info Tab)

Employee Master (Remuneration Tab)

 Pay Period

Tables Used: - tblPayPeriodmst

Procedures Used: - HPayPeriodmstSave, HPayPeriodDelete

Functionalities:-

Edit: - Set the respective Active month in the grid.

Save: - Save the respective details edited.

Cancel: - Cancel the respective details edited.

Exit: - Exit the Form.

 Leave Master

Tables Used: - tblPayLeavemst.

Procedures Used: - HPayLeavemstSave

Functionalities:-

New: - Enter the new Leave details

Edit: - Update the previous details added.

Save: - Save the new leave details.

Delete: - Delete the required Leave details. The respective Leave is deleted if it is not added into
any Employee’s details.

Cancel: - Cancel the updated details.

Print: - Take the printout.

Exit: - Exit the form.

 Holiday Master

Tables Used: - tblPayHolidaymst

Procedures Used: - HPayHolidaymstsave, HPayHolidaymstDelete

Functionalities:-

Edit: - Enter the new holiday details.

Save: - Save the new holiday details.

Cancel: - Cancel the updated details.

Print: - Take the printout.

Exit: - Exit the form.

 Tax Master

Tables Used: - tblPayTaxdtl, tblProfTaxmst, tblProfTaxdtl

Procedures Used: - HPayTaxDelete, HPayTaxmstSave.

Functionalities:-

Edit: - Enter the new Tax details.

Save: - Save the new Tax details.

Cancel: - Cancel the updated details.

Print: - Take the printout.

Exit: - Exit the form.

 Pay Component

Tables Used: - tblPayHeads, tblePayHeads, tblResult, tblGResult.

Procedures Used: - HPayHeadsSave, HPayHeadsSaveD, HPayHeadsDelete,

HPayHeadsDeleteD.

Functionalities:-

Edit: - Enter the new pay component.

Save: - Save the Earnings Pay component added in the grid into tblpayheads and its earnings
component in tblepayHeads and the pay heads column and their earnings field is added into the
tblResult and tblGresult. Before saving the Earnings pay code the earn flag should be set to true,
Otherwise it will not allow to save the pay code.

Save the Deduction Pay component added in the grid into tblpayHeads and their respective fields
are saved into tblResult. Before saving the Deduction pay code the deduct flag should be set to
true, Otherwise it will not allow to save the code.

Delete: - The – symbol present below the grid will delete the respective earning pay component
and then press save. The respective pay code columns will be deleted from the tblResult and
tblGResult.

The – symbol present below the grid is used to delete the deduction pay component, when it is
clicked the respective pay code is deleted from the table and its column will be deleted from the
tblResult.

Cancel: - It cancels the previous edit done.

Print: - Prints the Earnings pay code.

Exit: - Exits the Form.

 Shift Master

Tables Used: - tblPayShiftmst

Procedures Used: - HPayShiftmstSave, HPayShiftmstDelete.

Functionalities:-

Edit: - Enter the new shift master or previous edited shift details.

Save: - Save the edited shift details.

Delete: - The shift details are deleted.

Cancel: - The edited details will be canceled.

Print: - Prints the existing shift details.

Exit: - Exits the Form.

 Professional Tax Master

Tables Used: - tblPTmst

Procedures Used: - HpayPTSave

Functionalities:-

Edit: - Enter or update the slab and its respective tax.

Save: - Save the Edited slab and its details.

Cancel: - Cancel the Edited details.

Print: - Prints the Professional Tax Details.

Exit: - Exits the Form.

 Transaction Module:-

Daily Attendance

Tables Used: - tblPayEmployee, tblPayAttendBio, tblPayBioAttendance, tblPayDailyAttn

Procedures Used: - HPayBioAttendanceInsertUpdate, HPayBioDetails, HPayDailyattnDelete,

HPayDailyattnsave, HpayDlyattnRetrieve, HpayDlyattndelete, HpayLeaveRollBackcommit.

Functionalities:-

Form Load: - At this event all the employees name will be loaded into the grid.

 If the system name is not added into tblPayAttendBio then it will throw error.

 Before Loading Daily attendance form first enter the system name into tblPayAttendbio.

 In Date textbox the respective date’s attendance details you want to see should be typed.

 Go to Bio download by clicking Bio Download label.

 Type the network address of the Bio Down loader machine and machine no into the Bio
down loader.

 Click connect label.

 Click Users to view the username and their number.

 When you click Logs button all the details of the employees in time and out time of the
respective date entered will be loaded into grid.

 When Clear Logs button is clicked then a frame will be displayed. If you enter the
gblPassword i.e., the admin password then all the previous log details will be erased from
the machine. Before clearing the log details first check that all the previous date’s details
has been saved into tblPayDailyattn.

Edit: - Edit any employee’s details manually if it is required.

Save: - Save the Data into tblPayDailyattn.

Cancel: - Cancels the data loaded.

Exit: - Exits the Form.

Daily Attendance (Manual Entry)

Daily Attendance (Log Details)

 Monthly Attendance

Tables Used: - tblPaymonthlyattn, tblPayEmployee, tblPayLeavedtl, tblPayEmpLeavDtl

Procedures Used: - APayMonthlyattnRetrieve, APayMonthlyattnsaveorEdit

Functionalities:-

Form Load:-
 As soon as the form is loaded then all the employee’s monthly attendance details (i.e.,
Leave taken , Lop(Loss of Pay), Actual Work Days(No of Days Present(Full) + No of
Days Present(Half)) and Sundays in the respective month is displayed.

 The details displayed are of either the Confirmed employees or of Probation Employees.

 Select from the combo box both type of employees and then view and save the data.

Edit: - Edit the existing details if needed.

Save: - Save the monthly attendance details for two types of Employees.

Cancel: - Cancels the previously edited details.

Exit: - Exits the Form.

 Advance Entry

Tables Used: - tblPayAdvdtl, tblPayemployee, tblPayPeriodmst.

Procedures Used: - kPayadvanceSave.

Functionalities:-

Edit: -

 All the controls will be enabled.

 Select the required details of the employee for whom advance is to be given.

 Press Enter in the grid to retrieve Employee name from employee help.

Save: - Save the details.

Cancel: - Cancels the currently edited details.

Exit: - Exits the Form.

 Loan Entry

Tables Used: - tblPayLoandtl, tblPayemployee, tblPayPeriodmst.

Procedures Used: - kPayLoanSave.

Functionalities:-

Edit: -

 All the controls will be enabled.

 Select the required details of the employee for whom Loan is to be given.

 Press Enter in the grid to retrieve Employee name from employee help.

Save: - Save the details.

Cancel: - Cancels the currently edited details.

Exit: - Exits the Form.

Note: - If Loan Approval is not set to yes in Employee master table then that particular employee
name will not be retrieved for giving Loan.
 Allowance Entry

Tables Used: - tblPayallowdtl, tblPayemployee, tblPayPeriodmst.

Procedures Used: - HPayallowdelete, Hpayallowancesave, HPayallowRetrieve.

Functionalities:-

Edit: -

 All the controls will be enabled.

 Select the required details of the employee for whom allowance is to be given.

 Press Enter in the grid to retrieve Employee name from employee help.

Save: - Save the details.

Cancel: - Cancels the currently edited details.

Exit: - Exits the Form.

Note: - If Incentive is not set to yes in Employee master table then that particular employee name
will not be retrieved for giving Allowance.
 OT Hours Calculation

Tables Used: - tblPayOtherOt, tblPayemppaydtl, tblpayemployee, tblPayheads, tblPayDailyAttn

Procedures Used: - HPayIncentiveSave, HPayIncentiveRetreive, HRptOtherOt,

HOTAmountCalc.

Functionalities: -

Edit: -
 Enable the controls.
 Select the Employee name and No. of Ot hours he has worked when enter is pressed in
the grid.
 The Employee name is loaded from tblPayEmployee and Othours is loaded from
tblPayDailyAttn.

Save: -
 OTParameter is retrieved from tblPayParameterhdr.
 OTper is retrieved from tblPayEmployee.
 OTAmount is calculated and saved in tblPayOtherOt.

Cancel: - Cancel the current edited details.

Exit: - Exit the form.

Note: - Before saving the OT details check that Parameters are set properly for calculating the
OT.
 Increment Form

Form Description:
This form is used for assign the increment details to employees. Increment
details to set as a Pay heads

 Application:

Save - This toolbar button is used to save the employee

Increment details.

Delete - This toolbar button is used to delete the employee

Increment details.
 Database

Store Procedure - HPayIncrementSave, HPayIncrementUpdate

Tables - TblPayEmpPayDtl, TblPayEmployee, TblPayIncrement

Leave Available
Form Description:
This form is used to view the employee’s Leave available details.

 Database

Store Procedure - - Nil-

Tables - tblPayempLeaveDtl , tblPayLeaveMst,

tblPayLeaveAppDtl
 Leave Application Form

Form Description:
This form is used to apply the leave application to higher authority.

 Application:
New - To apply the new leave application form
Save - To save the leave application form details.
Delete - To delete the existing leave application form
 Database
Store Procedure - HPayLeaveAppFormSave,
HPayLeaveSanctionFormSave

Tables - tblPayLeaveAppForm, tblPayEmpLeaveDtl

Leave Status
Form Description:
This form is used to view the Leave Status of applied leave application form.

 Application:
From Date - To select the leave applied from date.
To Date - To select the leave applied to date.
Department - To select the department of leave applied person.

 Database
Store Procedure - - Nil-
Table - tblPayLeaveAppForm, TblPayEmployee,
TblDeptMst, TblDesgMst, tblcategorymst
 Leave Sanctioning

Form Description:
This form is used to sanction the leave of applied leave applications.

 Application:
Save - To save the leave sanction details of selected
App.Id
With Pay Option - This option button is used for leave sanction
with pay.
Without Pay Option - This option button is used for leave sanction
 without pay.
 Database
Store Procedure - HPayLeaveSanctionFormSave
Tables - tblPayLeaveAppForm, TblPayEmployee,
TblDeptMst, TblDesgMst, tblcategorymst,
tblPayempLeaveDtl
 Payroll Process

Tables Used: - tblResult

Functionalities:-

Form Load: -

 Click the check box.

 Select the Company Name.

 The Payroll will be processed.

Note: -

Before Processing the Payroll check that daily attendance is saved, Monthly attendance is
saved and Parameters are set properly for calculating the PF and ESI.
 Parameter Settings

Tables Used: - tblPayParameterhdr

Procedures Used: - HPayParRetrieve, HPayParHdrSave.

Edit: - Select the Fixed or Earnings pay component for calculating Pf, Esi and OT.

Save: - Save the Edited details.

Cancel: - Cancel the Edited details.

Exit: - Exit the Form.

Note: -
The entire calculation of the payroll is set in this page. If we want to include/exclude the
Sundays in the month can be set here.
 Pay Month Close

Tables Used: - tblPayPeriodmst

Form Load: -

 Select the month to be closed

 Enter the Password.

 Close the month.

 Parameter Config

Tables Used: - tblPayARSSetmst, tblPayARSSetdtl.

Procedures Used: - APayAARsParametermst, APayAARsParameterdtl.

Edit: - Enables the controls.

Load: - Load the minimum and maximum working hours for Full day and Half day.

Save: - Save the Edited details.

Cancel: - Cancel the Edited details.

Exit: - Exit the Form.

 Report Module:-

Employee Details

Description:
This report is used to display the employee details of the company. User can
generate the report Pay Period, Unit, Category, Department, Designation, Employee type
and Employee ID wise.

Database:
View - payEmpMstView

Tables - tblPayEmployee, tblCompanyMst,

tblDeptMst , TblCategoryMst ,tblDesgMst
 Employee Pay Heads

Description:
This report is used to display the employee fixed pay details. User can generate
the report Pay Period, Unit, Category, Department, Designation, Employee type and
Employee ID wise.

Database:

View - payEmpMstView
Tables - tblPayHeads, tblPayEmpPayDtl
 Daily Attendance Report

Description:
This report is used to display the Employee Daily Attendance details. User can
generate the report Pay Period, Unit, Category, Department, Designation, Employee type
and Employee ID wise.

Database:

Store Procedure - HRptDlyAttn

Tables - TblPayDailyAttn, TblPayLeaveMst,
TblPayDailyAttn, PayEmpMstView,
TblCategoryMst, TblDeptMst, TblDesgMst,
TblPayEmployee, TblCompanyMst
 Daily wages Report

Description:
This report is used to display the Employee’s Daily wages details for selected
date. User can generate the report Pay Period, Unit, Category, Department, Designation,
Employee type and Employee ID wise.

Database:

Store Procedure - HDailyWagesReport, HRptDlyAttnGroup,

 HRptDlyAttnGroupHalf

View - PayEmpMstView

Tables - TblPayDailyAttn, TblPayEmployee

 Weekly Payment Report

Description:
This report is used to display the Employee’s Weekly wages details for between
from and to selected date. User can generate the report Pay Period, Unit, Category,
Department, Designation, Employee type and Employee ID wise.

Database:

Store Procedure - SpWeeklyWagesReport

View - PayEmpMstView

Tables - TblPayDailyAttn, TblPayEmployee,

TblCompanyMst
 Monthly Attendance Report

Description:
This report is used to display the Employee’s Monthly Attendance details for
selected pay period. User can generate the report Pay Period, Unit, Category,
Department, Designation, Employee type and Employee ID wise.

Database:

View - payempmstview
Tables - tblPayMonthlyAttn, TblPayPeriodMst
 Monthly Advance Report

Description:
This report is used to display the Employee’s advance list for selected pay period.
User can generate the report Pay Period, Unit, Category, Department, Designation,
Employee type and Employee ID wise.

Database:
View - payEmpMstView

Tables - tblPayadvDtl
 Monthly Loan Details Report

Description:
This report is used to display the Employee’s Loans details for selected pay
period. User can generate the report Pay Period, Unit, Category, Department,
Designation, Employee type and Employee ID wise.

Database:
View - payempmstview
Tables - tblPayLoanDtl
 OT Details Report

Description:
This report is used to display the Employee’s OT details for selected pay period.
User can generate the report Pay Period, Unit, Category, Department, Designation,
Employee type and Employee ID wise.

Database:
View - payempmstview
Tables - tblresult
 Ultimate Salary Report

Description:
This report is used to display the Employee’s OT hours and amount for selected
pay period. User can generate the report Pay Period, Unit, Category, Department,
Designation, Employee type and Employee ID wise.

Database:
Store Procedure - HPayUltimateSal
Tables - tblresult, TblPayOtherOT,
TblPayEmployee
 Monthly Salary Summary Report

Description:
This report is used to display the employees earning, deduction and net pay of
salary for selected pay period. User can generate the report Pay Period, Unit, Category,
Department, Designation, Employee type and Employee ID wise.

Database:

View - payempmstview
Tables - tblresult, TblPayEmployee,
tblreportmst
 Monthly Salary Register

Description:
This report is used to display the employees earning, deduction and net pay of
salary some different format for selected pay period. User can generate the report Pay
Period, Unit, Category, Department, Designation, Employee type and Employee ID wise.

Database:

View - payempmstview
Tables - TblResult, tblreportmst,
Tblpayemployee, tblpaymonthlyattn
 Department wise Salary Summary

Description:
This report is used to display the department wise details of OT hours, OT amount
and net pay for selected conditions. User can generate the report Pay Period, Unit,
Category, Department, Designation, Employee type and Employee ID wise.

Database:

Tables - TblResult, TblDeptMst,

Tblpayemployee,
 Salary Slip Report and Preprinted Salary Slip

Description:
This report is used to display the employee’s salary slip of selected pay period.
User can generate the report Pay Period, Unit, Category, Department, Designation,
Employee type and Employee ID wise.

Database:

Store Procedure - HPaySlipDevi, HReportDetailsRet,

 HRptPaySlip
Tables - TblResult, TblPayPeriodMst,
TblCompanyMst,
View - PayEmpMstView
 Monthly PF Register Report

Description:
This report is used to display the employee’s PF details of selected pay period.
User can generate the report Pay Period, Unit, Category, Department, Designation,
Employee type and Employee ID wise.

Database:

Store Procedure - HPayPFRegRet

View - PayEmpMstView
 Monthly ESI Register Report

Description:
This report is used to display the employee’s ESI details of selected pay period.
User can generate the report Pay Period, Unit, Category, Department, Designation,
Employee type and Employee ID wise.

Database:
Store Procedure - HPayESIRegRet
Table - TblPayParameterHdr
View - PayEmpMstView
 Form 5 Report

Description:
This report is used to display the FORM-5 eligible employee’s details of selected
pay period. User can generate the report Pay Period, Unit, Category, Department,
Designation, Employee type and Employee ID wise.

Database:

Table - tblPayPeriodMst
View - PayEmpMstView
 Form 10 Report

Description:
This report is used to display the FORM-10 eligible employee’s details of selected
pay period. User can generate the report Pay Period, Unit, Category, Department,
Designation, Employee type and Employee ID wise.

Database:

Table - tblPayPeriodMst
View - PayEmpMstView
 Form 12 Report

Description:
This report is used to display the FORM-12 eligible employee’s details of selected
pay period. User can generate the report Pay Period, Unit, Category, Department,
Designation, Employee type and Employee ID wise.

Database:

Table - tblPayPeriodMst, tblcompanymst

View - PayEmpMstView
 Periodic Salary Report

Description:
This report is used to display the PayName, NetAmount, PfAmount, EsiAmount
of Selected pay period. User can generate report Company, Pay Period month wise.
Database:

Table - tblPayPeriodMst, tblResult

 Form 7 Report

Description:
This report is used to display the FORM-7 eligible employee’s details of selected
pay period. User can generate the report Company, Employee Id, Period and Year wise.

Database:

Store Procedure - HRptForm7

Table - tblPayPeriodMst
View - PayEmpMstView
 Form6 Report

Description:
This report is used to display the FORM-6 eligible employee’s details of selected
pay period. User can generate the report Company, Employee Id, Period and Year wise.

Database:

Store Procedure - HRptForm6

Table - tblPayPeriodMst
View - PayEmpMstView
 Form 3A Report

Description:
This report is used to display the FORM-3A eligible employee’s details of
selected pay period. User can generate the report Company, Employee Id and Year wise.

Database:

Store Procedure - HRptForm3A

Table - tblPayPeriodMst
View - PayEmpMstView
 Form 6A Report

Description:
This report is used to display the FORM-6A eligible employee’s details of
selected pay period. User can generate the report Company, Employee Id and Year wise.

Database:

Store Procedure - HRptForm6A

Table - tblPayPeriodMst
View - PayEmpMstView
 Loan on Date Report

Description:
This report is used to display the employee loan details of selected pay period.
User can generate the report Pay Period, Unit, Category, Department and Designation.

Database:

Table - TblpayLoanDtl, TblDeptMst

View - PayEmpMstView
 Bonus Report

Description:
This report is used to set and display the Employee Bonus Statement details.
Administrator can generate the report Pay Period, Year, Unit, Category, Department,
Designation, Employee type and Employee ID wise.

Database:

Store Procedure - bBonusRpt

Tables - tblPayPeriodMst, tblResult, tblPayPeriodMst
View - PayEmpMstView
 Increment Details Report

Description:
This report is used to display the Employee Increment Statement details. User can
generate the report Company, Pay Period, Unit, Category, Department, Designation,
Employee type and Employee ID wise.

Database:

Tables - tblPayIncrement
View - PayEmpMstView
 Settlement Details Report

Description:
This report is used to display the Employee Settlement details. User can generate
the report Pay Period, Unit, Category and Employee code wise.

Database:

Store Procedure - KPayLeave, KPayheaddeduct

Tables - tblPayParameterhdr, tblPayHeads,
 tblPayEmpPayDtl, TblPayEmployee,
TempResult, tblpayadvdtl, tblPayMonthlyAttn
tblPayLoanDtl
View - PayEmpMstView
 Leave Available Report

Description:
This report is used to display the Employee Leave Available details. User can
generate the report Pay Period, Unit, Category, Department, Designation, Employee type
and Employee code wise.

Database:

Store Procedure - SpLeaveAvailableReport

Tables - TblPayEmployee, tblpayempLeaveDtl,
tblPayLeaveMst
 Leave Sanction Report

Description:
This report is used to display the Employee Leave Sanctioned details. User can
generate the report Pay Period, Unit, Category, Department, Designation, Employee type
and Employee code wise.

Database:

Store Procedure - SpLeaveSanctionReport

Tables - TblPayEmployee, tblpayempLeaveDtl,
TblPayLeaveMst, tbldeptmst
View - PayEmpMstView
 Annual Census of Employees

Description:
This report is used to display the Annual census of employee’s details. User can
generate the report Company, Employee Id and year wise.

Database:

Store Procedure - HRptAnnCen

Tables - TblPayEmployee, PayEmpMstView,
 #TempAtt
View - PayEmpMstView
 Log Report

Description:
This report is used to display the employee’s log details. User can generate the
report Company, pay period, Category, Department, Designation, Employee type and
Employee Id wise.

Database:

Tables - TblPayEmployee, tblPayLogReport

 Database Backup

Database Used: - PayManSys

Functionalities:-

Form Load: -

 Click the check box.

 Enter the Global Password.

 Click Backup button

 The Backup operation is processed successfully.

Note: -
The daily database backup to be taken by administrator.