Steps involved to capture time automatically in WebPay

Steps involved to capture time automatically in WebPay

1. Enter the Employee in biometric database either manually or create a schedular to capture the employees from WebPay database.

Whenever an employee is inserted in Webpay a column(Updation_flag) in Employee Master table  is ‘N’.

Updation_flag Char(1) Default 'N'

To create the schedular to capture the employees from WebPay database you can use this flag and make that ‘Y’ after capturing. 

2. Send the punch time data in TrnPunchTime table whenever a punch is made in biometric machine. For this use the following table structure:

Table Name TrnPunchTime

Column_Name       Type        Length      Description

Pk_Id             BigInt      -           Identity Column (Auto Generated)

fk_emp_code       VarChar     10          Employee Code

DeptccCode        VarChar     10          StaffID / CardID

TrnDate           DateTime    -           Punch DateTime

Note: You only need to send TrnDate as datetime and fk_emp_code in case card id and employee code is same or DeptccCode in case card id is different from employee code. No need to send both fk_emp_code and DeptccCode.

3.  Whenever you insert the punch time record in TrnPunchTime table remember to insert all the previous punch time records in WebPay database which are not inserted in WebPay database due to network failure or any other disinterruption between the two databases.

Blog by BBSPL

Difference between Pension wage and EDLI wage

Difference between Pension wage and EDLI wage

The employee whose PF is deposited but pension is not deposited are included in EDLI wages.  Reason can be attainment of pension limit age of 58.

For e.g

Employee E0001 has a Basic wage of 10000 but no Pension is desposited, 100% amount is deposited as EPF. Let's take 10000 as Basic Wage for E0001. Employee's PF is deposited on the basis of actual basic and not the 6500 limit.


Employee E0002 has a Basic wage of 6500 and Pension is also desposited. In this case 6500 is PF / Basic Wage and 6500 is pension wage for E0002.

And to calculate EDLI, we consider 6500 for both the employees.

Therefore in above example:
Basic Wage is 16500 (10000 + 6500)
EDLI Wage is 13000 (6500 + 6500)
But Pension wage is 6500 (6500)

Remember  EDLI wage is also limited to 6500 like Pension.


Blog by BBSPL

Changes in Report Builder

Changes in Report Builder

Please download the Presentation file from here.

Some important changes have been done to the report builder, which are explained in the slides along with the snapshot.

You will also find some slight change in looks of Report Builder.

Some Important Changes:
a). Sorting
b). 3 level Grouping
c). Edit Reports

Blog by BBSPL