NCalc 

Formula Code Description Sample Remarks
#B Basic Salary from Job Service
#CD Calendar Day Retro, Recurring Income, Express Entry: based on Transaction Date

Basic Salary: based on payroll cut off date
#SW Total Schedule Working Day from Duty Roster (Refer to Employee Profile > Calendar page)
#SP Total Schedule Public Holiday from Duty Roster (Refer to Employee Profile > Calendar page)
#SR Total Schedule Rest Day from Duty Roster (Refer to Employee Profile > Calendar page)
#SO Total Schedule Off Day from Duty Roster (Refer to Employee Profile > Calendar page)
#AWD Total actual working day from Timesheet where (TypeOfDay is Working && Absent is false) or TypeOfDay is Public Holiday
#AWP Total actual public holiday from Timesheet
#AWO Total actual off day from Timesheet
#AWR Total actual rest day from Timesheet
#DAY Payroll Transaction’s Day from Express Entry
#PDAY Prorated Day.

{Payroll Date} – {Employee’s Join Date}
#UNIT Payroll Transaction’s Unit from Express Entry
#HOUR_MIN Payroll Transaction’s Hour Minutes from Express Entry
#AMOUNT_EE Payroll Transaction’s Amount from Express Entry
#UDF.<SectionCode>.<InputCode> Get value from Employee’s User Defined Field.

Please go to Admin Setting > HR > User Defined Field Setting page to refer <SectionCode> and <InputCode>.

 #UDF.ADDPR.ALD
#LI Get total late in of attendances in hour minutes (HH.mm).

E.g. 1:45 => 16.45

 Use in Attendance Incentive, Service Charge Calculation
#LI_Min Get total late in of attendances in total minutes.

E.g. 1:45 => 105

 Use in Attendance Incentive, Service Charge Calculation
#EO Get total early out of attendances in hour minutes (HH.mm).

E.g. 0:45 => 0.45

 Use in Attendance Incentive, Service Charge Calculation
#EO_Min Get total late in of attendances in total minutes.

E.g. 0:45 => 45

 Use in Attendance Incentive, Service Charge Calculation
#OB Get total over-break of attendances in hour minutes (HH.mm).

E.g. 0:59 => 0.59

 Use in Attendance Incentive, Service Charge Calculation
#LI.<Minutes> Get total days where the attendance’s late in is more than <Minutes> minutes.

E.g. #LI.5 means get total days where the attendance’s late in is more than 5 minutes.

 #LI.5

#LI.10

 Use in Attendance Incentive, Service Charge Calculation
#EO.<Minutes> Get total days where the attendance’s early out is more than <Minutes> minutes.

E.g. #EO.5 means get total days where the attendance’s early out is more than 5 minutes.

 #EO.5 Use in Attendance Incentive, Service Charge Calculation
#OB.<Minutes> Get total days where the attendance’s over-break is more than <Minutes> minutes.

E.g. #OB.5 means get total days where the attendance’s over-break is more than 5 minutes.

 #OB.5 Use in Attendance Incentive, Service Charge Calculation
#LATE.<Minutes> Get total days where the attendance’s late in / early out / over-break is more than <Minutes> minutes.

E.g. #LATE.5 means get total days where the attendance’s late in / early out / over-break is more than 5 minutes.

 #LATE.5 Use in Attendance Incentive, Service Charge Calculation
#ABS Get total days where the attendance is absent. Use in Attendance Incentive, Service Charge Calculation
#OT Get total overtime hours of attendances in hour minutes (HH.mm)

p/s. Total overtime hours is get from table [ta_timesheet_overtime]

 Use in Attendance Incentive, Service Charge Calculation
#FM Get whether employee is works full month according to Incentive Cut Off.

Return 0 or 1.

0 = No, 1 = Yes

 Use in Attendance Incentive
#LD Get total days of leave transaction which the leave code is affected to Service Charge Calculation.

Please go to Admin Setting > Payroll > Service Charge Calculation Setting page to refer affected leave code list.

 Use in Service Charge Calculation
#BF Get bonus factor from table [pr_bonus_header]. Use in Bonus Calculation
L.#<LeaveCode> Get total day of leave transaction from table [lv_transaction_detail] L.#UPL
E.EmployeeGroup Get employee’s assigned group in string.

E.g. ‘AS’,’MS’,’TELE’

 When use it as in(‘MS’, E.EmployeeGroup), it will execute as in(‘MS’, ‘AS’, ‘MS’, ‘TELE’)
E.<ColumnName> Get employee data from table [func_hr_employee] E.employee_no

E.cost_center

E.pay_salary_count_by
X.#<PayrollTransactionCode>.<Value> Get payroll transaction data from table [pr_express_entry] X.#MSA.unit <Value>

  • Unit
  • Day
  • hour_min
  • fix_amount_employee
  • fix_amount_employer
  • Amount
  • amount_er
P.#<PayrollTransactionCode>.<Value> Get payroll transaction data from current payroll calculation table [service_temp_pr_transaction] P.#OT20.hour_min <Value>

  • Unit
  • Day
  • hour_min
  • fix_amount_employee
  • fix_amount_employer
  • Amount
  • amount_er
  • Amount_employee
  • Amount_employer
V.#<PayrollTransactionCode>.<Value> Get previous month payroll transaction data from table [pr_transaction] V.#OT15.amount_employee <Value>

  • Unit
  • Day
  • hour_min
  • fix_amount_employee
  • fix_amount_employer
  • Amount
  • amount_er
  • Amount_employee
  • Amount_employer