All of the payroll calculations are related to the employees. For example, company A will give different allowances according to the employees' positions, and company B will give bonuses according to the employees' years of service.

How does Workstem easily access this data for its payroll calculation?

The system provides a powerful function: GetEmployeeInfo('fieldName') can help you obtain relevant information about the employees. Here's how to use this function in more details.

Step 1

[Payroll] > [Settings] > [Pay Items] > [Settings].

Step 2

Click [Settings], go to [Pay Items], find the corresponding item that needs to set the formula, click [Formula], and go to [Pay Items] formula settings interface.

Step 3

Click [Functions], find GetEmployeeInfo, and we can look up its function description.

Note: 「Parameter description」'fieldName'

GetEmployeeInfo('fieldName') 'fieldName' Returned value type

'englishName' '英文名称' '英文名稱' String

'chineseName' '中文名称' '中文名稱' String

'email' '邮箱' '郵箱' Stirng

'entryDate' '入职日期' '入職日期' Date

'lastWorkingDate' '離職日期' '離職日期' Date

'countryCode' '地区编码' '地區編碼' String

'phone' '电话' '電話' String

'payrollRegulationName' '薪酬规则' '薪酬規則' String

'costCenterName' '成本中心' String

'basicPay' '基本薪酬' String

'takeEffectDate' '生效日期' Date

'birthday' '出生日期' Date

'positionName' '職位' String

'departmentName' '部門' String

'address' '住宅地区' '住宅地區' String

'code' '编号' '編號' String

'identityCard' '身份证' '身份證' String

'sex' '性别' 'male'

'female'

'status' '状态' '狀態' '0' stands for 'terminated'

'1'stands for 'employed'

'nationality' '国籍' '國籍' 'HK' stands for 'Hong Kong'

'MO' stands for 'Macao'

'TW' stands for 'Taiwan'

'CN' stands for 'Chinese mainland'

'SG' stands for 'Singapore'

'MY' stands for 'Malaysia'

'JP' stands for 'Japan'

'KR' stands for 'Korea'

'VN' stands for 'Vietnam'

'PH' stands for 'Philippines'

'ID' stands for 'Indonesia'

'AU' stands for 'Australia'

'maritalStatus' '婚姻状况' '婚姻狀況' '0' stands for 'unmarried'

'1' stands for 'married'

'2' stands for 'divorced'

'3' stands for 'widowed'

'hireType' '受僱形式' '0' stands for 'full time'

'1' stands for 'temporary'

'2' stands for 'freelance'

'3' stands for 'part time'

'4' stands for 'contract'

'5' stands for 'internship'

'6' stands for 'virtual employee'

'calculateSalaryType' '计薪形式' '計薪形式' '0' stands for 'monthly wage'

'1' stands for 'hourly wage'

'2' stands for 'yearly wage'

'3' stands for 'daily wage'

'4' stands for 'weekly wage'

Example:

GetEmployeeInfo('englishName') Obtain employee’s English name.

GetEmployeeInfo('code') Obtain employee’s code.

GetEmployeeInfo('entryDate') Obtain employee’s entry date.

GetEmployeeInfo('calculateSalaryType') Obtain employee’s salary type, returned value ‘0’ stands for monthly wage, ‘1’ stands for hourly wage, ‘2’ stands for yearly wage, ‘3’ stands for daily wage, and ‘4’ stands for weekly wage.

Did this answer your question?