Skip to main content

Biometric Integration

Advantage:  Manual work of importing employee attendance regularly can be avoided. System will automatically pull the data from sql server and update the attendance according to the sync pattern defined.

There are three steps required to do the settings.

1. creating System DSN  - to pull data from biometric database

2. Import configuration   - mapping the biometric database fields to HCM  

3. Workflow Definition - for Auto sync biometric data

Follow the steps for DSN creation.

1. Create DSN system for attendance table. 

Path: C>>Windows>>SysWOW64>>odbcad32>>system DSN

click on add button to create DSN system

image

2.Create new data source screen will be opened, select SQL server from the list.

image

3. Enter Name, description and select SQL server from the drop down button after selecting click on next button.

image

4. Enter login ID and password from the next screen as shown below

image

5. Select the database where the attendance table is saved.

image

6. Click on next button and finish. DSN file is created.

Settings in HCM

1. Go to import option from Settings>>Data management>>import

Select module name, layout name and mapping file details. Select file format as SQL server.

Under file selection, enter the exact DSN name as mentioned in the database.

image

2. Once all the details are entered, in the next tab, attendance details can be mapped against every field.

image

3. Select the date and time format from filter options tab

image

4. Under preview button, check for any validations and save the file.

image

Workflow

1. First define the Autosync pattern.

Path: Settings>>Approval>>Sync Pattern

Enter the template name, description and details like the sync pattern. In the below screen, sync pattern is defined for daily at 19:00.

image

2. Define work flow.

Path: Settings>>Approval>>work flow

Select predefined action checkbox, select swipecardimport option for execute on, evaluate on periodic and select the template name as defined and map the sync pattern from the drop down box as below.

image

Automatically employee attendance will be synced regularly as per the settings.

User has the option to forceful sync the attendance basis any particular employee or paygroup using sync swipe data screen.

Path: Settings>>Data Management>>Sync Swipe Data

image

Labels:

Comments

Post a Comment

Popular posts from this blog

TDS details in Payslip

TDS variables are added in the payslip to display the tax details for employees. These variables will give a clear idea to the employee of what is the taxable income, total tax per year to be deducted, tax deducted till date and the balance tax which he needs to pay. Follow the steps below. 1. Create the payroll components as mentioned below under Deductions. TDS_TotalTaxableIncome TDS_TotalTax TDS_PrevEmployerTDS TDS_TaxDeductedYTD TDS_BalanceTax 2. Go to deduction preferences, and add the TDS variable exactly with the same name under formula. Below is the screen shot for reference. 3. The values of TDS variables will be displayed in the payroll preview screen. The same will be displayed in the payslip, once these variables are mapped to the payslip. Note: 1. Priority Order: TDS variables should be placed after TDS component. Sample Payslip with TDS variable:
3 comments
Read more

Advance Leave Encashment

This option is for leave encashment for advance leaves. There are two scenarios here: 1. If payment type is selected as continuous in leave encashment screen, then the leave encashment salary will be credited through the payroll. 2. If payment type is selected as advance in leave encashment screen, then the leave encashment salary will not be credited through payroll but in the print layout, encash amount can be viewed. Settings>>Customization>>Leaves>>Leave Encashment>>Print layout Note: Employee Account and Salary Account should be mapped in the Employee master Follow the below steps for FA posting: 1. Create two account master fields in leave encashment screen as shown in the below screen. In the above two screens, two accounts are created. One is Company account in the first screen and Emp account in the second screen. Employee account is created to credit the encash amount and add these two fields in page layout of leave encashment. 2. Run below stored pro...
Post a Comment
Read more

Using Stored Procedure in the Earning/Deduction Formulas

Naming Convention : Stored Procedure Name : pPay_GetData1 Variable to use above stored procedure : fPay1 Advantages: we can assign multiple earning/deduction values using single stored procedure Eg : CREATE PROCEDURE pPay_GetData1 (      @xmlIn AS XML = NULL      ,@xmlOut AS XML = NULL OUT      ,@Result AS DECIMAL(18, 4) OUT      ) AS BEGIN      SET NOCOUNT ON;      SET @xmlOut = @xmlIn     DECLARE @EmpId AS VARCHAR(max),@PayrollRefType AS VARCHAR(100)      declare @ToDate as int=0     declare @BonusFromDate as int=0,@BonusToDate as int=0     --Retriving Employee Id      SELECT @EmpId = v.value('iEmpId[1]', 'varchar(max)')      FROM @xmlIn.nodes('/PayrollData') x(v)     --Retriving Payroll Date      SELECT @ToDate = v.value('...
Post a Comment
Read more