[IS_PLACEMENT_TYPE] - Is Placement Type

22-Aug-2022 · Cath Fung

What is this?

A Yes/No question variable.

Check Whether the Placement is assigned to a certain Placement Type. Placement Type Code would be used in the formula.

What will the Value be Returned?

Y - if the Placement is configured to be a specified Placement Type within the Pay Period.

N - if the Placement has no Placement Type defined or not the Placement Type specified within the Pay Period.

Usage

Hightlight part content can be changed

1. Basic Form

Check single Placement Type.

If the condition is correct, return the 1st value. Otherwise, returns the 2nd value.

Payroll Variable Description Usage
[IS_PLACEMENT_TYPE(Placement Type Code)] Check whether the Placement is configured to a specified Placement Type Only Staff Placement Type = Permanent would have HKD 1,000 allowance
IIF ('[IS_PLACEMENT_TYPE(Permanent)]'='Y',1000,0)

Staff Placement Type = PT would use 120 as pay rate. Staff with other Placement Type would use Average Daily Wages as pay rate
IIF ('[IS_PLACEMENT_TYPE(PT)]'='N',[ADW],120)

2. Parameters/Variations

Parameters/Variations Description Usage
| Check Multiple Placement Type [IS_PLACEMENT_TYPE(Permanent|Consultant)]